tobymao/sqlglot (sqlglot)
### [`v25.3.0`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v2530---2024-06-21)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v25.2.0...v25.3.0)
##### :boom: BREAKING CHANGES
- due to [`84d820f`](https://togithub.com/tobymao/sqlglot/commit/84d820f96b161fdd5b00f265890b5c75c65a36f0) - Time/Datetime/Timestamp function additions *(PR [#3666](https://togithub.com/tobymao/sqlglot/pull/3666) by [@VaggelisD](https://togithub.com/VaggelisD))*:
Time/Datetime/Timestamp function additions ([#3666](https://togithub.com/tobymao/sqlglot/issues/3666))
- due to [`acbc81d`](https://togithub.com/tobymao/sqlglot/commit/acbc81d47a2e721c4334ac86b5e17177429cd1c6) - Preserve JSON/VARIANT path with operators *(PR [#3678](https://togithub.com/tobymao/sqlglot/pull/3678) by [@VaggelisD](https://togithub.com/VaggelisD))*:
Preserve JSON/VARIANT path with operators ([#3678](https://togithub.com/tobymao/sqlglot/issues/3678))
##### :sparkles: New Features
- [`84d820f`](https://togithub.com/tobymao/sqlglot/commit/84d820f96b161fdd5b00f265890b5c75c65a36f0) - **bigquery**: Time/Datetime/Timestamp function additions *(PR [#3666](https://togithub.com/tobymao/sqlglot/pull/3666) by [@VaggelisD](https://togithub.com/VaggelisD))*
- [`d46ad95`](https://togithub.com/tobymao/sqlglot/commit/d46ad95bb623f1931d9e373d8444d9ed947362c5) - **tokenizer**: add support for nested comments *(PR [#3670](https://togithub.com/tobymao/sqlglot/pull/3670) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *addresses issue [#3668](https://togithub.com/tobymao/sqlglot/issues/3668) opened by [@aersam](https://togithub.com/aersam)*
- [`ac0e89c`](https://togithub.com/tobymao/sqlglot/commit/ac0e89c4401f2f278d32c3e956670b262ab21ce7) - **snowflake**: add SECURE post table property fixes [#3677](https://togithub.com/tobymao/sqlglot/pull/3677) *(commit by [@georgesittas](https://togithub.com/georgesittas))*
- [`acbc81d`](https://togithub.com/tobymao/sqlglot/commit/acbc81d47a2e721c4334ac86b5e17177429cd1c6) - **databricks**: Preserve JSON/VARIANT path with operators *(PR [#3678](https://togithub.com/tobymao/sqlglot/pull/3678) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *addresses issue [#3673](https://togithub.com/tobymao/sqlglot/issues/3673) opened by [@aersam](https://togithub.com/aersam)*
- [`07158c7`](https://togithub.com/tobymao/sqlglot/commit/07158c77ae7879aa83b7982cefb4ec9d01c11857) - **clickhouse**: Fix roundtrips of DATE/TIMESTAMP functions *(PR [#3683](https://togithub.com/tobymao/sqlglot/pull/3683) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *addresses issue [#3679](https://togithub.com/tobymao/sqlglot/issues/3679) opened by [@TacoBel42](https://togithub.com/TacoBel42)*
##### :bug: Bug Fixes
- [`79aea2a`](https://togithub.com/tobymao/sqlglot/commit/79aea2affece72acfac52b3ac85cf740d55ccff0) - **doris**: ensure LAG/LEAD are generated with three arguments *(commit by [@georgesittas](https://togithub.com/georgesittas))*
- [`08fb2ec`](https://togithub.com/tobymao/sqlglot/commit/08fb2ecf808f25eae74b579f8e5c4369edc7c604) - **parser**: check if FROM exists when making implicit unnest explicit fixes [#3671](https://togithub.com/tobymao/sqlglot/pull/3671) *(commit by [@georgesittas](https://togithub.com/georgesittas))*
- [`049fc5a`](https://togithub.com/tobymao/sqlglot/commit/049fc5a430ad6fa2998fd94d6e20b23da3b545c3) - **bigquery**: handle the case-sensitive strategy in normalize_identifier *(PR [#3667](https://togithub.com/tobymao/sqlglot/pull/3667) by [@georgesittas](https://togithub.com/georgesittas))*
- [`9e1b6aa`](https://togithub.com/tobymao/sqlglot/commit/9e1b6aa5d9e2abb141143327c835c8f3b4bbcb0f) - **parser**: handle another edge case in struct field type parser *(PR [#3682](https://togithub.com/tobymao/sqlglot/pull/3682) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *fixes issue [#3680](https://togithub.com/tobymao/sqlglot/issues/3680) opened by [@plaflamme](https://togithub.com/plaflamme)*
- [`a1a0278`](https://togithub.com/tobymao/sqlglot/commit/a1a02782f22b471ee3c896d57f15237dc86565d1) - jsonbcontains default gen *(commit by [@tobymao](https://togithub.com/tobymao))*
- [`bf44942`](https://togithub.com/tobymao/sqlglot/commit/bf44942a7d35eb83685ad3aa2b360c7105a9f5b7) - **oracle**: Fix default NULL_ORDERING *(PR [#3688](https://togithub.com/tobymao/sqlglot/pull/3688) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *fixes issue [#3684](https://togithub.com/tobymao/sqlglot/issues/3684) opened by [@ncclementi](https://togithub.com/ncclementi)*
##### :wrench: Chores
- [`7ae99fe`](https://togithub.com/tobymao/sqlglot/commit/7ae99fe8284cf2e60819b3992bc79a020dfd00c5) - bump sqlglotrs to 0.2.7 *(commit by [@georgesittas](https://togithub.com/georgesittas))*
### [`v25.2.0`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v2520---2024-06-17)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v25.1.0...v25.2.0)
##### :boom: BREAKING CHANGES
- due to [`d331e56`](https://togithub.com/tobymao/sqlglot/commit/d331e56aad7784a122dc36d7bffe5cf0565e38d1) - Normalize time units in their full singular form *(PR [#3652](https://togithub.com/tobymao/sqlglot/pull/3652) by [@VaggelisD](https://togithub.com/VaggelisD))*:
Normalize time units in their full singular form ([#3652](https://togithub.com/tobymao/sqlglot/issues/3652))
- due to [`468123e`](https://togithub.com/tobymao/sqlglot/commit/468123e4b7612287e128529de62f3a88f4e1d579) - create SetOperation class *(PR [#3661](https://togithub.com/tobymao/sqlglot/pull/3661) by [@georgesittas](https://togithub.com/georgesittas))*:
create SetOperation class ([#3661](https://togithub.com/tobymao/sqlglot/issues/3661))
##### :sparkles: New Features
- [`e7a158b`](https://togithub.com/tobymao/sqlglot/commit/e7a158b6f0990db00a4890dfb456de6112f50fd2) - set misc. dialect settings if available *(PR [#3649](https://togithub.com/tobymao/sqlglot/pull/3649) by [@georgesittas](https://togithub.com/georgesittas))*
- [`ff3dabc`](https://togithub.com/tobymao/sqlglot/commit/ff3dabc75f9a03627caa988b85f88be04a6c70a4) - **tsql**: index on closes [#3658](https://togithub.com/tobymao/sqlglot/pull/3658) *(commit by [@tobymao](https://togithub.com/tobymao))*
- [`fb4d908`](https://togithub.com/tobymao/sqlglot/commit/fb4d9080a042d40455bcf631ca6a0afaacb19683) - **tsql**: clustered index closes [#3659](https://togithub.com/tobymao/sqlglot/pull/3659) *(commit by [@tobymao](https://togithub.com/tobymao))*
##### :bug: Bug Fixes
- [`88c4965`](https://togithub.com/tobymao/sqlglot/commit/88c49651ecc9d55967f5c8056352de0f0981989f) - **mysql**: delete redundant keywords *(PR [#3646](https://togithub.com/tobymao/sqlglot/pull/3646) by [@Toms1999](https://togithub.com/Toms1999))*
- [`4c82c0d`](https://togithub.com/tobymao/sqlglot/commit/4c82c0d01086e0a622a1448d25f51b0e760d053f) - Parse UNNEST as a function in base dialect *(PR [#3650](https://togithub.com/tobymao/sqlglot/pull/3650) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *fixes issue [#3647](https://togithub.com/tobymao/sqlglot/issues/3647) opened by [@ronnix](https://togithub.com/ronnix)*
- [`d331e56`](https://togithub.com/tobymao/sqlglot/commit/d331e56aad7784a122dc36d7bffe5cf0565e38d1) - **redshift**: Normalize time units in their full singular form *(PR [#3652](https://togithub.com/tobymao/sqlglot/pull/3652) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *fixes issue [#3651](https://togithub.com/tobymao/sqlglot/issues/3651) opened by [@vidit-wisdom](https://togithub.com/vidit-wisdom)*
- [`a06ee36`](https://togithub.com/tobymao/sqlglot/commit/a06ee3695d4d23626c1ef0700b373fc84600d374) - **parser**: edge case in \_parse_types *(PR [#3656](https://togithub.com/tobymao/sqlglot/pull/3656) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *fixes issue [#3655](https://togithub.com/tobymao/sqlglot/issues/3655) opened by [@dangoldin](https://togithub.com/dangoldin)*
- [`a739741`](https://togithub.com/tobymao/sqlglot/commit/a739741dca5eefd7d4a2c450dd4506cb951d7efb) - teradata warning *(commit by [@tobymao](https://togithub.com/tobymao))*
- [`868f30d`](https://togithub.com/tobymao/sqlglot/commit/868f30d1ff46ec9b8a048bb79fbb511f458fd769) - improve schema error handling *(PR [#3663](https://togithub.com/tobymao/sqlglot/pull/3663) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *fixes issue [#3662](https://togithub.com/tobymao/sqlglot/issues/3662) opened by [@dexhorthy](https://togithub.com/dexhorthy)*
##### :recycle: Refactors
- [`e8cab58`](https://togithub.com/tobymao/sqlglot/commit/e8cab58c4c44e84ee21d11e8554ee7aed5dc5901) - clean up join mark elimination rule *(PR [#3653](https://togithub.com/tobymao/sqlglot/pull/3653) by [@georgesittas](https://togithub.com/georgesittas))*
- [`468123e`](https://togithub.com/tobymao/sqlglot/commit/468123e4b7612287e128529de62f3a88f4e1d579) - create SetOperation class *(PR [#3661](https://togithub.com/tobymao/sqlglot/pull/3661) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *addresses issue [#3660](https://togithub.com/tobymao/sqlglot/issues/3660) opened by [@sorgfresser](https://togithub.com/sorgfresser)*
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.2
->>=24.0.0,<25.4
Release Notes
tobymao/sqlglot (sqlglot)
### [`v25.3.0`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v2530---2024-06-21) [Compare Source](https://togithub.com/tobymao/sqlglot/compare/v25.2.0...v25.3.0) ##### :boom: BREAKING CHANGES - due to [`84d820f`](https://togithub.com/tobymao/sqlglot/commit/84d820f96b161fdd5b00f265890b5c75c65a36f0) - Time/Datetime/Timestamp function additions *(PR [#3666](https://togithub.com/tobymao/sqlglot/pull/3666) by [@VaggelisD](https://togithub.com/VaggelisD))*: Time/Datetime/Timestamp function additions ([#3666](https://togithub.com/tobymao/sqlglot/issues/3666)) - due to [`acbc81d`](https://togithub.com/tobymao/sqlglot/commit/acbc81d47a2e721c4334ac86b5e17177429cd1c6) - Preserve JSON/VARIANT path with operators *(PR [#3678](https://togithub.com/tobymao/sqlglot/pull/3678) by [@VaggelisD](https://togithub.com/VaggelisD))*: Preserve JSON/VARIANT path with operators ([#3678](https://togithub.com/tobymao/sqlglot/issues/3678)) ##### :sparkles: New Features - [`84d820f`](https://togithub.com/tobymao/sqlglot/commit/84d820f96b161fdd5b00f265890b5c75c65a36f0) - **bigquery**: Time/Datetime/Timestamp function additions *(PR [#3666](https://togithub.com/tobymao/sqlglot/pull/3666) by [@VaggelisD](https://togithub.com/VaggelisD))* - [`d46ad95`](https://togithub.com/tobymao/sqlglot/commit/d46ad95bb623f1931d9e373d8444d9ed947362c5) - **tokenizer**: add support for nested comments *(PR [#3670](https://togithub.com/tobymao/sqlglot/pull/3670) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *addresses issue [#3668](https://togithub.com/tobymao/sqlglot/issues/3668) opened by [@aersam](https://togithub.com/aersam)* - [`ac0e89c`](https://togithub.com/tobymao/sqlglot/commit/ac0e89c4401f2f278d32c3e956670b262ab21ce7) - **snowflake**: add SECURE post table property fixes [#3677](https://togithub.com/tobymao/sqlglot/pull/3677) *(commit by [@georgesittas](https://togithub.com/georgesittas))* - [`acbc81d`](https://togithub.com/tobymao/sqlglot/commit/acbc81d47a2e721c4334ac86b5e17177429cd1c6) - **databricks**: Preserve JSON/VARIANT path with operators *(PR [#3678](https://togithub.com/tobymao/sqlglot/pull/3678) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *addresses issue [#3673](https://togithub.com/tobymao/sqlglot/issues/3673) opened by [@aersam](https://togithub.com/aersam)* - [`07158c7`](https://togithub.com/tobymao/sqlglot/commit/07158c77ae7879aa83b7982cefb4ec9d01c11857) - **clickhouse**: Fix roundtrips of DATE/TIMESTAMP functions *(PR [#3683](https://togithub.com/tobymao/sqlglot/pull/3683) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *addresses issue [#3679](https://togithub.com/tobymao/sqlglot/issues/3679) opened by [@TacoBel42](https://togithub.com/TacoBel42)* ##### :bug: Bug Fixes - [`79aea2a`](https://togithub.com/tobymao/sqlglot/commit/79aea2affece72acfac52b3ac85cf740d55ccff0) - **doris**: ensure LAG/LEAD are generated with three arguments *(commit by [@georgesittas](https://togithub.com/georgesittas))* - [`08fb2ec`](https://togithub.com/tobymao/sqlglot/commit/08fb2ecf808f25eae74b579f8e5c4369edc7c604) - **parser**: check if FROM exists when making implicit unnest explicit fixes [#3671](https://togithub.com/tobymao/sqlglot/pull/3671) *(commit by [@georgesittas](https://togithub.com/georgesittas))* - [`049fc5a`](https://togithub.com/tobymao/sqlglot/commit/049fc5a430ad6fa2998fd94d6e20b23da3b545c3) - **bigquery**: handle the case-sensitive strategy in normalize_identifier *(PR [#3667](https://togithub.com/tobymao/sqlglot/pull/3667) by [@georgesittas](https://togithub.com/georgesittas))* - [`9e1b6aa`](https://togithub.com/tobymao/sqlglot/commit/9e1b6aa5d9e2abb141143327c835c8f3b4bbcb0f) - **parser**: handle another edge case in struct field type parser *(PR [#3682](https://togithub.com/tobymao/sqlglot/pull/3682) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3680](https://togithub.com/tobymao/sqlglot/issues/3680) opened by [@plaflamme](https://togithub.com/plaflamme)* - [`a1a0278`](https://togithub.com/tobymao/sqlglot/commit/a1a02782f22b471ee3c896d57f15237dc86565d1) - jsonbcontains default gen *(commit by [@tobymao](https://togithub.com/tobymao))* - [`bf44942`](https://togithub.com/tobymao/sqlglot/commit/bf44942a7d35eb83685ad3aa2b360c7105a9f5b7) - **oracle**: Fix default NULL_ORDERING *(PR [#3688](https://togithub.com/tobymao/sqlglot/pull/3688) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#3684](https://togithub.com/tobymao/sqlglot/issues/3684) opened by [@ncclementi](https://togithub.com/ncclementi)* ##### :wrench: Chores - [`7ae99fe`](https://togithub.com/tobymao/sqlglot/commit/7ae99fe8284cf2e60819b3992bc79a020dfd00c5) - bump sqlglotrs to 0.2.7 *(commit by [@georgesittas](https://togithub.com/georgesittas))* ### [`v25.2.0`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v2520---2024-06-17) [Compare Source](https://togithub.com/tobymao/sqlglot/compare/v25.1.0...v25.2.0) ##### :boom: BREAKING CHANGES - due to [`d331e56`](https://togithub.com/tobymao/sqlglot/commit/d331e56aad7784a122dc36d7bffe5cf0565e38d1) - Normalize time units in their full singular form *(PR [#3652](https://togithub.com/tobymao/sqlglot/pull/3652) by [@VaggelisD](https://togithub.com/VaggelisD))*: Normalize time units in their full singular form ([#3652](https://togithub.com/tobymao/sqlglot/issues/3652)) - due to [`468123e`](https://togithub.com/tobymao/sqlglot/commit/468123e4b7612287e128529de62f3a88f4e1d579) - create SetOperation class *(PR [#3661](https://togithub.com/tobymao/sqlglot/pull/3661) by [@georgesittas](https://togithub.com/georgesittas))*: create SetOperation class ([#3661](https://togithub.com/tobymao/sqlglot/issues/3661)) ##### :sparkles: New Features - [`e7a158b`](https://togithub.com/tobymao/sqlglot/commit/e7a158b6f0990db00a4890dfb456de6112f50fd2) - set misc. dialect settings if available *(PR [#3649](https://togithub.com/tobymao/sqlglot/pull/3649) by [@georgesittas](https://togithub.com/georgesittas))* - [`ff3dabc`](https://togithub.com/tobymao/sqlglot/commit/ff3dabc75f9a03627caa988b85f88be04a6c70a4) - **tsql**: index on closes [#3658](https://togithub.com/tobymao/sqlglot/pull/3658) *(commit by [@tobymao](https://togithub.com/tobymao))* - [`fb4d908`](https://togithub.com/tobymao/sqlglot/commit/fb4d9080a042d40455bcf631ca6a0afaacb19683) - **tsql**: clustered index closes [#3659](https://togithub.com/tobymao/sqlglot/pull/3659) *(commit by [@tobymao](https://togithub.com/tobymao))* ##### :bug: Bug Fixes - [`88c4965`](https://togithub.com/tobymao/sqlglot/commit/88c49651ecc9d55967f5c8056352de0f0981989f) - **mysql**: delete redundant keywords *(PR [#3646](https://togithub.com/tobymao/sqlglot/pull/3646) by [@Toms1999](https://togithub.com/Toms1999))* - [`4c82c0d`](https://togithub.com/tobymao/sqlglot/commit/4c82c0d01086e0a622a1448d25f51b0e760d053f) - Parse UNNEST as a function in base dialect *(PR [#3650](https://togithub.com/tobymao/sqlglot/pull/3650) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#3647](https://togithub.com/tobymao/sqlglot/issues/3647) opened by [@ronnix](https://togithub.com/ronnix)* - [`d331e56`](https://togithub.com/tobymao/sqlglot/commit/d331e56aad7784a122dc36d7bffe5cf0565e38d1) - **redshift**: Normalize time units in their full singular form *(PR [#3652](https://togithub.com/tobymao/sqlglot/pull/3652) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#3651](https://togithub.com/tobymao/sqlglot/issues/3651) opened by [@vidit-wisdom](https://togithub.com/vidit-wisdom)* - [`a06ee36`](https://togithub.com/tobymao/sqlglot/commit/a06ee3695d4d23626c1ef0700b373fc84600d374) - **parser**: edge case in \_parse_types *(PR [#3656](https://togithub.com/tobymao/sqlglot/pull/3656) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3655](https://togithub.com/tobymao/sqlglot/issues/3655) opened by [@dangoldin](https://togithub.com/dangoldin)* - [`a739741`](https://togithub.com/tobymao/sqlglot/commit/a739741dca5eefd7d4a2c450dd4506cb951d7efb) - teradata warning *(commit by [@tobymao](https://togithub.com/tobymao))* - [`868f30d`](https://togithub.com/tobymao/sqlglot/commit/868f30d1ff46ec9b8a048bb79fbb511f458fd769) - improve schema error handling *(PR [#3663](https://togithub.com/tobymao/sqlglot/pull/3663) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3662](https://togithub.com/tobymao/sqlglot/issues/3662) opened by [@dexhorthy](https://togithub.com/dexhorthy)* ##### :recycle: Refactors - [`e8cab58`](https://togithub.com/tobymao/sqlglot/commit/e8cab58c4c44e84ee21d11e8554ee7aed5dc5901) - clean up join mark elimination rule *(PR [#3653](https://togithub.com/tobymao/sqlglot/pull/3653) by [@georgesittas](https://togithub.com/georgesittas))* - [`468123e`](https://togithub.com/tobymao/sqlglot/commit/468123e4b7612287e128529de62f3a88f4e1d579) - create SetOperation class *(PR [#3661](https://togithub.com/tobymao/sqlglot/pull/3661) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *addresses issue [#3660](https://togithub.com/tobymao/sqlglot/issues/3660) opened by [@sorgfresser](https://togithub.com/sorgfresser)*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.