Have you worked with views in SQL and used them in your projects?

Views in SQL are virtual tables that are formed based on the result of a query. They do not store data themselves but display data from one or more tables.

I used views to simplify complex queries and provide a level of abstraction. For example, you can create a view that combines data from multiple tables and offers a convenient interface for reading, hiding the complexity of joins and filters.

Example of creating a view:

CREATE VIEW active_users AS
SELECT id, name, email
FROM users
WHERE status = 'active';

This view can be used in queries just like a regular table:

SELECT * FROM active_users WHERE email LIKE '%@example.com';