sql-formatter-org/sql-formatter v15.9.0

15.9.0

on GitHub

Parsing improvements

• Support \restrict and \unrestrict commands found in SQL created by pg_dump (#935) (thanks to sophalter)
• Treat a reserved word after AS as an alias (#801, #972) (thanks to Christopher Pruijsen)
• Support % as the modulo operator in SingleStoreDB (#578, #971) (thanks to Max Freedom Pollard)

Formatting improvements

• Keep a space when densing - before a negative operand (thanks to Sarath Francis)
• Keep spaces around PostgreSQL OPERATOR() with denseOperators (#958) (thanks to Sarath Francis)
• Remove extra space after BETWEEN _ AND _ expression (#959) (thanks to Sarath Francis)
• Keep DuckDB array-slice colon dense inside [] (#960) (thanks to Vincent Gao)

Performance

• Avoid quadratic accumulation when parsing long SQL expression lists (#840, #963) (thanks to Alex Coleman)