A boolean literal.
CAST(expr AS sqlType).
CAST(… AS CHAR): MySQL does not accept VARCHAR as a cast target. https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
The n-ary null-coalescing expression.
Concatenates string expressions.
|| is logical OR unless PIPES_AS_CONCAT, so MySQL concatenates with CONCAT().
The current UTC timestamp.
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.
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 escapes the next character in the default SQL mode.
The prefix a string literal holding text needs so no character is lost, or ''.
Writes MySQL: backtick identifiers, backslash-safe string literals,
LIMIT,CONCAT().