Regular view specifications are supported.
CREATE [ OR REPLACE ] VIEW view_name [ '(' column_name [ ',' ...')' ] ]
[ WITH CHECK OPTION ]
A view can be seen as a stored SELECT query. It is useful to reduce query complexity as it can include joins, unions and aggregations, increase standardisation and reusability and support server-based reporting.
Note: Recursive views and reference-able views are not supported.
Note: You can't insert, update, delete or truncate data from a view. Updatable views are not supported.