What is a sqlite view ?

But bear in mind that a VIEW has the exact same performance overhead as the QUERY contained within the view.
A VIEW takes up no database space to speak of (the space is taken up already by what ever tables are refernence in the VIEW).

This is NOT to be confused with the benefits of a MATERIALIZED VIEW (not supported by SQLIte, but found in DB’s such as ORACLE)

https://forum.xojo.com/5264-sqlite-views/0