A boolean literal.
CAST(expr AS sqlType).
A cast of expr to the dialect's unbounded text type.
The n-ary null-coalescing expression.
Concatenates string expressions.
The string concatenation operator, or null when the dialect has none (it uses a function).
The current UTC timestamp.
Adds amount units to a timestamp expression.
Backslash-escapes \, % and _, for platforms whose LIKE uses backslash as the default escape.
A conditional expression.
The two-argument null-coalescing expression in the dialect's native spelling.
Extracts a scalar value from a JSON column; path is in the dialect's own path syntax.
The row-cap fragments for limit rows after skipping offset.
Optionaloffset: numberLower-cases an expression.
Writes a column alias so the result column keeps the alias's case.
Quotes an identifier, escaping the closing quote character inside it.
Writes a schema-qualified object name.
Writes value as a string literal that the dialect reads back as exactly value.
The prefix a string literal holding text needs so no character is lost, or ''.
Writes standard SQL. Each dialect's writer extends this and overrides only what its database spells differently.