You can create local views with the Create View statement. A view is like a named query. The view can also refer to any combination of other views.
Note: Local views are objects in the driver’s in-memory SQL Engine, not a native MongoDB collection. For information on native MongoDB views, see MongoDB views.

See "Supported SQL statements and extensions" for details on the Create View statement and other SQL statements supported by the driver.