What is a database view and what are its limitations compared to a base table?

Question

Advanced SQL Developer — Medium

What is a database view and what are its limitations compared to a base table?

Accepted Answer

A database view is a named stored SELECT query presenting a virtual table. The correct answer explains that views have limitations such as not being able to be updated if they contain certain operations like aggregates or JOIN without a key-preserved table.