Zeroturnaround Sql Formatter Versions Save

A whitespace formatter for different query languages

v15.3.1

3 weeks ago

Bugfixes

  • Added ^@ operator for PostgreSQL #734

v15.3.0

2 months ago

New dialect

  • TiDB Support (#724)

Bugfixes

  • Properly detect PostgreSQL TEXT as data type (#726)
  • Format DEFAULT VALUES clause for PostgreSQL (#720)
  • Format PRIMARY KEY and GENERATED constraints in PostgreSQL (#714)

v15.2.0

3 months ago

Larger change in PostgreSQL keywordCase handling

  • Removed almost all of PostgreSQL non-reserved keywords #709

The keywords list that's used for uppercasing keywords is now much smaller. This will lead to some keywords not being uppercased any more. But it will eliminate several cases where table and column names were detected as keywords and uppercased.

v15.1.3

3 months ago

Bugfixes

  • Allow for keywords after : operator in Snowflake #706

v15.1.2

3 months ago

Bugfixes

  • Fix tabular formatting for CREATE TABLE #690

v15.1.1

3 months ago

Bugfixes

  • Format Transact-SQL OPTION () clause on a separate line #705
  • Format Transact-SQL FOR clause on a separate line

v15.1.0

3 months ago

New features

  • Add support for disable/enable comments to turn off formatting for sections of SQL file #703
  • Allow passing inline JSON config object from command line (e.g. --config '{"keywordCase": "upper"}') #701

Bugfixes

  • Treat ASC,DESC as reserved words in "sql" dialect #702
  • Fix crash when database..table syntax encountered in Transact-SQL #700

v15.0.2

5 months ago

Bugfix

  • Export KeywordCase and DataTypeCase types

v15.0.1

5 months ago

Bugfix

  • Improve IDENTIFIED BY formatting in MySQL, MariaDB & SingleStoreDB (#691) Thanks to eeXun

v15.0.0

5 months ago

Breaking changes

  • The keywordCase option no more applies to data types.
  • The identifierCase option no more applies to function names.
  • New formatting style of CREATE TABLE (#495) Thanks to Timon Jurschitsch
  • New formatting style of CREATE VIEW
  • When using custom dialects: TokenizerOptions has new mandatory reservedDataType field.

New features

  • Added functionCase option (#237) Thanks to Karl Horky
  • Added dataTypeCase option (#653) Thanks to Karl Horky

Bugfixes

  • Support *.* syntax in MySQL GRANT statements (#674)
  • No more treat some common table/field names in PostgreSQL as keywords (#156)
  • Allow type to be used as identifier in PostgreSQL (#685)