Why do we need views?

Views exist to simplify working with a database and improve convenience and security.

#Why they're used

1. They simplify complex queries. A long SELECT can be saved once and used like a regular table.
2. They hide unnecessary data. A user only sees the fields they need, and the rest stays hidden.
3. They improve code readability. Instead of bulky subqueries, you use a short view name.
4. They keep logic consistent. If business rules change, updating one VIEW is enough instead of dozens of queries.

In short, views are ready-made "windows" onto the data, a convenient way to look at the part of the tables you need.