sql-formatter-org/sql-formatter (sql-formatter)
### [`v14.0.0`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v14.0.0): 14.0.0
[Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v13.1.0...v14.0.0)
##### 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](https://togithub.com/sql-formatter-org/sql-formatter/issues/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](https://togithub.com/sql-formatter-org/sql-formatter/issues/618))
- Improved error messages from the parser to help users self-diagnose the most common issues.
### [`v13.1.0`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v13.1.0): 13.1.0
[Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v13.0.4...v13.1.0)
##### New dialect
- DB2 for IBM i (thanks to Christian Jorgensen) [#658](https://togithub.com/sql-formatter-org/sql-formatter/issues/658)
##### Minor improvements
- Support parameters inside `schema.table.col` syntax to facilitate its use as a workaround for SQL templating
### [`v13.0.4`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v13.0.4): 13.0.4
[Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v13.0.3...v13.0.4)
##### Bugfix
- Support repeated-quote escaping inside Postgres C-style strings ([#655](https://togithub.com/sql-formatter-org/sql-formatter/issues/655)) (thanks to Christopher Manouvrier)
### [`v13.0.3`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v13.0.3): 13.0.3
[Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v13.0.2...v13.0.3)
##### Bugfix
- Fix crash with BETWEEN inside CASE expression [#500](https://togithub.com/sql-formatter-org/sql-formatter/issues/500) (Thanks to Zhongxian Liang)
### [`v13.0.2`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v13.0.2): 13.0.2
[Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v13.0.1...v13.0.2)
##### Bugfixes
- Fix detection of MySQL identifiers that start with number and contain unicode letters [#651](https://togithub.com/sql-formatter-org/sql-formatter/issues/651)
### [`v13.0.1`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v13.0.1): 13.0.1
[Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v13.0.0...v13.0.1)
##### Bugfixes
- Support array slice operator in Postgres ([#624](https://togithub.com/sql-formatter-org/sql-formatter/issues/624))
Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
[ ] If you want to rebase/retry this PR, check this box
This PR has been generated by Mend Renovate. View repository job log here.
This PR contains the following updates:
^13.0.0->^14.0.0Release Notes
sql-formatter-org/sql-formatter (sql-formatter)
### [`v14.0.0`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v14.0.0): 14.0.0 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v13.1.0...v14.0.0) ##### 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](https://togithub.com/sql-formatter-org/sql-formatter/issues/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](https://togithub.com/sql-formatter-org/sql-formatter/issues/618)) - Improved error messages from the parser to help users self-diagnose the most common issues. ### [`v13.1.0`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v13.1.0): 13.1.0 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v13.0.4...v13.1.0) ##### New dialect - DB2 for IBM i (thanks to Christian Jorgensen) [#658](https://togithub.com/sql-formatter-org/sql-formatter/issues/658) ##### Minor improvements - Support parameters inside `schema.table.col` syntax to facilitate its use as a workaround for SQL templating ### [`v13.0.4`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v13.0.4): 13.0.4 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v13.0.3...v13.0.4) ##### Bugfix - Support repeated-quote escaping inside Postgres C-style strings ([#655](https://togithub.com/sql-formatter-org/sql-formatter/issues/655)) (thanks to Christopher Manouvrier) ### [`v13.0.3`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v13.0.3): 13.0.3 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v13.0.2...v13.0.3) ##### Bugfix - Fix crash with BETWEEN inside CASE expression [#500](https://togithub.com/sql-formatter-org/sql-formatter/issues/500) (Thanks to Zhongxian Liang) ### [`v13.0.2`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v13.0.2): 13.0.2 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v13.0.1...v13.0.2) ##### Bugfixes - Fix detection of MySQL identifiers that start with number and contain unicode letters [#651](https://togithub.com/sql-formatter-org/sql-formatter/issues/651) ### [`v13.0.1`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v13.0.1): 13.0.1 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v13.0.0...v13.0.1) ##### Bugfixes - Support array slice operator in Postgres ([#624](https://togithub.com/sql-formatter-org/sql-formatter/issues/624))Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR has been generated by Mend Renovate. View repository job log here.