Bump sqlglot from 25.8.1 to 25.9.0

[dependabot[bot]]

Bumps sqlglot from 25.8.1 to 25.9.0.

Changelog

Sourced from sqlglot's changelog.

[v25.9.0] - 2024-08-05

:boom: BREAKING CHANGES

• due to 64e187c - transpile postgres impliclitly exploding GENERATE_SERIES proje… (PR #3853 by @​georgesittas):

  transpile postgres impliclitly exploding GENERATE_SERIES proje… (#3853)

• due to e53e7cc - Generation of exp.ArrayConcat for 2-arg based dialects (PR #3864 by @​VaggelisD):

  Generation of exp.ArrayConcat for 2-arg based dialects (#3864)

• due to 659b8bf - Support for BQ's exp.GenerateDateArray generation (PR #3865 by @​VaggelisD):

  Support for BQ's exp.GenerateDateArray generation (#3865)

:sparkles: New Features

• 6afed2a - duckdb: Support for exp.TimeDiff generation (PR #3856 by @​VaggelisD)
• 64e187c - transpile postgres impliclitly exploding GENERATE_SERIES proje… (PR #3853 by @​georgesittas)
  • :arrow_lower_right: addresses issue #3818 opened by @​wojciechowski-p
• 8a948c8 - teradata: Parse RENAME TABLE as Command (PR #3863 by @​VaggelisD)
  • :arrow_lower_right: addresses issue #3861 opened by @​EdouardW
• 659b8bf - duckdb: Support for BQ's exp.GenerateDateArray generation (PR #3865 by @​VaggelisD)
• 734f54b - snowflake: add support for a a couple of missing clauses in PIVOT clause (PR #3867 by @​georgesittas)

:bug: Bug Fixes

• 8710763 - presto: map %W to %A in the TIME_MAPPING (PR #3855 by @​georgesittas)
  • :arrow_lower_right: fixes issue #3854 opened by @​ddelzell
• 532f3c8 - duckdb: Add implicit casts to DATE_DIFF (PR #3857 by @​VaggelisD)
• 299c4a5 - clickhouse: Fix SETTINGS parsing (PR #3859 by @​VaggelisD)
  • :arrow_lower_right: fixes issue #3858 opened by @​obazna
• 810d23d - parser: make assignment parsing more lenient by allowing keyword in LHS (PR #3866 by @​georgesittas)
• e53e7cc - Generation of exp.ArrayConcat for 2-arg based dialects (PR #3864 by @​VaggelisD)
• 813f127 - duckdb: Allow DESCRIBE as a _parse_select() path (PR #3871 by @​VaggelisD)
  • :arrow_lower_right: fixes issue #3869 opened by @​cpcloud
• 6ff0c01 - Fixed size array parsing (PR #3870 by @​VaggelisD)
  • :arrow_lower_right: fixes issue #3868 opened by @​tekumara

Commits

• 306ca97 Fix!(optimizer): detect correlation in derived tables nested within subquerie...
• 6ff0c01 fix: Fixed size array parsing (#3870)
• 813f127 fix(duckdb): Allow DESCRIBE as a _parse_select() path (#3871)
• 734f54b Feat(snowflake): add support for a a couple of missing clauses in PIVOT claus...
• 659b8bf feat(duckdb)!: Support for BQ's exp.GenerateDateArray generation (#3865)
• e53e7cc fix!: Generation of exp.ArrayConcat for 2-arg based dialects (#3864)
• 810d23d Fix(parser): make assignment parsing more lenient by allowing keyword in LHS ...
• 8a948c8 feat(teradata): Parse RENAME TABLE as Command (#3863)
• 64e187c Feat!: transpile postgres impliclitly exploding GENERATE_SERIES proje… (#3853)
• 6afed2a feat(duckdb): Support for exp.TimeDiff generation (#3856)
• Additional commits viewable in compare view

Most Recent Ignore Conditions Applied to This Pull Request

| Dependency Name | Ignore Conditions | | --- | --- | | sqlglot | [>= 24.a, < 25] |

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

[dependabot[bot]]

Superseded by #781.