Views are saved SELECT queries you can query like a table. CREATE VIEW simplifies complex queries for reuse. Views do not store data — they execute the underlying query each time they are accessed.
Creating Views
-- Create a reusable query
CREATE VIEW active_users AS
SELECT id, name, email FROM users WHERE is_active = TRUE;
-- Use like a table
SELECT * FROM active_users;
-- Updatable view
CREATE OR REPLACE VIEW active_users AS
SELECT id, name, email FROM users WHERE is_active = TRUE;
DROP VIEW active_users;