Oracle has no boolean SQL type before 23ai; 1 and 0 work in every release.
CAST(expr AS sqlType).
The n-ary null-coalescing expression.
Concatenates string expressions.
The string concatenation operator, or null when the dialect has none (it uses a function).
Backslash-escapes \, % and _, for platforms whose LIKE uses backslash as the default escape.
A conditional expression.
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 Oracle SQL:
"…"identifiers,FETCH FIRST,NVL,NUMTODSINTERVAL. Oracle LIKE has no default escape character, so a pattern from EscapeLikePattern (backslash escapes) must be followed byESCAPE '\'.