Skip to main content


The values clause allows creating an inline table that is available only for a single SQL statement and is not persistent in the database. This helps with creating self-sufficient auto-generated SQL that can be quickly tried out.

SQL Generation

A temporary table name is assigned when auto generating the SQL. This table name changes every time this page is accessed. It is possible to explicitly specify the schema name of the table. See TABLE on how to do this.