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).
SYSDATE() is the current timestamp in UTC. https://docs.snowflake.com/en/sql-reference/functions/sysdate
Backslash-escapes \, % and _, for platforms whose LIKE uses backslash as the default escape.
A conditional expression.
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.
Escapes backslashes as well as quotes, since a backslash starts an escape sequence in a '…' string.
The prefix a string literal holding text needs so no character is lost, or ''.
Writes Snowflake SQL:
"…"identifiers, backslash-safe literals,LIMIT,DATEADD.