tobymao/sqlglot (sqlglot)
### [`v25.6.1`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v2561---2024-07-18)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v25.6.0...v25.6.1)
##### :bug: Bug Fixes
- [`19370d5`](https://togithub.com/tobymao/sqlglot/commit/19370d5d16b555e25def503323ec3dc4e5d40e6c) - **postgres**: Decouple UNIQUE from DEFAULT constraints *(PR [#3775](https://togithub.com/tobymao/sqlglot/pull/3775) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *fixes issue [#3774](https://togithub.com/tobymao/sqlglot/issues/3774) opened by [@EdgyEdgemond](https://togithub.com/EdgyEdgemond)*
- [`e99146b`](https://togithub.com/tobymao/sqlglot/commit/e99146b0989599772c020905f69496ea80e7e2e5) - make copy a dml statement for qualify_tables *(commit by [@tobymao](https://togithub.com/tobymao))*
### [`v25.6.0`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v2560---2024-07-17)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v25.5.1...v25.6.0)
##### :boom: BREAKING CHANGES
- due to [`89fc63c`](https://togithub.com/tobymao/sqlglot/commit/89fc63c5831dc5d63feff9e39fea1e90d65e9a09) - QUALIFY comes after WINDOW clause in queries *(PR [#3745](https://togithub.com/tobymao/sqlglot/pull/3745) by [@georgesittas](https://togithub.com/georgesittas))*:
QUALIFY comes after WINDOW clause in queries ([#3745](https://togithub.com/tobymao/sqlglot/issues/3745))
- due to [`a2a6efb`](https://togithub.com/tobymao/sqlglot/commit/a2a6efb45dc0f380747aa4afdaa19122389f3c28) - Canonicalize struct & array inline constructor *(PR [#3751](https://togithub.com/tobymao/sqlglot/pull/3751) by [@VaggelisD](https://togithub.com/VaggelisD))*:
Canonicalize struct & array inline constructor ([#3751](https://togithub.com/tobymao/sqlglot/issues/3751))
##### :sparkles: New Features
- [`e9c4bbb`](https://togithub.com/tobymao/sqlglot/commit/e9c4bbbb0d0a03d1b1efaad9abe0068b3b7efa9d) - Support for ORDER BY ALL *(PR [#3756](https://togithub.com/tobymao/sqlglot/pull/3756) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *addresses issue [#3755](https://togithub.com/tobymao/sqlglot/issues/3755) opened by [@Hunterlige](https://togithub.com/Hunterlige)*
- [`4a843e6`](https://togithub.com/tobymao/sqlglot/commit/4a843e6cca7bcc0d9956fe975dbc77e67038f1b8) - **postgres**: Support FROM ROWS FROM (...) *(PR [#3753](https://togithub.com/tobymao/sqlglot/pull/3753) by [@VaggelisD](https://togithub.com/VaggelisD))*
- [`321051a`](https://togithub.com/tobymao/sqlglot/commit/321051aef30f11f2778444040a2078633e617144) - **presto, trino**: Add support for exp.TimestampAdd *(PR [#3765](https://togithub.com/tobymao/sqlglot/pull/3765) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *addresses issue [#3762](https://togithub.com/tobymao/sqlglot/issues/3762) opened by [@ddelzell](https://togithub.com/ddelzell)*
- [`82a1bb4`](https://togithub.com/tobymao/sqlglot/commit/82a1bb42856d628651bb5f1ef9aa8f440736c450) - Support for RPAD & LPAD functions *(PR [#3757](https://togithub.com/tobymao/sqlglot/pull/3757) by [@VaggelisD](https://togithub.com/VaggelisD))*
##### :bug: Bug Fixes
- [`89fc63c`](https://togithub.com/tobymao/sqlglot/commit/89fc63c5831dc5d63feff9e39fea1e90d65e9a09) - **duckdb, clickhouse**: QUALIFY comes after WINDOW clause in queries *(PR [#3745](https://togithub.com/tobymao/sqlglot/pull/3745) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *fixes issue [#3744](https://togithub.com/tobymao/sqlglot/issues/3744) opened by [@taylorbarstow](https://togithub.com/taylorbarstow)*
- [`15ca924`](https://togithub.com/tobymao/sqlglot/commit/15ca924ac6e8a72396a882c394856e466cae9ac3) - **optimizer**: Fix expansion of SELECT \* REPLACE, RENAME *(PR [#3742](https://togithub.com/tobymao/sqlglot/pull/3742) by [@VaggelisD](https://togithub.com/VaggelisD))*
- [`0363fef`](https://togithub.com/tobymao/sqlglot/commit/0363fefd3ddd490ddddae47f7eb0192f0ff3cc5e) - attach comments to Commands *(PR [#3758](https://togithub.com/tobymao/sqlglot/pull/3758) by [@georgesittas](https://togithub.com/georgesittas))*
- [`a2a6efb`](https://togithub.com/tobymao/sqlglot/commit/a2a6efb45dc0f380747aa4afdaa19122389f3c28) - **bigquery**: Canonicalize struct & array inline constructor *(PR [#3751](https://togithub.com/tobymao/sqlglot/pull/3751) by [@VaggelisD](https://togithub.com/VaggelisD))*
- [`5df3f52`](https://togithub.com/tobymao/sqlglot/commit/5df3f5292488df6a8e21abf3b49086c823797e78) - Remove number matching from COLON placeholder parser *(PR [#3761](https://togithub.com/tobymao/sqlglot/pull/3761) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *fixes issue [#3759](https://togithub.com/tobymao/sqlglot/issues/3759) opened by [@egan8888](https://togithub.com/egan8888)*
- [`0606af6`](https://togithub.com/tobymao/sqlglot/commit/0606af66dba7c290fee65926dcb74baad82c84ac) - **duckdb**: Transpile UDFs from Databricks *(PR [#3768](https://togithub.com/tobymao/sqlglot/pull/3768) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *fixes issue [#3764](https://togithub.com/tobymao/sqlglot/issues/3764) opened by [@aersam](https://togithub.com/aersam)*
- [`dcc783a`](https://togithub.com/tobymao/sqlglot/commit/dcc783aad7c2e7184224e90fed7710eb08ddc76a) - **clickhouse**: Allow TokenType.SELECT as a Tuple field identifier *(PR [#3766](https://togithub.com/tobymao/sqlglot/pull/3766) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *fixes issue [#3763](https://togithub.com/tobymao/sqlglot/issues/3763) opened by [@cpcloud](https://togithub.com/cpcloud)*
- [`b42b7ac`](https://togithub.com/tobymao/sqlglot/commit/b42b7ac5bb1785a9028235c1557b9842ea1d7524) - extract from time/date *(commit by [@tobymao](https://togithub.com/tobymao))*
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:
>=24.0.0,<25.6
->>=24.0.0,<25.7
Release Notes
tobymao/sqlglot (sqlglot)
### [`v25.6.1`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v2561---2024-07-18) [Compare Source](https://togithub.com/tobymao/sqlglot/compare/v25.6.0...v25.6.1) ##### :bug: Bug Fixes - [`19370d5`](https://togithub.com/tobymao/sqlglot/commit/19370d5d16b555e25def503323ec3dc4e5d40e6c) - **postgres**: Decouple UNIQUE from DEFAULT constraints *(PR [#3775](https://togithub.com/tobymao/sqlglot/pull/3775) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#3774](https://togithub.com/tobymao/sqlglot/issues/3774) opened by [@EdgyEdgemond](https://togithub.com/EdgyEdgemond)* - [`e99146b`](https://togithub.com/tobymao/sqlglot/commit/e99146b0989599772c020905f69496ea80e7e2e5) - make copy a dml statement for qualify_tables *(commit by [@tobymao](https://togithub.com/tobymao))* ### [`v25.6.0`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v2560---2024-07-17) [Compare Source](https://togithub.com/tobymao/sqlglot/compare/v25.5.1...v25.6.0) ##### :boom: BREAKING CHANGES - due to [`89fc63c`](https://togithub.com/tobymao/sqlglot/commit/89fc63c5831dc5d63feff9e39fea1e90d65e9a09) - QUALIFY comes after WINDOW clause in queries *(PR [#3745](https://togithub.com/tobymao/sqlglot/pull/3745) by [@georgesittas](https://togithub.com/georgesittas))*: QUALIFY comes after WINDOW clause in queries ([#3745](https://togithub.com/tobymao/sqlglot/issues/3745)) - due to [`a2a6efb`](https://togithub.com/tobymao/sqlglot/commit/a2a6efb45dc0f380747aa4afdaa19122389f3c28) - Canonicalize struct & array inline constructor *(PR [#3751](https://togithub.com/tobymao/sqlglot/pull/3751) by [@VaggelisD](https://togithub.com/VaggelisD))*: Canonicalize struct & array inline constructor ([#3751](https://togithub.com/tobymao/sqlglot/issues/3751)) ##### :sparkles: New Features - [`e9c4bbb`](https://togithub.com/tobymao/sqlglot/commit/e9c4bbbb0d0a03d1b1efaad9abe0068b3b7efa9d) - Support for ORDER BY ALL *(PR [#3756](https://togithub.com/tobymao/sqlglot/pull/3756) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *addresses issue [#3755](https://togithub.com/tobymao/sqlglot/issues/3755) opened by [@Hunterlige](https://togithub.com/Hunterlige)* - [`4a843e6`](https://togithub.com/tobymao/sqlglot/commit/4a843e6cca7bcc0d9956fe975dbc77e67038f1b8) - **postgres**: Support FROM ROWS FROM (...) *(PR [#3753](https://togithub.com/tobymao/sqlglot/pull/3753) by [@VaggelisD](https://togithub.com/VaggelisD))* - [`321051a`](https://togithub.com/tobymao/sqlglot/commit/321051aef30f11f2778444040a2078633e617144) - **presto, trino**: Add support for exp.TimestampAdd *(PR [#3765](https://togithub.com/tobymao/sqlglot/pull/3765) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *addresses issue [#3762](https://togithub.com/tobymao/sqlglot/issues/3762) opened by [@ddelzell](https://togithub.com/ddelzell)* - [`82a1bb4`](https://togithub.com/tobymao/sqlglot/commit/82a1bb42856d628651bb5f1ef9aa8f440736c450) - Support for RPAD & LPAD functions *(PR [#3757](https://togithub.com/tobymao/sqlglot/pull/3757) by [@VaggelisD](https://togithub.com/VaggelisD))* ##### :bug: Bug Fixes - [`89fc63c`](https://togithub.com/tobymao/sqlglot/commit/89fc63c5831dc5d63feff9e39fea1e90d65e9a09) - **duckdb, clickhouse**: QUALIFY comes after WINDOW clause in queries *(PR [#3745](https://togithub.com/tobymao/sqlglot/pull/3745) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3744](https://togithub.com/tobymao/sqlglot/issues/3744) opened by [@taylorbarstow](https://togithub.com/taylorbarstow)* - [`15ca924`](https://togithub.com/tobymao/sqlglot/commit/15ca924ac6e8a72396a882c394856e466cae9ac3) - **optimizer**: Fix expansion of SELECT \* REPLACE, RENAME *(PR [#3742](https://togithub.com/tobymao/sqlglot/pull/3742) by [@VaggelisD](https://togithub.com/VaggelisD))* - [`0363fef`](https://togithub.com/tobymao/sqlglot/commit/0363fefd3ddd490ddddae47f7eb0192f0ff3cc5e) - attach comments to Commands *(PR [#3758](https://togithub.com/tobymao/sqlglot/pull/3758) by [@georgesittas](https://togithub.com/georgesittas))* - [`a2a6efb`](https://togithub.com/tobymao/sqlglot/commit/a2a6efb45dc0f380747aa4afdaa19122389f3c28) - **bigquery**: Canonicalize struct & array inline constructor *(PR [#3751](https://togithub.com/tobymao/sqlglot/pull/3751) by [@VaggelisD](https://togithub.com/VaggelisD))* - [`5df3f52`](https://togithub.com/tobymao/sqlglot/commit/5df3f5292488df6a8e21abf3b49086c823797e78) - Remove number matching from COLON placeholder parser *(PR [#3761](https://togithub.com/tobymao/sqlglot/pull/3761) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#3759](https://togithub.com/tobymao/sqlglot/issues/3759) opened by [@egan8888](https://togithub.com/egan8888)* - [`0606af6`](https://togithub.com/tobymao/sqlglot/commit/0606af66dba7c290fee65926dcb74baad82c84ac) - **duckdb**: Transpile UDFs from Databricks *(PR [#3768](https://togithub.com/tobymao/sqlglot/pull/3768) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#3764](https://togithub.com/tobymao/sqlglot/issues/3764) opened by [@aersam](https://togithub.com/aersam)* - [`dcc783a`](https://togithub.com/tobymao/sqlglot/commit/dcc783aad7c2e7184224e90fed7710eb08ddc76a) - **clickhouse**: Allow TokenType.SELECT as a Tuple field identifier *(PR [#3766](https://togithub.com/tobymao/sqlglot/pull/3766) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#3763](https://togithub.com/tobymao/sqlglot/issues/3763) opened by [@cpcloud](https://togithub.com/cpcloud)* - [`b42b7ac`](https://togithub.com/tobymao/sqlglot/commit/b42b7ac5bb1785a9028235c1557b9842ea1d7524) - extract from time/date *(commit by [@tobymao](https://togithub.com/tobymao))*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.