The escape character in CrateDB is the single-quote '. A character gets
escaped when adding a single-quote before it. For example a single quote
character within a string literal can be included by writing two adjacent
single quotes, e.g. 'Jack''scar'.

Note

Two adjacent single quotes are not equivalent to the double-quote
character ".

A widely used convention is to write key words in uppercase and identifiers in
lowercase, such as

ALTERTABLEfooADDCOLUMNnew_columnINTEGER;

INSERTINTOfoo(id,name)VALUES(1,'bar');

Quoted identifiers can contain an arbitrary sequence of charactes enclosed by
double quotes ("). Quoted identifiers are never keywords, so you can use
"update" as a table or column name.

Note

It is even possible to create column names that look like subscript notation,
e.g. "column['looks_like_nested']". When querying the information schema,
the colum name would look identical as a nested object column!

An SQL input can contain comments. Comments are not implemented on the server
side, but the crash command line interface ignores single line comments.
Single line comments start with a double dash (--) and end at the end of
that line.