Basics
This page gives a basic overview on PolySQL, the SQL dialect of Polypheny.
Identifiers
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
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