npm / sql-formatter

sql-formatter

What changed in sql-formatter 15, from its official release notes, upgrade guides and advisories. Sources checked 2026-10-18.

1 breaking6 new APIs and options1 performance6 behavior and defaults7 fixes and other

See which of these apply to your code, ranked, in your agent:

npx @unstale/cli init

sql-formatter 1521 changes

The modulo operator is now supported in SingleStoreDB.
15.9.0release notes
The parser now supports the pg_dump commands \restrict and \unrestrict.
15.9.0release notes
Adds the missing OPENJSON Transact-SQL function.
15.7.3release notes
sql-formatter supports the CORRESPONDING keyword on Trino set operations.
15.7.2release notes
Clickhouse SQL dialect is now supported.
15.7.0release notes
Adds support for PostgreSQL 18 UUID functions.
15.6.12release notes

Parsing long SQL expression lists avoids quadratic accumulation.
15.9.0release notes

Formatting now keeps spaces around PostgreSQL OPERATOR() when denseOperators is enabled.
15.9.0release notes
Formatting keeps the colon dense inside [] for DuckDB array slices.
15.9.0release notes
A reserved word after AS is now treated as an alias.
15.9.0release notes
BigQuery formatting now always keeps spaces around the - operator.
15.8.2release notes
PostgreSQL formatting now supports keywords in CREATE CONSTRAINT TRIGGER.
15.8.0release notes
SQLite formatting now supports Tcl-style $param(...) syntax.
15.7.4release notes

Formatting removes the extra space after BETWEEN _ AND _ expressions.
15.9.0release notes
Formatting now keeps a space when densing - before a negative operand.
15.9.0release notes
Fixed an idempotency issue with block-comment placement.
15.8.1release notes
Fixes formatting of the >^ geometric operator.
15.7.3release notes
Adds missing PostgreSQL operators.
15.7.3release notes
Properly formats TIMESTAMP WITH TIME ZONE in Trino.
15.7.3release notes
Formats COMMENT ON as keywords in PostgreSQL.
15.6.11release notes