search

dgadelha / knex-playground

Knex Playground
https://dgadelha.github.io/knex-playground/
41 stars 5 forks source link

fix(deps): update dependency sql-formatter to v13 - autoclosed #275

Closed renovate[bot] closed 11 months ago

renovate[bot] commented 1 year ago

Mend Renovate

This PR contains the following updates:

Package Change Age Adoption Passing Confidence
sql-formatter ^10.7.1 -> ^13.0.0 age adoption passing confidence

Release Notes

sql-formatter-org/sql-formatter (sql-formatter) ### [`v13.0.0`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v13.0.0): 13.0.0 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.2.4...v13.0.0) ##### Breaking changes - Reduced the keywords lists of MySQL, MariaDB and SingleStoreDB to just the reserved ones. [#​629](https://togithub.com/sql-formatter-org/sql-formatter/issues/629) This means that using `keywordCase: upper` no more capitalizes words like `user` and `name`. - Changed how `COMMENT` keyword is formatted. [#​636](https://togithub.com/sql-formatter-org/sql-formatter/issues/636) In dialects like MariaDB (which allow it inside `CREATE TABLE` statement) it is no more placed on a separate line. In dialects which support `COMMENT ON ...` statement, it only triggers a new line when used together with `ON`. ##### Bugfixes - Fixed crash when encountering goto labels in Transact-SQL [#​632](https://togithub.com/sql-formatter-org/sql-formatter/issues/632) - Fix formatting of `ON DUPLICATE KEY UPDATE` clause in MariaDB-like dialects. [#​605](https://togithub.com/sql-formatter-org/sql-formatter/issues/605) - Fix formatting of `VALUES()` function in MariaDB-like dialects. [#​605](https://togithub.com/sql-formatter-org/sql-formatter/issues/605) ### [`v12.2.4`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.2.4): 12.2.4 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.2.3...v12.2.4) #### Bugfix - Fix EAGAIN error when reading stdin (Thanks to [@​seblj](https://togithub.com/seblj) [#​621](https://togithub.com/sql-formatter-org/sql-formatter/issues/621)) ### [`v12.2.3`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.2.3): 12.2.3 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.2.2...v12.2.3) ##### Bugfixes - Add SELECT..INTO support for TSQL ([#​609](https://togithub.com/sql-formatter-org/sql-formatter/issues/609)) (thanks to Grant Forsythe) ### [`v12.2.2`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.2.2): 12.2.2 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.2.1...v12.2.2) ##### Bugfixes - Improve handling of GO statements in Transact-SQL ([#​606](https://togithub.com/sql-formatter-org/sql-formatter/issues/606)) (thanks to Grant Forsythe) ### [`v12.2.1`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.2.1): 12.2.1 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.2.0...v12.2.1) ##### Bugfixes - Support named arguments for BigQuery ([#​603](https://togithub.com/sql-formatter-org/sql-formatter/issues/603)) (thanks to pokutuna) ### [`v12.2.0`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.2.0): 12.2.0 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.1.4...v12.2.0) #### New feature - Custom paramTypes config ([#​582](https://togithub.com/sql-formatter-org/sql-formatter/issues/582)) ### [`v12.1.4`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.1.4): 12.1.4 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.1.3...v12.1.4) - Export `ParamItems` and `ParamTypes` at top level [#​577](https://togithub.com/sql-formatter-org/sql-formatter/issues/577) ### [`v12.1.3`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.1.3): 12.1.3 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.1.2...v12.1.3) ##### Bugfixes - Add FOR UPDATE clause support for Postgres ([#​574](https://togithub.com/sql-formatter-org/sql-formatter/issues/574)) (thanks to Nathan Walters) ### [`v12.1.2`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.1.2): 12.1.2 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.1.1...v12.1.2) ##### Enhancements - Support BigQuery system variables ([#​568](https://togithub.com/sql-formatter-org/sql-formatter/issues/568)) ### [`v12.1.1`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.1.1): 12.1.1 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.1.0...v12.1.1) ##### Bugfixes - Fix long-standing bug: `BETWEEN` operator followed by `AND` operator no more causes a crash ([#​566](https://togithub.com/sql-formatter-org/sql-formatter/issues/566)) - Fix formatting of `IS [NOT] DISTINCT FROM` operator ([#​565](https://togithub.com/sql-formatter-org/sql-formatter/issues/565)) - Improve formatting of block comments that aren't doc-comments ([#​559](https://togithub.com/sql-formatter-org/sql-formatter/issues/559)) ### [`v12.1.0`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.1.0): 12.1.0 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.0.6...v12.1.0) #### New feature - New command line flag `--fix` for formatting files in-place ([#​406](https://togithub.com/sql-formatter-org/sql-formatter/issues/406)) ### [`v12.0.6`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.0.6): 12.0.6 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.0.5...v12.0.6) ##### Bugfix - Allow DB2 identifiers to start with `$`, `@`, `#` chars [#​550](https://togithub.com/sql-formatter-org/sql-formatter/issues/550) ### [`v12.0.5`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.0.5): 12.0.5 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.0.4...v12.0.5) ##### Bugfixes - Fixed trailing comment handling with `commaPosition` option (thanks to Stanislav Germanovskii) [#​505](https://togithub.com/sql-formatter-org/sql-formatter/issues/505) ##### Dependency updates - Bumped json5 from 1.0.1 to 1.0.2 ([#​548](https://togithub.com/sql-formatter-org/sql-formatter/issues/548)) ### [`v12.0.4`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.0.4): 12.0.4 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.0.3...v12.0.4) ##### Bugfixes - Fix formatting of ON CONFLICT clause ([#​535](https://togithub.com/sql-formatter-org/sql-formatter/issues/535)) - Support QUALIFY clause in Snowflake ([#​539](https://togithub.com/sql-formatter-org/sql-formatter/issues/539)) ### [`v12.0.3`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.0.3): 12.0.3 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.0.2...v12.0.3) ##### Bugfixes - Add missing operators to SingleStoreDB ([#​531](https://togithub.com/sql-formatter-org/sql-formatter/issues/531)) (thanks to Tito Griné) ### [`v12.0.2`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.0.2): 12.0.2 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.0.1...v12.0.2) ##### Bugfixes - Fix crash with complex expressions inside BETWEEN [#​523](https://togithub.com/sql-formatter-org/sql-formatter/issues/523) [#​507](https://togithub.com/sql-formatter-org/sql-formatter/issues/507) ### [`v12.0.1`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.0.1): 12.0.1 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v12.0.0...v12.0.1) ##### Bugfixes - Export ConfigError class as value, not as type ([#​521](https://togithub.com/sql-formatter-org/sql-formatter/issues/521)) ### [`v12.0.0`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v12.0.0): 12.0.0 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v11.0.2...v12.0.0) ##### Major formatting style change Most of the simple statements are now formatted more on one line ([#​483](https://togithub.com/sql-formatter-org/sql-formatter/issues/483)). For example the following SQL, previously formatted as follows: ```sql ALTER TABLE foo ALTER COLUMN col1 SET DEFAULT 10; DROP TABLE my_tbl; DELETE FROM customers WHERE age > 99; UPDATE orders SET price = 0, total = 0 WHERE deleted = TRUE; ``` will now be formatted on a single line: ```sql ALTER TABLE foo ALTER COLUMN col1 SET DEFAULT 10; DROP TABLE my_tbl; DELETE FROM customers WHERE age > 99; UPDATE orders SET price = 0, total = 0 WHERE deleted = TRUE; ``` ##### New API for smaller bundle size When using the `format()` function, all the dialects need to be loaded because the actual dialect is determined at runtime. Which means a bundler like Webpack will need to bundle up code of all the dialects even when just a single one is needed. This will be something like 4x overhead compared to bundling just a single dialect. There's now a new API which enables tree-shaking to eliminate the code of unused dialects: ```ts import { formatDialect, sqlite } from "sql-formatter"; formatDialect("SELECT * FROM tbl", { dialect: sqlite }); ``` See the [docs](https://togithub.com/sql-formatter-org/sql-formatter/blob/master/docs/dialect.md) for details. Related issues/PRs: [#​511](https://togithub.com/sql-formatter-org/sql-formatter/issues/511) [#​515](https://togithub.com/sql-formatter-org/sql-formatter/issues/515) [#​452](https://togithub.com/sql-formatter-org/sql-formatter/issues/452) ##### Breaking changes in extension API The above change also breaks the current extension API. Notably the `language` parameter no more works for specifying a custom dialect. Instead use the new `formatDialect()` API for the same purpose. Also, instead of extending the `Formatter` class, there's now a `DialectOptions` object ([#​493](https://togithub.com/sql-formatter-org/sql-formatter/issues/493)). So one no more needs to extend a class, but can simply provide a config object. ##### Other new features - Support for custom quote types (in custom dialect config) [#​516](https://togithub.com/sql-formatter-org/sql-formatter/issues/516) [#​503](https://togithub.com/sql-formatter-org/sql-formatter/issues/503) ##### Bugfixes - Support named function arguments in Trino with `=>` operator [#​510](https://togithub.com/sql-formatter-org/sql-formatter/issues/510) - Add package.json to list of exports [#​499](https://togithub.com/sql-formatter-org/sql-formatter/issues/499) - Support nested CASE expressions [#​494](https://togithub.com/sql-formatter-org/sql-formatter/issues/494) - The MySQL USE keyword formatting should no more cause syntax error [#​456](https://togithub.com/sql-formatter-org/sql-formatter/issues/456) ### [`v11.0.2`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v11.0.2): 11.0.2 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v11.0.1...v11.0.2) ##### Bugfixes - Fix indentation of first comment in file [#​481](https://togithub.com/sql-formatter-org/sql-formatter/issues/481) ### [`v11.0.1`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v11.0.1): 11.0.1 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v11.0.0...v11.0.1) ##### Bugfixes - Fix ESM/TypeScript module resolution [#​487](https://togithub.com/sql-formatter-org/sql-formatter/issues/487) [#​488](https://togithub.com/sql-formatter-org/sql-formatter/issues/488) (thanks to An Phi) ### [`v11.0.0`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v11.0.0): 11.0.0 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v10.7.2...v11.0.0) ##### Potentially breaking changes - The library is now exported as ES module [#​455](https://togithub.com/sql-formatter-org/sql-formatter/issues/455), [#​105](https://togithub.com/sql-formatter-org/sql-formatter/issues/105) ##### New features - Added support for Snowflake dialect [#​454](https://togithub.com/sql-formatter-org/sql-formatter/issues/454) ##### Improvements - Better CASE expression formatting [#​458](https://togithub.com/sql-formatter-org/sql-formatter/issues/458), [#​401](https://togithub.com/sql-formatter-org/sql-formatter/issues/401), [#​459](https://togithub.com/sql-formatter-org/sql-formatter/issues/459) - Better formatting of inline block-comments [#​462](https://togithub.com/sql-formatter-org/sql-formatter/issues/462) - Better ON UPDATE/DELETE constraints formatting [#​478](https://togithub.com/sql-formatter-org/sql-formatter/issues/478) - `denseOperators` config now also applies to `:` operator. ### [`v10.7.2`](https://togithub.com/sql-formatter-org/sql-formatter/releases/tag/v10.7.2): 10.7.2 [Compare Source](https://togithub.com/sql-formatter-org/sql-formatter/compare/v10.7.1...v10.7.2) ##### Bugfixes - Support empty `SELECT;` statement [#​447](https://togithub.com/sql-formatter-org/sql-formatter/issues/447)

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.