Small. Fast. Reliable.
Choose any three.

create-view-stmt

CREATE TEMP TEMPORARY VIEW IF NOT EXISTS schema-name . view-name ( column-name ) AS select-stmt ,

Used by:   sql-stmt

References:   select-stmt

See also:   lang_createview.html