A boolean literal.
CAST(expr AS sqlType).
A cast of expr to the dialect's unbounded text type.
SQL Server supports COALESCE as an ANSI-standard alternative to its
native ISNULL. The two differ subtly in return-type inference and
argument arity (COALESCE is n-ary; ISNULL is two-arg only). Use
this helper when codegen needs the n-ary form or when caller intent
is ANSI-portable rather than T-SQL-native.
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.
SQL Server has both ISNULL (T-SQL native, two-arg only) and COALESCE
(ANSI, n-ary). For two-argument null-coalescing we emit the native
ISNULL form so generated SPs match the conventional T-SQL idiom and
the data-type-of-first-argument semantics callers may already rely on.
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.
SQL Server identifiers are case-insensitive by default, so a bare alias preserves the requested casing when echoed in result-set column metadata. Bracketed quoting would also work but is unnecessary.
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 T-SQL: bracket quoting,
TOP,BITbooleans,ISNULL,+concatenation.