Unlike relational tables which store data, views store predefined queries that return a result set, and since they look like regular tables we also called virtual tables.
What problem does it solve?
Views have several advantages, the one I appreciate more is that they improve database security and integrity given the fact we can use them to display only the columns we want to particular users, for example.
Proposal
Until now, migrations deal only with tables. I think we should add the possibility to create views also.
Brief history
Unlike relational tables which store data, views store predefined queries that return a result set, and since they look like regular tables we also called virtual tables.
What problem does it solve?
Views have several advantages, the one I appreciate more is that they improve database security and integrity given the fact we can use them to display only the columns we want to particular users, for example.
Proposal
Until now, migrations deal only with tables. I think we should add the possibility to create views also.
Relevant links
https://www.w3schools.com/sql/sql_view.asp