ClickHouse: reverse() reverses BYTES, not characters, which breaks
multi-byte text; reverseUTF8(expr) is used instead for correctness.
Oracle: no built-in REVERSE function for strings; there is no safe
single-expression workaround (would require a hierarchical
CONNECT BY LEVEL query), so this throws.
DB2: no built-in REVERSE scalar function in Db2 for LUW; throws for
the same reason as Oracle.
Redshift: not present in Redshift's documented string-function list
(Redshift's SQL dialect is derived from an old Postgres release that
predates Postgres's REVERSE); throws rather than risk incorrect SQL.
Reverse a string.
REVERSE(expr).reverse()reverses BYTES, not characters, which breaks multi-byte text;reverseUTF8(expr)is used instead for correctness.REVERSEfunction for strings; there is no safe single-expression workaround (would require a hierarchicalCONNECT BY LEVELquery), so this throws.REVERSEscalar function in Db2 for LUW; throws for the same reason as Oracle.REVERSE); throws rather than risk incorrect SQL.REVERSEfunction; throws.