NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
PyPI, #318 most downloaded on PyPI
An easily customizable SQL parser and transpiler
Latest stable
30.33.0
Last release 5 days ago
17 Nov 2026
Ships fairly regularly
a new release about every 2 weeks
Nearly every release is documented
notes for 57 of the last 60 stable releases
2 versions withdrawn
withdrawn after publishing
6 years old
795 releases · first in 2021
Drag across the ruler to compare, or tap a release to open it.
due to `8b465d4` - expand single VALUES clause in CTE into a SELECT * *(PR #4617 by @georgesittas)*:
due to 8b465d4 - expand single VALUES clause in CTE into a SELECT * (PR #4617 by @georgesittas):
expand single VALUES clause in CTE into a SELECT * (#4617)
due to 59d886d - treat LEVEL column in CONNECT BY queries as an identifier (PR #4627 by @georgesittas):
treat LEVEL column in CONNECT BY queries as an identifier (#4627)
due to 9db09ff - support more compact SAFE_DIVIDE transpilation #4634 (PR #4641 by @geooo109):
support more compact SAFE_DIVIDE transpilation #4634 (#4641)
due to 94af80b - Do not remove parens on bracketed expressions (PR #4645 by @VaggelisD):
Do not remove parens on bracketed expressions (#4645)
due to 35923e9 - POSITION and all their variants for all dialects (PR #4606 by @pruzko):
POSITION and all their variants for all dialects (#4606)
e47a7c9 - Fix Oracle Integer Type Mapping (PR #4616 by @pruzko)d8ade83 - clickhouse: Dynamic data type (PR #4624 by @pkit)f7628ad - optimizer: Fix qualify for SEMI/ANTI joins (PR #4622 by @VaggelisD)
a20b663 - improve rs tokenizer performance (PR #4638 by @benfdking)ffa0df7 - parser: Support Oracle/Postgres XMLNAMESPACES in XMLTABLE (PR #4643 by @rbreejen)
35923e9 - POSITION and all their variants for all dialects (PR #4606 by @pruzko)14474ee - tsql: support TSQL PRIMARY KEY constraint with DESC, ASC (PR #4618 by @geooo109)
8b465d4 - parser: expand single VALUES clause in CTE into a SELECT * (PR #4617 by @georgesittas)
647d986 - snowflake: get rid of incorrect time mappings (PR #4629 by @georgesittas)9cbd5ef - trino: generate ArrayUniqueAgg as ARRAY_AGG(DISTINCT ...) (commit by @georgesittas)59d886d - optimizer: treat LEVEL column in CONNECT BY queries as an identifier (PR #4627 by @georgesittas)
6107661 - snowflake: Allow parsing of TO_TIME (PR #4631 by @VaggelisD)
9fdfd4d - trino: support QUOTES option for JSON_QUERY #4623 (PR #4628 by @geooo109)
43eb0d9 - tsql: create schema ast access fixup fixes #4632 (commit by @georgesittas)59f6525 - duckdb: Transpile exp.RegexpILike (PR #4640 by @VaggelisD)
9db09ff - bigquery: support more compact SAFE_DIVIDE transpilation #4634 (PR #4641 by @geooo109)
94af80b - optimizer: Do not remove parens on bracketed expressions (PR #4645 by @VaggelisD)
761e835 - qualify using (PR #4646 by @tobymao)8b0b8ac - sqlite: allow 2-arg version of UNHEX closes #4648 (commit by @georgesittas)2f12bd9 - athena: Generate PartitionedByProperty correctly on CTAS for an Iceberg table (PR #4654 by @erindru)1ea0dc2 - postgres: Support WITHIN GROUP ( order_by_clause ) FILTER for Postgres (PR #4652 by @gl3nnleblanc)
284a936 - simplify WITHIN GROUP ... FILTER support (commit by @georgesittas)73512f9 - set default properly for use_rs_tokenizer (PR #4619 by @georgesittas)9ba1db3 - add bench command (PR #4621 by @benfdking)0aa1516 - move to string new (PR #4637 by @benfdking)2355a91 - clean up unnecessary mut (PR #4636 by @benfdking)0b68af5 - bump sqlglotrs to 0.3.6 (commit by @georgesittas)Your coding agent can read these notes before it upgrades. Set up the MCP server →
`b447322` - parser accepts ctes without as keyword again, except for clickhouse *(PR #4612 by @georgesittas)*
b447322 - parser accepts ctes without as keyword again, except for clickhouse (PR #4612 by @georgesittas)due to `f3fcc10` - allow limit, offset to be used as both modifiers and aliases *(PR #4589 by @georgesittas)*:
due to f3fcc10 - allow limit, offset to be used as both modifiers and aliases (PR #4589 by @georgesittas):
allow limit, offset to be used as both modifiers and aliases (#4589)
due to b7ab3f1 - exp.Merge condition for Trino/Postgres (PR #4596 by @MikeWallis42):
exp.Merge condition for Trino/Postgres (#4596)
due to e617d40 - extend ANALYZE common syntax to cover multiple dialects (PR #4591 by @zashroof):
extend ANALYZE common syntax to cover multiple dialects (#4591)
c75016a - parse analyze compute statistics (PR #4547 by @zashroof)986a1da - Druid dialect (PR #4579 by @betodealmeida)bc9975f - move to rustc fx hashmap (PR #4588 by @benfdking)853cbe6 - cleaner IS_ASCII for TSQL (PR #4592 by @pruzko)3ebd879 - LOGICAL_AND and LOGICAL_OR for Oracle (PR #4593 by @pruzko)e617d40 - extend ANALYZE common syntax to cover multiple dialects (PR #4591 by @zashroof)766d698 - postgres: Revert exp.StrPos generation (PR #4586 by @VaggelisD)f3fcc10 - parser: allow limit, offset to be used as both modifiers and aliases (PR #4589 by @georgesittas)
2bea466 - optimizer: unions on nested subqueries (PR #4603 by @barakalon)199508a - snowflake: treat $ as part of the json path key identifier (PR #4604 by @georgesittas)b7ab3f1 - exp.Merge condition for Trino/Postgres (PR #4596 by @MikeWallis42)
c0f7309 - simplify trie_filter closure in Tokenizer initialization (PR #4599 by @gvozdvmozgu)fb93219 - replace std::mem::replace with std::mem::take and Vec::drain (PR #4600 by @gvozdvmozgu)672d656 - clean up ANALYZE implementation (PR #4607 by @georgesittas)e58a8cb - apply clippy fixes (PR #4608 by @benfdking)5502c94 - bump sqlglotrs to 0.3.5 (commit by @georgesittas)`d250846` - snowflake: generate LIMIT when OFFSET exists #4575 *(PR #4581 by @geooo109)*
ffbb935 - install python 3.7 when building windows wheel for sqlglotrs (PR #4585 by @georgesittas)1ea05c0 - bump sqlglotrs to 0.3.4 (commit by @georgesittas)`e33af0b` - try setup-python@v5 in the publish job *(PR #4582 by @georgesittas)*
e33af0b - try setup-python@v5 in the publish job (PR #4582 by @georgesittas)3259f84 - bump sqlglotrs to 0.3.3 (commit by @georgesittas)`e51d1cf` - release sqlglotrs for Python 3.13 on windows *(PR #4580 by @VaggelisD)*
e51d1cf - release sqlglotrs for Python 3.13 on windows (PR #4580 by @VaggelisD)975ffa0 - bump sqlglotrs to 0.3.2 (commit by @georgesittas)due to `07d05da` - normalize before qualifying tables *(PR #4539 by @tobymao)*:
due to 07d05da - normalize before qualifying tables (PR #4539 by @tobymao):
normalize before qualifying tables (#4539)
due to cead7c3 - require AS token in CTEs for all dialects except spark, databricks (PR #4546 by @georgesittas):
require AS token in CTEs for all dialects except spark, databricks (#4546)
due to 231d032 - support Unicode in sqlite, mysql, tsql, postgres, oracle (PR #4554 by @pruzko):
support Unicode in sqlite, mysql, tsql, postgres, oracle (#4554)
due to 83595b6 - parse ASCII into Unicode to facilitate transpilation (commit by @georgesittas):
parse ASCII into Unicode to facilitate transpilation
due to e141960 - improve transpilation of CHAR[ACTER]_LENGTH (PR #4555 by @pruzko):
improve transpilation of CHAR[ACTER]_LENGTH (#4555)
7a517d7 - Introduce meta comment to parse known functions as exp.Anonymous (PR #4532 by @VaggelisD)
6992c18 - tokenizer: Allow underscore separated number literals (PR #4536 by @VaggelisD)
7fe9f7f - tsql: add support for DATETRUNC #4531 (PR #4537 by @geooo109)
931eef6 - duckdb: Support simplified UNPIVOT statement (PR #4545 by @VaggelisD)
923a1f7 - treat NAMESPACE as a db creatable (PR #4556 by @TanviPardeshi)b0cc7d0 - add support for IS_ASCII (PR #4557 by @pruzko)231d032 - support Unicode in sqlite, mysql, tsql, postgres, oracle (PR #4554 by @pruzko)83595b6 - hive: parse ASCII into Unicode to facilitate transpilation (commit by @georgesittas)095fb1e - generate POSITION instead of STRPOS for Postgres (PR #4577 by @pruzko)9def0b7 - add support for Chr in tsql and sqlite (PR #4566 by @pruzko)d32d26a - postgres: add support for XMLTABLE (commit by @georgesittas)e141960 - improve transpilation of CHAR[ACTER]_LENGTH (PR #4555 by @pruzko)07d05da - normalize before qualifying tables (PR #4539 by @tobymao)
1ed3235 - allow When in exp.merge fixes #4543 (commit by @georgesittas)cead7c3 - parser: require AS token in CTEs for all dialects except spark, databricks (PR #4546 by @georgesittas)
006b384 - postgres: add support for WHERE clause in INSERT DML (PR #4550 by @georgesittas)
795e7e0 - Pin ubuntu to 22.04 for Python 3.7 (PR #4571 by @VaggelisD)2495508 - tsql: generate correct DateFromParts naming (PR #4563 by @geooo109)
2aff4ae - duckdb: support parentheses with FROM-First syntax (PR #4569 by @geooo109)
51ac9a7 - rust-tokenizer: increase integer width when converting hex literals (PR #4573 by @georgesittas)
94ffdb7 - addressing mismatch in STR_POSITION argument order in executor. (PR #4574 by @cecilycarver)139b699 - tsql: transpile snowflake TIMESTAMP_NTZ to DATETIME2 (PR #4576 by @geooo109)ceb42fa - parse & generate Length properly in clickhouse (commit by @georgesittas)9921528 - introduce benchmarking for rust (PR #4552 by @benfdking)0ffe8f9 - temporarily disable sqlglotrs benchmarking (PR #4578 by @georgesittas)7a0dbcf - bump sqlglotrs to 0.3.1 (commit by @georgesittas)`5d3ee4c` - snowflake: transpile date subtraction *(PR #4506 by @georgesittas)*
5d3ee4c - snowflake: transpile date subtraction (PR #4506 by @georgesittas)
efeb4bd - postgres: add support for XMLELEMENT (PR #4513 by @georgesittas)
e495777 - clickhouse: add support for bracket map syntax (PR #4528 by @georgesittas)
cc44ed7 - mysql: Support SERIAL data type (PR #4533 by @VaggelisD)
ee7dc96 - starrocks: add partition by range and unique key (PR #4509 by @pickfire)84ec478 - lineage: Extend lineage function to work with pivot operation (PR #4471 by @step4)52c8374 - include comments in gen (PR #4535 by @georgesittas)8f8e84a - snowflake: bitxor third parameter(padside) issue (PR #4501 by @ankur334)4760246 - snowflake: generate only one INPUT => clause in unnest_sql (PR #4505 by @georgesittas)
7649d50 - optimizer: only expand stars for select scopes (PR #4515 by @georgesittas)
2b68b9b - snowflake: Allow alias expansion inside JOIN statements (PR #4504 by @florian-ernst-alan)
e15cd0b - postgres: generate float if the type has precision (PR #4516 by @georgesittas)
98906d4 - another interval parsing edge case (PR #4519 by @georgesittas)
992f6e9 - tsql: Convert exp.Neg literal to number through to_py() (PR #4523 by @VaggelisD)
946cd42 - optimizer: qualify snowflake queries with level pseudocolumn (PR #4524 by @georgesittas)
bc68289 - planner: ensure aggregate variable is bound (PR #4526 by @georgesittas)
cd6e00f - clean up pivot lineage (PR #4534 by @georgesittas)due to `1d3c9aa` - Transpile support for bitor/bit_or snowflake function *(PR #4486 by @ankur334)*:
due to 1d3c9aa - Transpile support for bitor/bit_or snowflake function (PR #4486 by @ankur334):
Transpile support for bitor/bit_or snowflake function (#4486)
due to ab10851 - Preserve roundtrips of DATETIME/DATETIME2 (PR #4491 by @VaggelisD):
Preserve roundtrips of DATETIME/DATETIME2 (#4491)
1d3c9aa - snowflake: Transpile support for bitor/bit_or snowflake function (PR #4486 by @ankur334)822aea0 - snowflake: Support for inline FOREIGN KEY (PR #4493 by @VaggelisD)
ab10851 - tsql: Preserve roundtrips of DATETIME/DATETIME2 (PR #4491 by @VaggelisD)43975e4 - duckdb: Allow escape strings similar to Postgres (PR #4497 by @VaggelisD)
due to `f70f124` - transpile MySQL FORMAT to DuckDB *(PR #4488 by @georgesittas)*:
due to f70f124 - transpile MySQL FORMAT to DuckDB (PR #4488 by @georgesittas):
transpile MySQL FORMAT to DuckDB (#4488)
f70f124 - transpile MySQL FORMAT to DuckDB (PR #4488 by @georgesittas)
5a276f3 - add parse into tuple (commit by @tobymao)ddf7483 - enable python 3.13 in CI (PR #4483 by @simon-pactum)due to `41c6d24` - Alias expanded USING STRUCT fields *(PR #4474 by @VaggelisD)*:
due to 41c6d24 - Alias expanded USING STRUCT fields (PR #4474 by @VaggelisD):
Alias expanded USING STRUCT fields (#4474)
41c6d24 - optimizer: Alias expanded USING STRUCT fields (PR #4474 by @VaggelisD)
a34bcde - bigquery: properly consume dashed table parts (PR #4477 by @georgesittas)
438ae4c - bigquery: Do not generate NULL ordering on Windows (PR #4480 by @VaggelisD)
due to `07fa69d` - Make TIMESTAMP map to Type.TIMESTAMPTZ *(PR #4451 by @VaggelisD)*:
due to 07fa69d - Make TIMESTAMP map to Type.TIMESTAMPTZ (PR #4451 by @VaggelisD):
Make TIMESTAMP map to Type.TIMESTAMPTZ (#4451)
due to 63d8f41 - treat NEXT as a func keyword, parse NEXT VALUE FOR in tsql, oracle (PR #4467 by @georgesittas):
treat NEXT as a func keyword, parse NEXT VALUE FOR in tsql, oracle (#4467)
3945acc - allow tables to be preserved in replace_table (PR #4468 by @georgesittas)a9dca8d - postgres: Support generated columns (PR #4472 by @VaggelisD)
380dad2 - bigquery: Rename CONTAINS_SUBSTRING to CONTAINS_SUBSTR (PR #4457 by @VaggelisD)
ca5023d - presto: Remove parentheses from CURRENT_USER (PR #4459 by @MikeWallis42)
07fa69d - spark: Make TIMESTAMP map to Type.TIMESTAMPTZ (PR #4451 by @VaggelisD)
63d8f41 - parser: treat NEXT as a func keyword, parse NEXT VALUE FOR in tsql, oracle (PR #4467 by @georgesittas)
`954d8fd` - parse DEFAULT in VALUES clause into a Var *(PR #4448 by @georgesittas)*
954d8fd - parse DEFAULT in VALUES clause into a Var (PR #4448 by @georgesittas)
73afd0f - bigquery: Make JSONPathTokenizer more lenient for new standards (PR #4447 by @VaggelisD)
due to `0eed45c` - Add support for ATTACH/DETACH statements *(PR #4419 by @VaggelisD)*:
due to 0eed45c - Add support for ATTACH/DETACH statements (PR #4419 by @VaggelisD):
Add support for ATTACH/DETACH statements (#4419)
due to da48b68 - Tokenize hints as comments (PR #4426 by @VaggelisD):
Tokenize hints as comments (#4426)
due to fe35394 - fix datetime coercion in the canonicalize rule (PR #4431 by @georgesittas):
fix datetime coercion in the canonicalize rule (#4431)
due to fddcd3d - bump sqlglotrs to 0.3.0 (commit by @georgesittas):
bump sqlglotrs to 0.3.0
0eed45c - duckdb: Add support for ATTACH/DETACH statements (PR #4419 by @VaggelisD)2db757d - bigquery: Support FEATURES_AT_TIME (PR #4430 by @VaggelisD)
fc591ae - risingwave: add support for SINK, SOURCE & other DDL properties (PR #4387 by @lin0303-siyuan)a2bde2e - mysql: improve transpilability of CHAR[ACTER]_LENGTH (commit by @georgesittas)0acc248 - snowflake: Support CREATE ... WITH TAG (PR #4434 by @asikowitz)
37863ff - snowflake: Transpile non-UNNEST exp.GenerateDateArray refs (PR #4433 by @VaggelisD)83ee97b - parser: Do not parse window function arg as exp.Column (PR #4415 by @VaggelisD)
b22e0c8 - parser: Extend DESCRIBE parser for MySQL FORMAT & statements (PR #4417 by @VaggelisD)
d1d2ae7 - duckdb: Allow count arg on exp.ArgMax & exp.ArgMin (PR #4413 by @aersam)
e3c45d5 - presto reset session closes #4421 (commit by @tobymao)fd81f1b - more presto commands (commit by @tobymao)da48b68 - Tokenize hints as comments (PR #4426 by @VaggelisD)
69d4a8c - tsql: Map weekday to %w (PR #4438 by @VaggelisD)
41d6a13 - add return type (PR #4440 by @etonlels)fe35394 - optimizer: fix datetime coercion in the canonicalize rule (PR #4431 by @georgesittas)
6aea9f3 - Refactor NORMALIZE_FUNCTIONS flag usage (PR #4437 by @VaggelisD)f32a435 - risingwave: clean up SINK/SOURCE logic (PR #4432 by @georgesittas)b24aced - snowflake: clean up [WITH] TAG property / constraint (PR #4439 by @georgesittas)fddcd3d - bump sqlglotrs to 0.3.0 (commit by @georgesittas)`59b8b6d` - preserve column quoting in DISTINCT ON elimination *(commit by @georgesittas)*
59b8b6d - preserve column quoting in DISTINCT ON elimination (commit by @georgesittas)`835e717` - clickhouse: transform function support *(PR #4408 by @GaliFFun)*
0479743 - snowflake: cast to TimeToStr arg to TIMESTAMP more conservatively (commit by @georgesittas)`d851269` - use existing aliases in DISTINCT ON elimination, if any *(commit by @georgesittas)*
d851269 - use existing aliases in DISTINCT ON elimination, if any (commit by @georgesittas)`b00d857` - add support for specifying column in row_number function *(PR #4406 by @GaliFFun)*
due to `f4abfd5` - Support FORMAT_TIMESTAMP *(PR #4383 by @VaggelisD)*:
due to f4abfd5 - Support FORMAT_TIMESTAMP (PR #4383 by @VaggelisD):
Support FORMAT_TIMESTAMP (#4383)
due to 45eef60 - use select star when eliminating distinct on (PR #4401 by @agrigoroi-palantir):
use select star when eliminating distinct on (#4401)
72ffdcb - bigquery: Add parsing support for STRPOS(...) (PR #4378 by @VaggelisD)e7b67e0 - bigquery: Support MAKE_INTERVAL (PR #4384 by @VaggelisD)37c4809 - bigquery: Support INT64(...) (PR #4391 by @VaggelisD)9694999 - Add support for CONTAINS(...) (PR #4399 by @VaggelisD)f4abfd5 - bigquery: Support FORMAT_TIMESTAMP (PR #4383 by @VaggelisD)bb46ee3 - parser: Parse exp.Column for DROP COLUMN (PR #4390 by @VaggelisD)
79f6783 - snowflake: Wrap DIV0 operands if they're binary expressions (PR #4393 by @VaggelisD)
647b98d - starrocks: Add RESERVED_KEYWORDS specific to starrocks (PR #4402 by @notexistence)45eef60 - use select star when eliminating distinct on (PR #4401 by @agrigoroi-palantir)a3af2af - attach stamement comments consistently (PR #4377 by @georgesittas)
858c5b1 - improve contribution guide (PR #4379 by @georgesittas)160e688 - fix relative benchmark import, comment out sqltree (PR #4403 by @georgesittas)8d78add - bump PYO3 to v"0.22.6" (PR #4400 by @MartinSahlen)f78e755 - bump sqlglotrs to v0.2.14 (commit by @georgesittas)due to `60625ea` - Fix STRUCT cast generation *(PR #4366 by @VaggelisD)*:
due to 60625ea - Fix STRUCT cast generation (PR #4366 by @VaggelisD):
Fix STRUCT cast generation (#4366)
87ab8fe - spark, bigquery: Add support for UNIX_SECONDS(...) (PR #4350 by @VaggelisD)42da638 - bigquery: Support JSON_VALUE_ARRAY(...) (PR #4356 by @VaggelisD)e337a42 - bigquery: Parse REGEXP_SUBSTR as exp.RegexpExtract (PR #4358 by @VaggelisD)602dbf8 - Support REGEXP_EXTRACT_ALL (PR #4359 by @VaggelisD)27a44a2 - improve Levenshtein expression transpilation (PR #4360 by @krzysztof-kwitt)79c675a - bigquery: Support JSON_QUERY_ARRAY & JSON_EXTRACT_ARRAY (PR #4361 by @VaggelisD)57722db - optionally wrap connectors when using builders (PR #4369 by @georgesittas)
eb8e2fe - bubble up comments in qualified column refs fixes #4353 (commit by @georgesittas)efcbfdb - clickhouse: Generate exp.Median as lowercase (PR #4355 by @VaggelisD)
60625ea - duckdb: Fix STRUCT cast generation (PR #4366 by @VaggelisD)
a665030 - safe removal while iterating expression list for multiple UNNEST expressions (PR #4364 by @gauravsagar483)a71cee4 - Transpilation of exp.ArraySize from Postgres (read) (PR #4370 by @VaggelisD)
702fe31 - Remove flaky timing test (PR #4371 by @VaggelisD)4d3904e - spark: Support DB's TIMESTAMP_DIFF (PR #4373 by @VaggelisD)
060ecfc - don't generate comments in table_name (PR #4375 by @georgesittas)e19fb62 - improve error handling for unnest_to_explode (PR #4339 by @gauravsagar483)due to `e92904e` - Transpile ANY to EXISTS *(PR #4305 by @VaggelisD)*:
due to e92904e - Transpile ANY to EXISTS (PR #4305 by @VaggelisD):
Transpile ANY to EXISTS (#4305)
due to 23e620f - Support MEDIAN() function (PR #4317 by @VaggelisD):
Support MEDIAN() function (#4317)
due to a093ae7 - always wrap value in NOT value IS ... (PR #4331 by @georgesittas):
always wrap value in NOT value IS ... (#4331)
due to 84f78aa - parse information schema views into a single identifier (PR #4336 by @georgesittas):
parse information schema views into a single identifier (#4336)
efd9b4e - postgres: Support JSONB_EXISTS (PR #4302 by @VaggelisD)
e92904e - spark: Transpile ANY to EXISTS (PR #4305 by @VaggelisD)
2af4936 - snowflake: Transpile BQ's TIMESTAMP() function (PR #4309 by @VaggelisD)50a1c91 - snowflake: Transpile exp.TimestampAdd (PR #4320 by @VaggelisD)01671ce - teradata: add support for hexadecimal literals (PR #4323 by @thomascjohnson)23e620f - Support MEDIAN() function (PR #4317 by @VaggelisD)
9faef8d - snowflake: Transpile exp.TimestampSub (PR #4329 by @VaggelisD)2d98cac - BigQuery: Support JSON_VALUE() (PR #4332 by @VaggelisD)f8fec0a - snowflake: Transpile exp.DatetimeDiff (PR #4334 by @VaggelisD)16fd1ea - BigQuery: Support JSON_QUERY (PR #4333 by @VaggelisD)c09b6a2 - duckdb: support flags for RegexpExtract (PR #4326 by @NickCrews)536973c - trino: add support for the ON OVERFLOW clause in LISTAGG (PR #4340 by @georgesittas)4584935 - snowflake: Transpile exp.StrToDate (PR #4348 by @VaggelisD)71f4a47 - snowflake: Transpile exp.DatetimeAdd (PR #4349 by @VaggelisD)551afff - handle a Move edge case in the semantic differ (PR #4295 by @georgesittas)a66e721 - generator: Add NULL FILTER on ARRAY_AGG only for columns (PR #4301 by @VaggelisD)
b4ea602 - clickhouse: improve parsing of WITH FILL ... INTERPOLATE (PR #4311 by @georgesittas)
749886b - tsql: Generate LOG(...) for exp.Ln (PR #4318 by @VaggelisD)
5c1b1f4 - parser: optionally parse a Stream expression (PR #4325 by @georgesittas)
bb49a00 - oracle: Do not normalize time units for exp.DateTrunc (PR #4328 by @VaggelisD)
a093ae7 - clickhouse: always wrap value in NOT value IS ... (PR #4331 by @georgesittas)
def4f1e - Refactor exp.RegexpExtract (follow up 4326) (PR #4341 by @VaggelisD)c1456d0 - presto/trino current_time closes #4344 (commit by @tobymao)8e16abe - duckdb: we ALWAYS need to render group if params is present for RegexpExtract (PR #4343 by @NickCrews)1689dc7 - bigquery: Parse timezone for DATE_TRUNC (PR #4347 by @VaggelisD)
84f78aa - bigquery: parse information schema views into a single identifier (PR #4336 by @georgesittas)due to `1691388` - Fix chained exp.SetOperation type annotation *(PR #4274 by @VaggelisD)*:
due to 1691388 - Fix chained exp.SetOperation type annotation (PR #4274 by @VaggelisD):
Fix chained exp.SetOperation type annotation (#4274)
due to c3c1997 - Add support for STRING function (PR #4284 by @VaggelisD):
Add support for STRING function (#4284)
379f487 - bigquery: transpile EDIT_DISTANCE, closes #4283 (commit by @georgesittas)c3c1997 - bigquery: Add support for STRING function (PR #4284 by @VaggelisD)1a26bff - snowflake: Transpile exp.SafeDivide (PR #4294 by @VaggelisD)ac66d2f - clickhouse: properly parse CREATE FUNCTION DDLs (PR #4282 by @georgesittas)
1691388 - optimizer: Fix chained exp.SetOperation type annotation (PR #4274 by @VaggelisD)
559e7bc - clickhouse: Wrap subquery if it's LHS of IS NOT NULL (PR #4287 by @VaggelisD)
47bc09a - sqlite: Fix UNIQUE parsing (PR #4293 by @VaggelisD)
ee266ef - improve support for identifier delimiter escaping (PR #4288 by @georgesittas)c6ff7f1 - bump sqlglotrs to v0.2.13 (commit by @georgesittas)due to `4d86499` - include the target node for Move edits *(PR #4277 by @georgesittas)*:
due to 4d86499 - include the target node for Move edits (PR #4277 by @georgesittas):
include the target node for Move edits (#4277)
due to 9771965 - Add support for TIMESTAMP_NTZ_FROM_PARTS (PR #4280 by @VaggelisD):
Add support for TIMESTAMP_NTZ_FROM_PARTS (#4280)
due to 768adb3 - time string literals containing fractional seconds (PR #4269 by @treysp):
time string literals containing fractional seconds (#4269)
9771965 - snowflake: Add support for TIMESTAMP_NTZ_FROM_PARTS (PR #4280 by @VaggelisD)9e11654 - clickhouse: add geometry types (PR #4278 by @jwhitaker-gridcog)c25a9ab - tsql: Keep CTE's attached to the query when emulating IF NOT EXISTS (PR #4279 by @erindru)768adb3 - clickhouse: time string literals containing fractional seconds (PR #4269 by @treysp)4d86499 - diff: include the target node for Move edits (PR #4277 by @georgesittas)due to `142c3e7` - Support TO_DOUBLE function *(PR #4255 by @VaggelisD)*:
due to 142c3e7 - Support TO_DOUBLE function (PR #4255 by @VaggelisD):
Support TO_DOUBLE function (#4255)
due to 13d0696 - Support TRY_TO_TIMESTAMP function (PR #4257 by @VaggelisD):
Support TRY_TO_TIMESTAMP function (#4257)
due to 7fc0055 - dont parse right-hand side operands of ARRAY JOIN as Tables (PR #4258 by @georgesittas):
dont parse right-hand side operands of ARRAY JOIN as Tables (#4258)
due to 222152e - Add type hints for optimizer rules eliminate & merge subqueries (PR #4267 by @VaggelisD):
Add type hints for optimizer rules eliminate & merge subqueries (#4267)
6f32e53 - support non-strict qualify_columns (PR #4243 by @hsheth2)ed97954 - duckdb: Transpile Spark's LATERAL VIEW EXPLODE (PR #4252 by @VaggelisD)
8f5efc7 - oracle: parse hints (PR #4249 by @mkmoisen)8b7ff5e - starrocks: support for ALTER TABLE SWAP WITH (PR #4256 by @mrhamburg)1c43348 - trino: Support for LISTAGG function (PR #4253 by @VaggelisD)
142c3e7 - snowflake: Support TO_DOUBLE function (PR #4255 by @VaggelisD)13d0696 - snowflake: Support TRY_TO_TIMESTAMP function (PR #4257 by @VaggelisD)04dccf3 - tsql: Support for stored procedure options (PR #4260 by @rsanchez-xtillion)36f6841 - bigquery: support EDIT_DISTANCE (Levinshtein) function (PR #4276 by @esciara)
fcc05c9 - bigquery: Early expand only aliased names in GROUP BY (PR #4246 by @VaggelisD)5655cfb - add support for negative intervals in to_interval (commit by @georgesittas)51f4d26 - generate single argument ArrayConcat without trailing comma fixes #4259 (commit by @georgesittas)7fc0055 - clickhouse: dont parse right-hand side operands of ARRAY JOIN as Tables (PR #4258 by @georgesittas)
8f49ad8 - clickhouse: traverse_scope with FINAL modifier (PR #4263 by @pkit)
83167ea - hive dialect hierarchy has no CURRENT_TIME func (PR #4264 by @georgesittas)7a5c7e0 - presto: transpile BIT to BOOLEAN (commit by @georgesittas)48be3d8 - make the semantic diffing aware of changes to non-expression leaves (PR #4268 by @georgesittas)4543fb3 - optimizer: Fix merge_subqueries.py::rename_inner_sources() (PR #4266 by @VaggelisD)
222152e - optimizer: Add type hints for optimizer rules eliminate & merge subqueries (PR #4267 by @VaggelisD)94013a2 - simplify _expression_only_args helper in diff module (PR #4251 by @georgesittas)41e2eba - Oracle: simplify hint arg formatting (commit by @georgesittas)cfd692f - move SwapTable logic to the base Parser/Generator classes (commit by @georgesittas)`e6567ae` - small overload fix for ensure list taking None *(PR #4248 by @benfdking)*
e6567ae - small overload fix for ensure list taking None (PR #4248 by @benfdking)due to `275b64b` - refactor set operation builders so they can work with N expressions *(PR #4226 by @georgesittas)*:
due to 275b64b - refactor set operation builders so they can work with N expressions (PR #4226 by @georgesittas):
refactor set operation builders so they can work with N expressions (#4226)
due to aee76da - Native annotations for string functions (PR #4231 by @VaggelisD):
Native annotations for string functions (#4231)
due to 202aaa0 - Native annotations for string functions (PR #4234 by @VaggelisD):
Native annotations for string functions (#4234)
due to 5741180 - produce exp.Column for the RHS of <value> IN <name> (PR #4239 by @georgesittas):
produce exp.Column for the RHS of <value> IN <name> (#4239)
due to 4da2502 - make Explode a UDTF subclass (PR #4242 by @georgesittas):
make Explode a UDTF subclass (#4242)
163e943 - tsql: SPLIT_PART function and conversion to PARSENAME in tsql (PR #4211 by @daihuynh)275b64b - refactor set operation builders so they can work with N expressions (PR #4226 by @georgesittas)3f6ba3e - clickhouse: Support varlen arrays for ARRAY JOIN (PR #4229 by @VaggelisD)
aee76da - bigquery: Native annotations for string functions (PR #4231 by @VaggelisD)202aaa0 - bigquery: Native annotations for string functions (PR #4234 by @VaggelisD)eeae25e - support EXPLAIN in mysql (PR #4235 by @xiaoyu-meng-mxy)06748d9 - mysql: add support for operation modifiers like HIGH_PRIORITY (PR #4238 by @georgesittas)
dcdec95 - Make exp.Update a DML node (PR #4223 by @VaggelisD)
79caf51 - clickhouse: rename BOOLEAN type to Bool fixes #4230 (commit by @georgesittas)b26a3f6 - satisfy mypy (commit by @georgesittas)5741180 - parser: produce exp.Column for the RHS of <value> IN <name> (PR #4239 by @georgesittas)
daa6e78 - optimizer: handle subquery predicate substitution correctly in de morgan's rule (PR #4240 by @georgesittas)c0a8355 - parser: parse a column reference for the RHS of the IN clause (PR #4241 by @georgesittas)0882f03 - Rename exp.RenameTable to exp.AlterRename (PR #4224 by @VaggelisD)
fd42b5c - Simplify PARSENAME <-> SPLIT_PART transpilation (PR #4225 by @VaggelisD)4da2502 - make Explode a UDTF subclass (PR #4242 by @georgesittas)`22a1684` - bigquery: Native annotations for more math functions *(PR #4212 by @VaggelisD)*
22a1684 - bigquery: Native annotations for more math functions (PR #4212 by @VaggelisD)354cfff - add builder methods to exp.Update and add with_ arg to exp.update (PR #4217 by @brdbry)2c513b7 - Attach CTE comments before commas (PR #4218 by @VaggelisD)
`484df7d` - tsql union with limit *(commit by @tobymao)*
`25b18d2` - trino: Support JSON_QUERY *(PR #4206 by @VaggelisD)*
25b18d2 - trino: Support JSON_QUERY (PR #4206 by @VaggelisD)
5781b45 - duckdb: Add more Postgres operators (PR #4199 by @VaggelisD)
89c0703 - bigquery: Native math function annotations (PR #4201 by @VaggelisD)977d9e5 - allow supplying dialect in diff, conditionally copy ASTs (PR #4208 by @georgesittas)
`c8b7c1e` - optimizer: Fixture file for function annotations *(PR #4182 by @VaggelisD)*
c8b7c1e - optimizer: Fixture file for function annotations (PR #4182 by @VaggelisD)0adbbf7 - duckdb: Parse ** and ^ operators as POW (PR #4193 by @VaggelisD)
4949906 - duckdb: Parse ~~~ as GLOB (PR #4194 by @VaggelisD)
6ba2bb0 - oracle: Add support for BULK COLLECT INTO (PR #4181 by @mkmoisen)0de59ce - mark expressions as unsupported in Into generator (commit by @georgesittas)475f7a3 - redshift: Add unsupported warnings for UNNEST (PR #4173 by @VaggelisD)
d38e023 - spark: Offset TRY_ELEMENT_AT by one (PR #4183 by @VaggelisD)3d1c643 - rename SHA function to SHA1 for DuckDB (PR #4191 by @rustyconover)0388a51 - add support for UHUGEINT for duckdb (PR #4190 by @rustyconover)
9eba00d - duckdb: Parse ~~ as LIKE (PR #4195 by @VaggelisD)
6a65973 - expand UPDATABLE_EXPRESSION_TYPES to account for Identifier changes (PR #4197 by @georgesittas)
a6c28c6 - sqlite: generate StrPosition as INSTR (PR #4198 by @pruzko)
5a123a5 - oracle: retreat properly when parsing BULK COLLECT INTO (commit by @georgesittas)f935e42 - properly escape closing identifier delimiters (PR #4202 by @georgesittas)`7af33a2` - spark: Custom annotation for more string functions *(PR #4156 by @VaggelisD)*
7af33a2 - spark: Custom annotation for more string functions (PR #4156 by @VaggelisD)due to `3ab6dfb` - Generalize COLUMNS(...) APPLY *(PR #4161 by @VaggelisD)*:
due to 3ab6dfb - Generalize COLUMNS(...) APPLY (PR #4161 by @VaggelisD):
Generalize COLUMNS(...) APPLY (#4161)
93cef30 - postgres: Support OVERLAY function (PR #4165 by @VaggelisD)
0a5444d - expose a flag to automatically exclude Keep diff nodes (PR #4168 by @georgesittas)9c17264 - hive: Enclose exp.Split with \E (PR #4163 by @VaggelisD)
3ab6dfb - clickhouse: Generalize COLUMNS(...) APPLY (PR #4161 by @VaggelisD)
2540e50 - simplify check_deploy job (commit by @georgesittas)f6d3bdd - update supported dialect count (21 -> 23) (commit by @georgesittas)`eca05d3` - tweak should_deploy_rs script to avoid marking CI as failed *(commit by @georgesittas)*
eca05d3 - tweak should_deploy_rs script to avoid marking CI as failed (commit by @georgesittas)`349b8f8` - fetch all history to allow workflow script to skip sqlglotrs deployments *(PR #4162 by @georgesittas)*
349b8f8 - fetch all history to allow workflow script to skip sqlglotrs deployments (PR #4162 by @georgesittas)due to `da51ea5` - refactor exp.Chr *(PR #4081 by @georgesittas)*:
due to da51ea5 - refactor exp.Chr (PR #4081 by @georgesittas):
refactor exp.Chr (#4081)
due to 9c527b5 - treat Nullable as an arg instead of a DataType.TYPE (PR #4094 by @georgesittas):
treat Nullable as an arg instead of a DataType.TYPE (#4094)
due to ba015dc - add returning to merge expression builder (PR #4125 by @max-muoto):
add returning to merge expression builder (#4125)
due to 77a514d - Parse VALUES & query modifiers in wrapped FROM clause (PR #4135 by @VaggelisD):
Parse VALUES & query modifiers in wrapped FROM clause (#4135)
5771d8d - add merge expression builder (PR #4084 by @max-muoto)1d52709 - postgres: Parse DO NOTHING and RETURNING in MERGE statement (PR #4087 by @VaggelisD)
1615bad - Add support for UUID function (PR #4089 by @VaggelisD)5733600 - bigquery: transpile UUID type to STRING (PR #4093 by @georgesittas)
75230f5 - bigquery: add support for the MERGE ... THEN INSERT ROW syntax (PR #4096 by @georgesittas)
f8d4dc4 - parser: add support for ALTER INDEX closes #4105 (commit by @georgesittas)28c6f27 - duckdb: Support *COLUMNS() function (PR #4106 by @VaggelisD)
3cb0041 - snowflake: Fix exp.Pivot FOR IN clause (PR #4109 by @VaggelisD)
7ac21a0 - athena: Improve DDL query support (PR #4099 by @erindru)a34f8b6 - oracle: support TRUNC without fmt argument fixes #4116 (commit by @georgesittas)bd8e050 - clickhouse: support ON CLUSTER clause in DELETE (PR #4119 by @treysp)1fac6a9 - expose sqlglot.expressions.delete as a sqlglot module function (PR #4126 by @max-muoto)4506b3b - duckdb: add support for the UNION type (PR #4128 by @georgesittas)ba015dc - add returning to merge expression builder (PR #4125 by @max-muoto)3ec96ab - clickhouse: Add support for APPLY query modifier (PR #4141 by @VaggelisD)
04ddc54 - bigquery: Support RANGE<T> type (PR #4148 by @VaggelisD)
17533ee - Add support for GRANT DDL (PR #4138 by @VaggelisD)1a240ec - Add SUBSTR Support (PR #4153 by @mwc360)da51ea5 - parser: refactor exp.Chr (PR #4081 by @georgesittas)
6294f9e - starrocks: generate ARRAY_FILTER for exp.ArrayFilter (PR #4088 by @gauravsagar483)1e02c02 - mysql: convert VARCHAR without size to TEXT for DDLs (PR #4092 by @georgesittas)cb5bcff - clickhouse: generate formatDateTime instead of DATE_FORMAT fixes #4098 (commit by @georgesittas)b10255e - snowflake: Manually escape single quotes in colon operator (PR #4104 by @VaggelisD)
67a9ad8 - Move JSON path escape to generation (PR #4110 by @VaggelisD)
06c76f7 - calling interval without unit (commit by @tobymao)66c3295 - optimizer: Enable USING expansion with multiple joins (PR #4113 by @dg-hellotwin)
21f5bcd - parse struct(...)[] type properly (PR #4123 by @georgesittas)22c456d - Do not generate DISTINCT keyword in FILTER (PR #4130 by @VaggelisD)
089b77e - athena: DDL fixes (PR #4132 by @erindru)e6c9902 - invalid regex (commit by @tobymao)77a514d - parser: Parse VALUES & query modifiers in wrapped FROM clause (PR #4135 by @VaggelisD)
8822d6c - parser: handle brackets in column op json extract arrow parser (PR #4140 by @georgesittas)
be0a4a8 - bigquery: Consume dashed identifiers only if they're connected (PR #4144 by @VaggelisD)0444819 - optimizer: don't reorder subquery predicates in simplify (PR #4147 by @georgesittas)89519bb - clickhouse: make ToTableProperty appear right after the DDL name (PR #4151 by @georgesittas)
9c527b5 - treat Nullable as an arg instead of a DataType.TYPE (PR #4094 by @georgesittas)2961049 - implement decorator to easily mark args as unsupported (PR #4111 by @georgesittas)7cf1d70 - optimizer: Optimize USING expansion (PR #4115 by @VaggelisD)75e6406 - prql: rewrite tests to use validate_all() (PR #4097 by @JJHCool)e1f6ae3 - prql: use validate_all instead of validate_identity (commit by @georgesittas)2dc0b86 - optimizer: rename helper function in expand_using (PR #4117 by @georgesittas)fd8b8ba - create ARRAY_TYPES set under DataType (commit by @georgesittas)due to `ba015dc` - add returning to merge expression builder *(PR #4125 by @max-muoto)*:
due to ba015dc - add returning to merge expression builder (PR #4125 by @max-muoto):
add returning to merge expression builder (#4125)
1fac6a9 - expose sqlglot.expressions.delete as a sqlglot module function (PR #4126 by @max-muoto)4506b3b - duckdb: add support for the UNION type (PR #4128 by @georgesittas)ba015dc - add returning to merge expression builder (PR #4125 by @max-muoto)`bd8e050` - clickhouse: support ON CLUSTER clause in DELETE *(PR #4119 by @treysp)*
`a34f8b6` - oracle: support TRUNC without fmt argument fixes #4116 *(commit by @georgesittas)*
a34f8b6 - oracle: support TRUNC without fmt argument fixes #4116 (commit by @georgesittas)66c3295 - optimizer: Enable USING expansion with multiple joins (PR #4113 by @dg-hellotwin)
7cf1d70 - optimizer: Optimize USING expansion (PR #4115 by @VaggelisD)2dc0b86 - optimizer: rename helper function in expand_using (PR #4117 by @georgesittas)fd8b8ba - create ARRAY_TYPES set under DataType (commit by @georgesittas)`06c76f7` - calling interval without unit *(commit by @tobymao)*
due to `da51ea5` - refactor exp.Chr *(PR #4081 by @georgesittas)*:
due to da51ea5 - refactor exp.Chr (PR #4081 by @georgesittas):
refactor exp.Chr (#4081)
due to 9c527b5 - treat Nullable as an arg instead of a DataType.TYPE (PR #4094 by @georgesittas):
treat Nullable as an arg instead of a DataType.TYPE (#4094)
5771d8d - add merge expression builder (PR #4084 by @max-muoto)1d52709 - postgres: Parse DO NOTHING and RETURNING in MERGE statement (PR #4087 by @VaggelisD)
1615bad - Add support for UUID function (PR #4089 by @VaggelisD)5733600 - bigquery: transpile UUID type to STRING (PR #4093 by @georgesittas)
75230f5 - bigquery: add support for the MERGE ... THEN INSERT ROW syntax (PR #4096 by @georgesittas)
f8d4dc4 - parser: add support for ALTER INDEX closes #4105 (commit by @georgesittas)28c6f27 - duckdb: Support *COLUMNS() function (PR #4106 by @VaggelisD)
3cb0041 - snowflake: Fix exp.Pivot FOR IN clause (PR #4109 by @VaggelisD)
7ac21a0 - athena: Improve DDL query support (PR #4099 by @erindru)da51ea5 - parser: refactor exp.Chr (PR #4081 by @georgesittas)
6294f9e - starrocks: generate ARRAY_FILTER for exp.ArrayFilter (PR #4088 by @gauravsagar483)1e02c02 - mysql: convert VARCHAR without size to TEXT for DDLs (PR #4092 by @georgesittas)cb5bcff - clickhouse: generate formatDateTime instead of DATE_FORMAT fixes #4098 (commit by @georgesittas)b10255e - snowflake: Manually escape single quotes in colon operator (PR #4104 by @VaggelisD)
67a9ad8 - Move JSON path escape to generation (PR #4110 by @VaggelisD)
9c527b5 - treat Nullable as an arg instead of a DataType.TYPE (PR #4094 by @georgesittas)2961049 - implement decorator to easily mark args as unsupported (PR #4111 by @georgesittas)75e6406 - prql: rewrite tests to use validate_all() (PR #4097 by @JJHCool)e1f6ae3 - prql: use validate_all instead of validate_identity (commit by @georgesittas)Nothing published for this version
`8a357cc` - bump sqlglotrs to 0.2.12 -- remove relative readme path *(commit by @georgesittas)*
8a357cc - bump sqlglotrs to 0.2.12 -- remove relative readme path (commit by @georgesittas)due to `3e1af21` - Canonicalize exp.RegexpExtract group default value *(PR #4051 by @VaggelisD)*:
due to 3e1af21 - Canonicalize exp.RegexpExtract group default value (PR #4051 by @VaggelisD):
Canonicalize exp.RegexpExtract group default value (#4051)
due to c8e2eae - do not canonicalize INTERVAL values to number literals (commit by @VaggelisD):
do not canonicalize INTERVAL values to number literals
d3ee5ea - oracle: parse TRUNC to facilitate transpilation closes #4054 (commit by @georgesittas)143f176 - clickhouse: transpile oracle functions chr, lag, lead (PR #4053 by @sleshJdev)d89757e - postgres: add support for the NOT VALID clause in ALTER TABLE fixes #4077 (commit by @georgesittas)3e1af21 - Canonicalize exp.RegexpExtract group default value (PR #4051 by @VaggelisD)
75cafad - starrocks: Move the parse distribute and duplicate to Parser (PR #4062 by @hellozepp)74352d5 - tsql: use plus operator for string concat to support more systems that use tsql (PR #4067 by @cpcloud)
c8e2eae - do not canonicalize INTERVAL values to number literals (commit by @VaggelisD)532a024 - snowflake, bigquery: Remove exp.Trim generation (PR #4070 by @VaggelisD)
ad7e582 - athena: Apply correct quoting to queries depending on type (DML or DDL) (PR #4073 by @erindru)cc5b877 - parser: Wrap column constraints in _parse_column_def() (PR #4078 by @VaggelisD)
4eb384a - clickhouse: Remove CURRENT_TIMESTAMP from NO_PAREN_FUNCTIONS (PR #4079 by @VaggelisD)
534f882 - clickhouse: clean up chr, lag, lead generation (commit by @georgesittas)b986ebe - fill in more details for sqlglotrs pypi page (PR #4071 by @georgesittas)0310926 - bump sqlglotrs to 0.2.11 (update pypi details) (commit by @georgesittas)due to `6da9328` - refactor SET OPERATION handling to set correct defaults *(PR #4009 by @georgesittas)*:
due to 6da9328 - refactor SET OPERATION handling to set correct defaults (PR #4009 by @georgesittas):
refactor SET OPERATION handling to set correct defaults (#4009)
due to 4b69d18 - use TO_GEOGRAPHY, TO_GEOMETRY instead of casts (PR #4017 by @georgesittas):
use TO_GEOGRAPHY, TO_GEOMETRY instead of casts (#4017)
due to 0985907 - Add UnsupportedError to unnest_to_explode transform (PR #4016 by @VaggelisD):
Add UnsupportedError to unnest_to_explode transform (#4016)
due to 7d63d23 - Support JSON_EXISTS, refactor ON handling (PR #4032 by @VaggelisD):
Support JSON_EXISTS, refactor ON handling (#4032)
f550ba1 - presto: support [ SECURITY { DEFINER | INVOKER } ] (PR #4008 by @usmanovbf)dedd757 - oracle: Parse multitable inserts (PR #4000 by @usefulalgorithm)0985907 - Add UnsupportedError to unnest_to_explode transform (PR #4016 by @VaggelisD)8f5fccf - presto: generate non-iso DayOfWeek (commit by @georgesittas)7d63d23 - oracle: Support JSON_EXISTS, refactor ON handling (PR #4032 by @VaggelisD)
85cc7ad - duckdb: Transpile BQ's exp.ArrayToString (PR #4034 by @VaggelisD)7f2c7f1 - Support for NORMALIZE() function (PR #4041 by @VaggelisD)
a1b9803 - support COMPRESS column constraint wihout a value (PR #4045 by @thomascjohnson)8583772 - tsql: Use count_big instead of count (PR #3996 by @colin-ho)
4b7ca2b - spark: Custom annotation for SUBSTRING() (PR #4004 by @VaggelisD)
cb172db - clickhouse: ensure that ALL and DISTINCT are rendered for except and intersect (PR #4007 by @cpcloud)
829fdcb - starrocks: exp.Unnest transpilation (PR #3999 by @hellozepp)
6da9328 - refactor SET OPERATION handling to set correct defaults (PR #4009 by @georgesittas)23a928e - mysql: Preserve roundtrip of %a, %W time formats (PR #4014 by @VaggelisD)
2d4483c - don't log warning in to_json_path conditionally (PR #4015 by @georgesittas)
4b69d18 - snowflake: use TO_GEOGRAPHY, TO_GEOMETRY instead of casts (PR #4017 by @georgesittas)1108426 - optimizer: annotate unary expressions correctly (PR #4019 by @georgesittas)5fad18c - presto: exp.DayOfWeek (PR #4024 by @hellozepp)ea9a494 - parser: consume STREAM in _parse_select only if it's a VAR, closes #4029 (commit by @georgesittas)c239a74 - transpile null exclusion for ARRAY_AGG (PR #4033 by @georgesittas)
60a8f16 - parser: don't consume strings in match_text_seq (commit by @georgesittas)a726583 - parser: don't consume strings in match_texts (commit by @georgesittas)551d32f - postgres: Support for DROP INDEX CONCURRENTLY. (PR #4040 by @EdgyEdgemond)
f55647d - starrocks: exp.Create transpilation (PR #4023 by @hellozepp)
bf0f5fa - parser: Ensure exp.Coalesce expressions is a list (PR #4050 by @VaggelisD)
6494776 - simplify multi-insert generation, fix pretty mode (commit by @georgesittas)b11c73e - clean up starrocks DISTRIBUTED BY property generation (commit by @georgesittas)c35a62c - set the license for sqlglotrs (PR #4048 by @georgesittas)
9b7eb2e - bump sqlglotrs to v0.2.10 (commit by @georgesittas)due to `22bb9a0` - stop normalizing qualified anonymous functions *(PR #3969 by @georgesittas)*:
due to 22bb9a0 - stop normalizing qualified anonymous functions (PR #3969 by @georgesittas):
stop normalizing qualified anonymous functions (#3969)
due to 8aec682 - mysql/tsql datetime precision, formatting, exp.AtTimeZone (PR #3951 by @erindru):
mysql/tsql datetime precision, formatting, exp.AtTimeZone (#3951)
due to 2f3626a - Generation of exp.SHA2, exp.Transform, exp.IgnoreNulls (PR #3980 by @VaggelisD):
Generation of exp.SHA2, exp.Transform, exp.IgnoreNulls (#3980)
due to 905b722 - preserve each distinct CUBE/ROLLUP/GROUPING SET clause (PR #3985 by @georgesittas):
preserve each distinct CUBE/ROLLUP/GROUPING SET clause (#3985)
48b214d - postgres: Support for IS JSON predicate (PR #3971 by @VaggelisD)
f7e4e4a - duckdb: add support for the GLOB table function closes #3973 (commit by @georgesittas)a0d1377 - spark: add support for table statement in INSERT (PR #3986 by @georgesittas)
f5bfd67 - mysql: Parse JSON_VALUE() (PR #3987 by @VaggelisD)
79e92ad - spark: Default naming of STRUCT fields (PR #3991 by @VaggelisD)
22bb9a0 - stop normalizing qualified anonymous functions (PR #3969 by @georgesittas)
8aec682 - mysql/tsql datetime precision, formatting, exp.AtTimeZone (PR #3951 by @erindru)d37a5bb - snowflake: handle DIV0 case where divident is null (PR #3975 by @georgesittas)
b2f877b - oracle: Use LTRIM/RTRIM unless BOTH is specified (PR #3977 by @VaggelisD)201b51a - sqlite: Make IS parser more lenient (PR #3981 by @VaggelisD)
2f3626a - duckdb: Generation of exp.SHA2, exp.Transform, exp.IgnoreNulls (PR #3980 by @VaggelisD)
905b722 - parser: preserve each distinct CUBE/ROLLUP/GROUPING SET clause (PR #3985 by @georgesittas)
ee9dc39 - Fix binding of TABLESAMPLE to exp.Subquery instead of top-level exp.Select (PR #3994 by @VaggelisD)
due to `0a9ba05` - 0 is falsey *(commit by @tobymao)*:
42b725e - flaky test closes #3961 (commit by @tobymao)cc29921 - Parse LTRIM/RTRIM functions as positional exp.Trim (PR #3958 by @VaggelisD)
678e692 - make sample an arg of table, not a wrapper (PR #3963 by @barakalon)0a9ba05 - 0 is falsey (commit by @tobymao)c1ac987 - starrocks: exp.Array generation, exp.Unnest alias (PR #3964 by @VaggelisD)
`c4e5be7` - include dialect when parsing inside cast *(PR #3960 by @eakmanrq)*
794dc4c - update readme to include onboarding doc (commit by @georgesittas)due to `f68d155` - exp.Merge, for Trino and Postgres, dont strip the target alias from then WHEN MATCHED condition to prevent an ambiguous column erro
due to f68d155 - exp.Merge, for Trino and Postgres, dont strip the target alias from then WHEN MATCHED condition to prevent an ambiguous column error (PR #3940 by @erindru):
exp.Merge, for Trino and Postgres, dont strip the target alias from then WHEN MATCHED condition to prevent an ambiguous column error (#3940)
due to 667f7d9 - attach INTERPOLATE expressions to WithFill (PR #3944 by @georgesittas):
attach INTERPOLATE expressions to WithFill (#3944)
due to 145fdbf - Redshift date format (PR #3942 by @erindru):
Redshift date format (#3942)
due to a84a21a - Add timezone support to exp.TimeStrToTime (PR #3938 by @erindru):
Add timezone support to exp.TimeStrToTime (#3938)
a84a21a - Add timezone support to exp.TimeStrToTime (PR #3938 by @erindru)70a052a - transpile from_iso8601_timestamp from presto/trino to duckdb (PR #3956 by @georgesittas)f68d155 - exp.Merge, for Trino and Postgres, dont strip the target alias from then WHEN MATCHED condition to prevent an ambiguous column error (PR #3940 by @erindru)0458dc0 - optimizer: expand alias refs recursive CTE edge case patch (PR #3943 by @georgesittas)145fdbf - Redshift date format (PR #3942 by @erindru)6233c2c - parser: Support sqls with DESCRIBE partition (PR #3945 by @gp1105739)
85cd6e5 - bigquery: Map %e to %-d (PR #3946 by @VaggelisD)1ba0f03 - duckdb: TIME does not support modifiers (PR #3947 by @georgesittas)d5d3615 - optimizer: convert TsOrDsToDate to Cast more conservatively (PR #3949 by @barakalon)fb6edc7 - oracle/snowflake comments closes #3950 (commit by @tobymao)1284fd0 - oracle: Revert NVL() being parsed into exp.Anonymous (PR #3954 by @VaggelisD)
c99f8d5 - duckdb: Fix exp.Unnest generation for BQ's nested arrays (PR #3931 by @VaggelisD)f16b0e7 - iteratively generate binary expressions (PR #3926 by @MatMoore)667f7d9 - clickhouse: attach INTERPOLATE expressions to WithFill (PR #3944 by @georgesittas)c697357 - slightly refactor Generator.binary, add stress test (commit by @georgesittas)6a5f619 - New doc - Onboarding Doc (PR #3902 by @VaggelisD)due to `a668655` - preserve SYSDATE *(PR #3935 by @georgesittas)*:
due to a668655 - preserve SYSDATE (PR #3935 by @georgesittas):
preserve SYSDATE (#3935)
be11f4c - clickhouse: add support for "@"-style parameters (PR #3939 by @georgesittas)a668655 - oracle: preserve SYSDATE (PR #3935 by @georgesittas)
b824f8a - parser: allow complex expressions for UNPIVOT alias (PR #3937 by @georgesittas)
f4c34d3 - move "MINUS": TokenType.EXCEPT to hive instead of spark (commit by @georgesittas)due to `605f1b2` - use creatable kind mapping dict for schema<-->database substitution *(PR #3924 by @treysp)*:
due to 605f1b2 - use creatable kind mapping dict for schema<-->database substitution (PR #3924 by @treysp):
use creatable kind mapping dict for schema<-->database substitution (#3924)
due to f418caa - skip nullable comparison in is_type by default (PR #3927 by @georgesittas):
skip nullable comparison in is_type by default (#3927)
f418caa - skip nullable comparison in is_type by default (PR #3927 by @georgesittas)due to `102f5d4` - infer set op types more accurately *(PR #3918 by @georgesittas)*:
due to 102f5d4 - infer set op types more accurately (PR #3918 by @georgesittas):
infer set op types more accurately (#3918)
due to 46496a6 - improve transpilation of nullable/non-nullable data types (PR #3921 by @georgesittas):
improve transpilation of nullable/non-nullable data types (#3921)
c74a8fd - clickhouse: make try_cast toXXXOrNull() functions case-specific (PR #3917 by @treysp)102f5d4 - optimizer: infer set op types more accurately (PR #3918 by @georgesittas)
1d436d4 - clickhouse: transpile TRY_CAST(x AS T) to CAST(x AS Nullable(T)) (PR #3919 by @georgesittas)46496a6 - clickhouse: improve transpilation of nullable/non-nullable data types (PR #3921 by @georgesittas)due to `e8e70f3` - treat DATABASE kind as SCHEMA (and conversely) in exp.Create *(PR #3912 by @georgesittas)*:
due to e8e70f3 - treat DATABASE kind as SCHEMA (and conversely) in exp.Create (PR #3912 by @georgesittas):
treat DATABASE kind as SCHEMA (and conversely) in exp.Create (#3912)
9a66903 - clickhouse: add support for TryCast generation (PR #3913 by @georgesittas)7965cac - clickhouse: wrap query in CTAS when COMMENT prop is present (PR #3911 by @georgesittas)e8e70f3 - clickhouse: treat DATABASE kind as SCHEMA (and conversely) in exp.Create (PR #3912 by @georgesittas)`57f7aa9` - clickhouse: COMMENT property in CTAS needs to come last *(PR #3910 by @georgesittas)*
57f7aa9 - clickhouse: COMMENT property in CTAS needs to come last (PR #3910 by @georgesittas)`c22f411` - clickhouse: ensure we generate the Table in creatable_sql if it represents a db ref *(commit by @georgesittas)*
c22f411 - clickhouse: ensure we generate the Table in creatable_sql if it represents a db ref (commit by @georgesittas)19eee93 - various fixups for unnest(generatedatearray) transpilation (PR #3906 by @georgesittas)`790c1b1` - clickhouse: support PARTITION BY, SETTINGS in Insert expression *(PR #3904 by @georgesittas)*
790c1b1 - clickhouse: support PARTITION BY, SETTINGS in Insert expression (PR #3904 by @georgesittas)due to `0428c37` - Support ALTER VIEW AS SELECT *(PR #3873 by @xiaohui-sun)*:
due to 0428c37 - Support ALTER VIEW AS SELECT (PR #3873 by @xiaohui-sun):
Support ALTER VIEW AS SELECT (#3873)
due to a666117 - parse v NOT IN (subquery) as v <> ALL (subquery) (PR #3891 by @georgesittas):
parse v NOT IN (subquery) as v <> ALL (subquery) (#3891)
due to d968932 - treat identifiers as case-sensitive, handle EMPTY table property, generate DateStrToDate (PR #3895 by @jwhitaker-gridcog):
treat identifiers as case-sensitive, handle EMPTY table property, generate DateStrToDate (#3895)
due to 1d7319a - transpile Unnest(GenerateDateArray(...)) to various dialects (PR #3899 by @georgesittas):
transpile Unnest(GenerateDateArray(...)) to various dialects (#3899)
0428c37 - parser: Support ALTER VIEW AS SELECT (PR #3873 by @xiaohui-sun)8a48458 - athena: parse UNLOAD into exp.Command closes #3896 (commit by @georgesittas)6f1527f - bigquery: transpile format_datetime, datetime_trunc to duckdb (PR #3894 by @skadel)1d7319a - transpile Unnest(GenerateDateArray(...)) to various dialects (PR #3899 by @georgesittas)2cac14f - generate set ops in ALTER VIEW AS statement (commit by @georgesittas)a666117 - snowflake: parse v NOT IN (subquery) as v <> ALL (subquery) (PR #3891 by @georgesittas)
924a4af - oracle: preserve function-style MOD syntax fixes #3897 (commit by @georgesittas)d968932 - clickhouse: treat identifiers as case-sensitive, handle EMPTY table property, generate DateStrToDate (PR #3895 by @jwhitaker-gridcog)3e5e730 - clickhouse: generate exp.Values correctly, handle FORMAT Values (PR #3900 by @georgesittas)bea3c08 - parser: improve performance of OUTER/CROSS APPLY parsing (PR #3901 by @georgesittas)
due to `3eb46db` - switch off CSV file schema inference by default *(PR #3879 by @georgesittas)*:
due to 3eb46db - switch off CSV file schema inference by default (PR #3879 by @georgesittas):
switch off CSV file schema inference by default (#3879)
3e4fcf7 - databricks: Add support for STREAMING tables (PR #3878 by @VaggelisD)
528f690 - duckdb: Transpile Snowflake's CONVERT_TIMEZONE 3-arg version (PR #3883 by @VaggelisD)
411f62a - bigquery: Support for GENERATE_TIMESTAMP_ARRAY, DDB transpilation (PR #3888 by @VaggelisD)7169e6e - bigquery: ensure Funcs are preserved when used as Tables (PR #3877 by @georgesittas)62ceed2 - redshift: parse first arg in DATE_PART into a Var fixes #3882 (commit by @georgesittas)2ad9bfe - snowflake: support table qualification in USING clause (PR #3885 by @georgesittas)
ef16b1d - Fix COLLATE's RHS parsing (PR #3887 by @VaggelisD)
3eb46db - optimizer: switch off CSV file schema inference by default (PR #3879 by @georgesittas)due to `64e187c` - transpile postgres impliclitly exploding GENERATE_SERIES proje… *(PR #3853 by @georgesittas)*:
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)
6afed2a - duckdb: Support for exp.TimeDiff generation (PR #3856 by @VaggelisD)64e187c - transpile postgres impliclitly exploding GENERATE_SERIES proje… (PR #3853 by @georgesittas)
8a948c8 - teradata: Parse RENAME TABLE as Command (PR #3863 by @VaggelisD)
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)8710763 - presto: map %W to %A in the TIME_MAPPING (PR #3855 by @georgesittas)
532f3c8 - duckdb: Add implicit casts to DATE_DIFF (PR #3857 by @VaggelisD)299c4a5 - clickhouse: Fix SETTINGS parsing (PR #3859 by @VaggelisD)
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)
6ff0c01 - Fixed size array parsing (PR #3870 by @VaggelisD)
`a295b3a` - tsql: regression related to CTEs in CREATE VIEW AS statements *(PR #3852 by @georgesittas)*
a295b3a - tsql: regression related to CTEs in CREATE VIEW AS statements (PR #3852 by @georgesittas)`e37d63a` - bigquery: add support for BYTEINT closes #3838 *(commit by @georgesittas)*
e37d63a - bigquery: add support for BYTEINT closes #3838 (commit by @georgesittas)4c912cd - clickhouse: improve parsing/transpilation of StrToDate (PR #3839 by @georgesittas)
45f45ea - duckdb: add support for SUMMARIZE (PR #3840 by @georgesittas)
57ecc84 - duckdb: wrap left IN clause json extract arrow operand fixes #3836 (commit by @georgesittas)2ffb070 - duckdb: allow fixed length array casts closes #3841 (PR #3842 by @tobymao)d71eb4e - pretty gen for tuples (commit by @tobymao)12ae9cd - tsql: handle JSON_QUERY with a single argument (PR #3847 by @georgesittas)
f8ca6b4 - tsql: bubble up exp.Create CTEs to improve transpilability (PR #3848 by @georgesittas)
89976c1 - parser: allow 'cube' to be used for identifiers (PR #3850 by @georgesittas)d00ea9c - exclude boolean args in Generator.format_args (PR #3849 by @georgesittas)One column per quarter.