python/sqlglot
1
0
Fork 0
Code Issues Activity
sqlglot/CHANGELOG.md
Daniel Baumann a99682f526
Merging upstream version 26.19.0. 
Signed-off-by: Daniel Baumann <daniel@debian.org>
2025-05-24 07:15:28 +02:00

790 KiB
Raw Permalink Blame History

Changelog

v26.18.1 - 2025-05-20

🔧 Chores

v26.18.0 - 2025-05-20

💥 BREAKING CHANGES

  • due to 1df7f61 - refactor length_sql so it handles any type, not just varchar/blob (PR #4935 by @tekumara):

    refactor length_sql so it handles any type, not just varchar/blob (#4935)

  • due to 52719f3 - parse CREATE STAGE (PR #4947 by @tekumara):

    parse CREATE STAGE (#4947)

  • due to fd39b30 - parse CREATE FILE FORMAT (PR #4948 by @tekumara):

    parse CREATE FILE FORMAT (#4948)

  • due to f835756 - Fix CREATE EXTERNAL TABLE properties (PR #4951 by @VaggelisD):

    Fix CREATE EXTERNAL TABLE properties (#4951)

  • due to 44b955b - Fix generation of exp.Values (PR #4930 by @VaggelisD):

    Fix generation of exp.Values (#4930)

  • due to 1f506b1 - support SHOW (ALL) TABLES (PR #4961 by @mscolnick):

    support SHOW (ALL) TABLES (#4961)

  • due to 72cf4a4 - Add support for PIVOT multiple IN clauses (PR #4964 by @VaggelisD):

    Add support for PIVOT multiple IN clauses (#4964)

  • due to 400ea54 - ensure JSON_FORMAT type is JSON when targeting Presto (PR #4968 by @georgesittas):

    ensure JSON_FORMAT type is JSON when targeting Presto (#4968)

  • due to cb20038 - treat GO as command (PR #4978 by @georgesittas):

    treat GO as command (#4978)

  • due to 60e26b8 - improve transpilability of GET_JSON_OBJECT by parsing json path (PR #4980 by @georgesittas):

    improve transpilability of GET_JSON_OBJECT by parsing json path (#4980)

  • due to 2b7845a - Add support for Athena's Iceberg partitioning transforms (PR #4976 by @VaggelisD):

    Add support for Athena's Iceberg partitioning transforms (#4976)

  • due to ee794e9 - use the standard POWER function instead of ^ fixes #4982 (commit by @georgesittas):

    use the standard POWER function instead of ^ fixes #4982

  • due to 2369195 - consistently parse INTERVAL value as a string (PR #4986 by @georgesittas):

    consistently parse INTERVAL value as a string (#4986)

  • due to e866cff - support RELY option for PRIMARY KEY, FOREIGN KEY, and UNIQUE constraints (PR #4987 by @geooo109):

    support RELY option for PRIMARY KEY, FOREIGN KEY, and UNIQUE constraints (#4987)

  • due to 510984f - stop generating redundant TO_DATE calls (PR #4990 by @georgesittas):

    stop generating redundant TO_DATE calls (#4990)

  • due to da9ec61 - Fix pretty generation of exp.Window (PR #4994 by @VaggelisD):

    Fix pretty generation of exp.Window (#4994)

  • due to fb83fac - remove recursion from simplify (PR #4988 by @georgesittas):

    remove recursion from simplify (#4988)

  • due to 890b24a - remove connector_depth as it is now dead code (commit by @georgesittas):

    remove connector_depth as it is now dead code

  • due to 1dc501b - remove max_depth argument in simplify as it is now dead code (commit by @georgesittas):

    remove max_depth argument in simplify as it is now dead code

  • due to f5358d8 - add support for GET statements (PR #5019 by @eruditmorina):

    add support for GET statements (#5019)

  • due to bafa7f3 - parse DOW and DOY (PR #5037 by @geooo109):

    parse DOW and DOY (#5037)

  • due to eb0a989 - support udf environment property (PR #5045 by @geooo109):

    support udf environment property (#5045)

  • due to 807fbbc - transpile timestamp without time zone (PR #5047 by @geooo109):

    transpile timestamp without time zone (#5047)

  • due to c48fc8f - support translate with error (PR #5052 by @geooo109):

    support translate with error (#5052)

  • due to 2e9704e - Change COLLATE expression to Var for ALTER TABLE (PR #5055 by @MarcusRisanger):

    Change COLLATE expression to Var for ALTER TABLE (#5055)

  • due to 63f505e - unqualify UNNEST only the left most part of a column (PR #5069 by @geooo109):

    unqualify UNNEST only the left most part of a column (#5069)

  • due to 56da962 - to_timestamp without format (PR #5070 by @geooo109):

    to_timestamp without format (#5070)

  • due to 1ddfcbe - support CONVERT function (PR #5074 by @geooo109):

    support CONVERT function (#5074)

  • due to ba52f01 - respect normalization strategy overrides (PR #5080 by @georgesittas):

    respect normalization strategy overrides (#5080)

✨ New Features

🐛 Bug Fixes

♻️ Refactors

🔧 Chores