Skip to main content

defaultSQLSerializers

const defaultSQLSerializers: SQLSerializerRegistry

Defined in: expr/src/functions/sql.ts:14

Built-in "sql" serializers: arithmetic (+ - * /, infix and parenthesized for precedence safety), variadic min/max, binary mod, unary abs, and string upper/lower. Each serializer is opts-first ((opts, ...args) => string); the built-ins ignore opts except min/max, which vary by SQL preset.

min/max emit LEAST/GREATEST by default (PostgreSQL, MySQL 8+, Oracle, and SQL Server 2022+ / Azure SQL), overridden to the scalar MIN/MAX for the sqlite preset. Older SQL Server (pre-2022) has no row-wise scalar equivalent and falls back to LEAST/GREATEST.

caution

API documentation is generated from the latest commit on the main branch. It may be somewhat inconsistent with official releases of React Query Builder.