sql-formatter-org/sql-formatter v14.0.0

14.0.0

on GitHub

Breaking changes

These already deprecated features were fundamentally broken and have been removed for good:

• Removed tabulateAlias config option.
• Removed commaPosition config option.

Potentially breaking:

• The DB2 support has been completely overhauled. Previously it was a mix of features from DB2 for IBM z mainframe and DB2 for LUW (Linux, Unix, Windows). Now the dialect named "db2" specifically targets the LUW variant.
• Snowflake dialect now includes all data types in the keywords list. Which means that when keywordCase: upper option is used, the data type names are also converted to uppercase. (#641)
• The SqlLanguage type is no more just a plain string (a regression), but a union of the builtin SQL dialect names.
• The DialectOptions type now includes a mandatory name field. (Relevant only when implementing a custom dialect.)

New features

• New experimental identifierCase config option. This works similarly to the existing keywordCase option. (Thanks to Christian Jorgensen.)

Bugfixes

• Various tweaks and fixes for the new DB2i dialect (introduced in 13.1.0).
• Fixed formatting of TIMESTAMP() WITH TIME ZONE in PostgreSQL (#618)
• Improved error messages from the parser to help users self-diagnose the most common issues.