When to use Sql View?

It's recommended to use a Sql view when the Sql is complex. It's essentially a virtual table, of which that is defined as a SQL SELECT query with joins. Because a database view is similar to a database table, which consists of rows and columns, so you can query data against like an actual database table.

Another benefit is that you can then reuse this view. Additionally, if you use a view instead of a joined tables, in the future if you need to change a column, you can easily do that and only require changes to the Sql view.

Feedback and Knowledge Base