A boolean literal.
CAST(expr AS sqlType).
A cast of expr to the dialect's unbounded text type.
PostgreSQL's n-ary null-coalescing is also COALESCE. Same form as
the two-arg IsNull since PG has no ISNULL to differentiate from.
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.
PostgreSQL has no ISNULL keyword; the standard is COALESCE (which
SQL Server also supports). PG generated SPs/functions emit COALESCE
everywhere a null-coalescing wrap is needed.
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.
PostgreSQL folds unquoted identifiers to lowercase, which would turn
AS EntityName into the result column entityname. Quoting the
alias preserves the requested casing for callers that key off the
column name (e.g. when consuming results into a TypeScript object
with a PascalCase property). Any embedded " is doubled ("→""),
for consistency with QuoteIdentifier — an alias sourced from an
untrusted name can't break out of its quoting.
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 PostgreSQL: double-quote identifiers,
LIMIT/OFFSET, native booleans,->>JSON.