chore(deps): update dependency sqlglot to >=24.0.0,<25.2

This PR contains the following updates:

Package	Change	Age	Adoption	Passing	Confidence
sqlglot	`>=24.0.0,<25.1` -> `>=24.0.0,<25.2`

Release Notes

tobymao/sqlglot (sqlglot)

### [`v25.1.0`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v2510---2024-06-12) [Compare Source](https://togithub.com/tobymao/sqlglot/compare/v25.0.3...v25.1.0) ##### :boom: BREAKING CHANGES - due to [`d6cfb41`](https://togithub.com/tobymao/sqlglot/commit/d6cfb41d63893eadf23a81adf413952f3bd4f0ad) - Support for DATE_ADD functions *(PR [#3609](https://togithub.com/tobymao/sqlglot/pull/3609) by [@VaggelisD](https://togithub.com/VaggelisD))*: Support for DATE_ADD functions ([#3609](https://togithub.com/tobymao/sqlglot/issues/3609)) ##### :sparkles: New Features - [`d6cfb41`](https://togithub.com/tobymao/sqlglot/commit/d6cfb41d63893eadf23a81adf413952f3bd4f0ad) - **spark, databricks**: Support for DATE_ADD functions *(PR [#3609](https://togithub.com/tobymao/sqlglot/pull/3609) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *addresses issue [#3607](https://togithub.com/tobymao/sqlglot/issues/3607) opened by [@justinbt21](https://togithub.com/justinbt21)* - [`4b30b87`](https://togithub.com/tobymao/sqlglot/commit/4b30b872b6db73da51e81ef72e1f3bf8763b652b) - **postgres**: Support DIV() func for integer division *(PR [#3602](https://togithub.com/tobymao/sqlglot/pull/3602) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *addresses issue [#3601](https://togithub.com/tobymao/sqlglot/issues/3601) opened by [@andrrreasss](https://togithub.com/andrrreasss)* - [`ee9b01d`](https://togithub.com/tobymao/sqlglot/commit/ee9b01d5631f8f0942b61dfaf0632ae0ac2543bb) - **mysql**: support ADD INDEX/KEY/UNIQUE in ALTER TABLE *(PR [#3621](https://togithub.com/tobymao/sqlglot/pull/3621) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *addresses issue [#3615](https://togithub.com/tobymao/sqlglot/issues/3615) opened by [@hubg398](https://togithub.com/hubg398)* - [`c49cefa`](https://togithub.com/tobymao/sqlglot/commit/c49cefafaf5e9e51778ab85499fde29600d66ed7) - **mysql**: support STRAIGHT_JOIN *(PR [#3623](https://togithub.com/tobymao/sqlglot/pull/3623) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *addresses issue [#3622](https://togithub.com/tobymao/sqlglot/issues/3622) opened by [@gabocic](https://togithub.com/gabocic)* - [`e998308`](https://togithub.com/tobymao/sqlglot/commit/e998308be079bca343af053b99e3826606811df5) - eliminate join marks *(PR [#3580](https://togithub.com/tobymao/sqlglot/pull/3580) by [@mrhopko](https://togithub.com/mrhopko))* - [`227e054`](https://togithub.com/tobymao/sqlglot/commit/227e0544ede5dfe3063f3497e865be6e383db524) - **oracle**: support unicode strings u'...' *(PR [#3641](https://togithub.com/tobymao/sqlglot/pull/3641) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *addresses issue [#3638](https://togithub.com/tobymao/sqlglot/issues/3638) opened by [@deebify](https://togithub.com/deebify)* - [`6df5757`](https://togithub.com/tobymao/sqlglot/commit/6df5757d7714269c035b3a3a015c81bde436f2bb) - bq datetime -> timestampfromparts *(PR [#3642](https://togithub.com/tobymao/sqlglot/pull/3642) by [@tobymao](https://togithub.com/tobymao))* - [`6abd2c9`](https://togithub.com/tobymao/sqlglot/commit/6abd2c943896e65b6c9bb5343304dcd8f01b425e) - **oracle**: Support for WITH READ ONLY / CHECK OPTION *(PR [#3639](https://togithub.com/tobymao/sqlglot/pull/3639) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *addresses issue [#3635](https://togithub.com/tobymao/sqlglot/issues/3635) opened by [@deebify](https://togithub.com/deebify)* ##### :bug: Bug Fixes - [`514b3a5`](https://togithub.com/tobymao/sqlglot/commit/514b3a52384fc9164bc5c63fda6b779d68e427b0) - **redshift**: add support for Oracle style outer join markers [#3611](https://togithub.com/tobymao/sqlglot/pull/3611) *(PR [#3612](https://togithub.com/tobymao/sqlglot/pull/3612) by [@sandband](https://togithub.com/sandband))* - :arrow_lower_right: *fixes issue [#3611](https://togithub.com/tobymao/sqlglot/issues/3611) opened by [@sandband](https://togithub.com/sandband)* - [`6a607d3`](https://togithub.com/tobymao/sqlglot/commit/6a607d3fa604be7fdbd51e7de06aeedae73039b7) - unnest should also be a function *(commit by [@tobymao](https://togithub.com/tobymao))* - [`0e1a1fb`](https://togithub.com/tobymao/sqlglot/commit/0e1a1fb31de5fefc16a978162d6c6dd4141e1c4d) - **optimizer**: don't use datetrunc type for right side *(PR [#3614](https://togithub.com/tobymao/sqlglot/pull/3614) by [@barakalon](https://togithub.com/barakalon))* - [`d96459f`](https://togithub.com/tobymao/sqlglot/commit/d96459f18b308466fbbfd9fcbe658e33ec931f1e) - **postgres**: sha256 support *(commit by [@tobymao](https://togithub.com/tobymao))* - [`05fe847`](https://togithub.com/tobymao/sqlglot/commit/05fe847aeb6525836d4eadb908c65a50755dc0c5) - **snowflake**: support fqns in masking/projection policy constraint *(PR [#3620](https://togithub.com/tobymao/sqlglot/pull/3620) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3617](https://togithub.com/tobymao/sqlglot/issues/3617) opened by [@kosta-foundational](https://togithub.com/kosta-foundational)* - [`caa3051`](https://togithub.com/tobymao/sqlglot/commit/caa305161893079f87d4d51d9042b5103a850be4) - **snowflake**: Allow SELECT keyword as JSON path key *(PR [#3627](https://togithub.com/tobymao/sqlglot/pull/3627) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#3619](https://togithub.com/tobymao/sqlglot/issues/3619) opened by [@kosta-foundational](https://togithub.com/kosta-foundational)* - [`96efb64`](https://togithub.com/tobymao/sqlglot/commit/96efb6458ad5c6b92990d8ea69545e60b2eaa8a5) - **tokenizer**: properly handle tags that need to be identifiers in heredocs *(PR [#3630](https://togithub.com/tobymao/sqlglot/pull/3630) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3618](https://togithub.com/tobymao/sqlglot/issues/3618) opened by [@bigluck](https://togithub.com/bigluck)* - [`4f8edba`](https://togithub.com/tobymao/sqlglot/commit/4f8edba78d070e2d4b50da56ddb5ed139120c587) - **oracle**: Allow optional format in TO_DATE *(PR [#3637](https://togithub.com/tobymao/sqlglot/pull/3637) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#3636](https://togithub.com/tobymao/sqlglot/issues/3636) opened by [@deebify](https://togithub.com/deebify)* - [`d8c6153`](https://togithub.com/tobymao/sqlglot/commit/d8c61534f2b11287af22eb70948dfb735cd778bc) - **oracle**: don't apply eliminate_join_markers at parse time *(commit by [@georgesittas](https://togithub.com/georgesittas))* - [`1afe6ac`](https://togithub.com/tobymao/sqlglot/commit/1afe6ac62b9c827a001c5a6ab917304c5756fb09) - don't generate neq(0) if subquery predicate in ensure_bools *(commit by [@georgesittas](https://togithub.com/georgesittas))* - [`fc050bd`](https://togithub.com/tobymao/sqlglot/commit/fc050bddf937509961cfd83e9fa86ed7e931da11) - **sqlite**: Fix transpilation of GENERATED AS IDENTITY *(PR [#3634](https://togithub.com/tobymao/sqlglot/pull/3634) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#3632](https://togithub.com/tobymao/sqlglot/issues/3632) opened by [@lelandbatey](https://togithub.com/lelandbatey)* - [`47472d9`](https://togithub.com/tobymao/sqlglot/commit/47472d9c0a27070fd5f4f9b8c12a8bd8c86b1de1) - **duckdb**: get rid of TEXT length to facilitate transpilation *(PR [#3633](https://togithub.com/tobymao/sqlglot/pull/3633) by [@georgesittas](https://togithub.com/georgesittas))* ##### :recycle: Refactors - [`6194c0f`](https://togithub.com/tobymao/sqlglot/commit/6194c0f37fd322ee2c33ebe30dcee6c836a66943) - clean up logic related to join marker parsing/generation *(PR [#3613](https://togithub.com/tobymao/sqlglot/pull/3613) by [@georgesittas](https://togithub.com/georgesittas))* ##### :wrench: Chores - [`5396a8e`](https://togithub.com/tobymao/sqlglot/commit/5396a8e6ea29876c824b741c2812ad15f4768e4c) - fix SQLFrame casing *(PR [#3616](https://togithub.com/tobymao/sqlglot/pull/3616) by [@eakmanrq](https://togithub.com/eakmanrq))* - [`0397d6f`](https://togithub.com/tobymao/sqlglot/commit/0397d6f7638c658528cdfef3c85f89afc7fc8952) - bump sqlglotrs to v0.2.6 *(commit by [@georgesittas](https://togithub.com/georgesittas))*

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.

eakmanrq / sqlframe

chore(deps): update dependency sqlglot to >=24.0.0,<25.2 #70

Release Notes

Configuration