This page gives a basic overview on PolySQL, the SQL dialect of Polypheny.


Identifiers are the names of tables, columns, indexes and other metadata elements used in a query. Identifiers must start with a letter and can only contain letters, digits, and underscores. They are implicitly converted to lower case.

If an identifier name clashes with a reserved keyword, the name needs to be quoted. Quoted identifiers, such as "user", start and end with double quotes.


Strings need to be embedded in single quotes ('). To use a single quote within a string, it must be escaped by doubling it. Example:

INSERT INTO test VALUES (1, 'A single quote '' needs to be doubled')

This will insert the string:

A single quote ' needs to be doubled