Closed renovate[bot] closed 1 week ago
Renovate will not automatically rebase this PR, because it does not recognize the last commit author and assumes somebody else may have edited the PR.
You can manually request rebase by checking the rebase/retry box above.
⚠️ Warning: custom changes will be lost.
This PR contains the following updates:
>=23.4,<25.30
->>=23.4,<25.31
Release Notes
tobymao/sqlglot (sqlglot)
### [`v25.30.0`](https://redirect.github.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v25300---2024-11-11) [Compare Source](https://redirect.github.com/tobymao/sqlglot/compare/v25.29.0...v25.30.0) ##### :boom: BREAKING CHANGES - due to [`60625ea`](https://redirect.github.com/tobymao/sqlglot/commit/60625eae34deb6a6fc36c0f3996f1281eae0ef6f) - Fix STRUCT cast generation *(PR [#4366](https://redirect.github.com/tobymao/sqlglot/pull/4366) by [@VaggelisD](https://redirect.github.com/VaggelisD))*: Fix STRUCT cast generation ([#4366](https://redirect.github.com/tobymao/sqlglot/issues/4366)) ##### :sparkles: New Features - [`87ab8fe`](https://redirect.github.com/tobymao/sqlglot/commit/87ab8fe9cc4d6d060d8fe8a9c3faf8c47c2c9ed6) - **spark, bigquery**: Add support for UNIX_SECONDS(...) *(PR [#4350](https://redirect.github.com/tobymao/sqlglot/pull/4350) by [@VaggelisD](https://redirect.github.com/VaggelisD))* - [`42da638`](https://redirect.github.com/tobymao/sqlglot/commit/42da63812ed489d1d8bbef0fc14c7dfa5ce57b7a) - **bigquery**: Support JSON_VALUE_ARRAY(...) *(PR [#4356](https://redirect.github.com/tobymao/sqlglot/pull/4356) by [@VaggelisD](https://redirect.github.com/VaggelisD))* - [`e337a42`](https://redirect.github.com/tobymao/sqlglot/commit/e337a42dd56f5358e617750e7a70a0d4b7eab3f9) - **bigquery**: Parse REGEXP_SUBSTR as exp.RegexpExtract *(PR [#4358](https://redirect.github.com/tobymao/sqlglot/pull/4358) by [@VaggelisD](https://redirect.github.com/VaggelisD))* - [`602dbf8`](https://redirect.github.com/tobymao/sqlglot/commit/602dbf84ce23f41fba6a87db70ecec6113044bac) - Support REGEXP_EXTRACT_ALL *(PR [#4359](https://redirect.github.com/tobymao/sqlglot/pull/4359) by [@VaggelisD](https://redirect.github.com/VaggelisD))* - [`27a44a2`](https://redirect.github.com/tobymao/sqlglot/commit/27a44a22ff78cc35e8ab7c91b94311ef93d86c5a) - improve Levenshtein expression transpilation *(PR [#4360](https://redirect.github.com/tobymao/sqlglot/pull/4360) by [@krzysztof-kwitt](https://redirect.github.com/krzysztof-kwitt))* - [`79c675a`](https://redirect.github.com/tobymao/sqlglot/commit/79c675a49fb44a6a7a97ea0de79822d8571724be) - **bigquery**: Support JSON_QUERY_ARRAY & JSON_EXTRACT_ARRAY *(PR [#4361](https://redirect.github.com/tobymao/sqlglot/pull/4361) by [@VaggelisD](https://redirect.github.com/VaggelisD))* - [`57722db`](https://redirect.github.com/tobymao/sqlglot/commit/57722db90394d9a102c0e76a3e4d32a9f72f9ff9) - optionally wrap connectors when using builders *(PR [#4369](https://redirect.github.com/tobymao/sqlglot/pull/4369) by [@georgesittas](https://redirect.github.com/georgesittas))* - :arrow_lower_right: *addresses issue [#4362](https://redirect.github.com/tobymao/sqlglot/issues/4362) opened by [@gabrielteotonio](https://redirect.github.com/gabrielteotonio)* - :arrow_lower_right: *addresses issue [#4367](https://redirect.github.com/tobymao/sqlglot/issues/4367) opened by [@gabrielteotonio](https://redirect.github.com/gabrielteotonio)* ##### :bug: Bug Fixes - [`eb8e2fe`](https://redirect.github.com/tobymao/sqlglot/commit/eb8e2fe3ab3fb4b88f72843a5bd21f4a3c1d895c) - bubble up comments in qualified column refs fixes [#4353](https://redirect.github.com/tobymao/sqlglot/pull/4353) *(commit by [@georgesittas](https://redirect.github.com/georgesittas))* - [`efcbfdb`](https://redirect.github.com/tobymao/sqlglot/commit/efcbfdb67b12853581fbfc0d4c4a450c0281849b) - **clickhouse**: Generate exp.Median as lowercase *(PR [#4355](https://redirect.github.com/tobymao/sqlglot/pull/4355) by [@VaggelisD](https://redirect.github.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#4354](https://redirect.github.com/tobymao/sqlglot/issues/4354) opened by [@cpcloud](https://redirect.github.com/cpcloud)* - [`60625ea`](https://redirect.github.com/tobymao/sqlglot/commit/60625eae34deb6a6fc36c0f3996f1281eae0ef6f) - **duckdb**: Fix STRUCT cast generation *(PR [#4366](https://redirect.github.com/tobymao/sqlglot/pull/4366) by [@VaggelisD](https://redirect.github.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#4365](https://redirect.github.com/tobymao/sqlglot/issues/4365) opened by [@NickCrews](https://redirect.github.com/NickCrews)* - [`a665030`](https://redirect.github.com/tobymao/sqlglot/commit/a665030323b200f3bed241bb928993b9807c4100) - safe removal while iterating expression list for multiple UNNEST expressions *(PR [#4364](https://redirect.github.com/tobymao/sqlglot/pull/4364) by [@gauravsagar483](https://redirect.github.com/gauravsagar483))* - [`a71cee4`](https://redirect.github.com/tobymao/sqlglot/commit/a71cee4b4eafad9988b945c69dc75583ae105ec7) - Transpilation of exp.ArraySize from Postgres (read) *(PR [#4370](https://redirect.github.com/tobymao/sqlglot/pull/4370) by [@VaggelisD](https://redirect.github.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#4368](https://redirect.github.com/tobymao/sqlglot/issues/4368) opened by [@dor-bernstein](https://redirect.github.com/dor-bernstein)* - [`702fe31`](https://redirect.github.com/tobymao/sqlglot/commit/702fe318dadbe6cb83676e2a23ee830774697bb0) - Remove flaky timing test *(PR [#4371](https://redirect.github.com/tobymao/sqlglot/pull/4371) by [@VaggelisD](https://redirect.github.com/VaggelisD))* - [`4d3904e`](https://redirect.github.com/tobymao/sqlglot/commit/4d3904e8906f0573f3352ad82282ea09c571daa8) - **spark**: Support DB's TIMESTAMP_DIFF *(PR [#4373](https://redirect.github.com/tobymao/sqlglot/pull/4373) by [@VaggelisD](https://redirect.github.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#4372](https://redirect.github.com/tobymao/sqlglot/issues/4372) opened by [@nikmalviya](https://redirect.github.com/nikmalviya)* - [`060ecfc`](https://redirect.github.com/tobymao/sqlglot/commit/060ecfc75fd8a07ffbc19f34959155a0fce317b6) - don't generate comments in table_name *(PR [#4375](https://redirect.github.com/tobymao/sqlglot/pull/4375) by [@georgesittas](https://redirect.github.com/georgesittas))* ##### :wrench: Chores - [`e19fb62`](https://redirect.github.com/tobymao/sqlglot/commit/e19fb620dbe6e405518aee381183e4640b638aa4) - improve error handling for unnest_to_explode *(PR [#4339](https://redirect.github.com/tobymao/sqlglot/pull/4339) by [@gauravsagar483](https://redirect.github.com/gauravsagar483))*Configuration
📅 Schedule: Branch creation - "after 10pm every weekday,every weekend,before 5am every weekday" (UTC), 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 was generated by Mend Renovate. View the repository job log.