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.
`ba0aa50` - duckdb: Transpile BQ's exp.DatetimeAdd, exp.DatetimeSub *(PR #3777 by @VaggelisD)*
ba0aa50 - duckdb: Transpile BQ's exp.DatetimeAdd, exp.DatetimeSub (PR #3777 by @VaggelisD)5da91fb - postgres: Support for CREATE INDEX CONCURRENTLY (PR #3787 by @VaggelisD)
00722eb - Move ANNOTATORS to Dialect for dialect-aware annotation (PR #3786 by @VaggelisD)
a6d84fb - postgres: Parse TO_DATE as exp.StrToDate (PR #3799 by @VaggelisD)
3582644 - hive, spark, db: Support for exp.GenerateSeries (PR #3798 by @VaggelisD)
80b4a12 - tsql: Support for COLUMNSTORE option on CREATE INDEX (PR #3805 by @VaggelisD)
bf6c126 - databricks: Support USE CATALOG (PR #3812 by @VaggelisD)
624d411 - snowflake: Support for OBJECT_INSERT, transpile to DDB (PR #3807 by @VaggelisD)
5b393fb - postgres: Add missing constraint options (PR #3816 by @VaggelisD)
898f523 - duckdb: Wrap JSON_EXTRACT if it's subscripted (PR #3785 by @VaggelisD)
db3748d - mysql: don't wrap VALUES clause (PR #3792 by @georgesittas)
44d6506 - with as comments closes #3794 (commit by @tobymao)8ca6a61 - tsql: Fix roundtrip of exp.Stddev (PR #3806 by @VaggelisD)
8551063 - duckdb: Fix STRUCT_PACK -> ROW due to is_struct_cast (PR #3809 by @VaggelisD)
98f80ed - clickhouse: allow like as an identifier closes #3813 (commit by @tobymao)556ba35 - allow parse_identifier to handle single quotes (commit by @tobymao)f9810d2 - snowflake: Don't consume LPAREN when parsing staged file path (PR #3815 by @VaggelisD)416f4a1 - postgres: Fix COLLATE column constraint (PR #3820 by @VaggelisD)
69b9395 - Do not preemptively consume SELECT [ALL] if ALL is connected (PR #3822 by @VaggelisD)
1c19abe - presto, trino: Fix StrToUnix transpilation (PR #3824 by @VaggelisD)
Your coding agent can read these notes before it upgrades. Set up the MCP server →
`19370d5` - postgres: Decouple UNIQUE from DEFAULT constraints *(PR #3775 by @VaggelisD)*
19370d5 - postgres: Decouple UNIQUE from DEFAULT constraints (PR #3775 by @VaggelisD)
e99146b - make copy a dml statement for qualify_tables (commit by @tobymao)due to `89fc63c` - QUALIFY comes after WINDOW clause in queries *(PR #3745 by @georgesittas)*:
due to 89fc63c - QUALIFY comes after WINDOW clause in queries (PR #3745 by @georgesittas):
QUALIFY comes after WINDOW clause in queries (#3745)
due to a2a6efb - Canonicalize struct & array inline constructor (PR #3751 by @VaggelisD):
Canonicalize struct & array inline constructor (#3751)
e9c4bbb - Support for ORDER BY ALL (PR #3756 by @VaggelisD)
4a843e6 - postgres: Support FROM ROWS FROM (...) (PR #3753 by @VaggelisD)321051a - presto, trino: Add support for exp.TimestampAdd (PR #3765 by @VaggelisD)
82a1bb4 - Support for RPAD & LPAD functions (PR #3757 by @VaggelisD)89fc63c - duckdb, clickhouse: QUALIFY comes after WINDOW clause in queries (PR #3745 by @georgesittas)
15ca924 - optimizer: Fix expansion of SELECT * REPLACE, RENAME (PR #3742 by @VaggelisD)0363fef - attach comments to Commands (PR #3758 by @georgesittas)a2a6efb - bigquery: Canonicalize struct & array inline constructor (PR #3751 by @VaggelisD)5df3f52 - Remove number matching from COLON placeholder parser (PR #3761 by @VaggelisD)
0606af6 - duckdb: Transpile UDFs from Databricks (PR #3768 by @VaggelisD)
dcc783a - clickhouse: Allow TokenType.SELECT as a Tuple field identifier (PR #3766 by @VaggelisD)
b42b7ac - extract from time/date (commit by @tobymao)`2bdde22` - optimizer: only qualify coalesced USING columns if they exist in table schemas *(PR #3740 by @georgesittas)*
2bdde22 - optimizer: only qualify coalesced USING columns if they exist in table schemas (PR #3740 by @georgesittas)due to `8335ba1` - preserve EXTRACT(date_part FROM datetime) calls *(PR #3729 by @georgesittas)*:
due to 8335ba1 - preserve EXTRACT(date_part FROM datetime) calls (PR #3729 by @georgesittas):
preserve EXTRACT(date_part FROM datetime) calls (#3729)
due to fb066a6 - Decouple NVL() from COALESCE() (PR #3734 by @VaggelisD):
Decouple NVL() from COALESCE() (#3734)
0c03299 - teradata: random lower upper closes #3721 (commit by @tobymao)37b6e2d - snowflake: add support for VECTOR(type, size) (PR #3724 by @georgesittas)1e07c4d - presto, trino: Configurable transpilation of Snowflake VARIANT (PR #3725 by @VaggelisD)
e5a53aa - snowflake: Support for FROM CHANGES (PR #3731 by @VaggelisD)
820d664 - presto: wrap md5 string arguments in to_utf8 (PR #3732 by @georgesittas)
912bc84 - spark, databricks: Support view schema binding options (PR #3739 by @VaggelisD)
3454f86 - teradata: use timestamp with time zone over timestamptz (PR #3723 by @mtagle)
f4a2872 - clickhouse: switch off table alias columns generation (PR #3727 by @georgesittas)
8335ba1 - clickhouse: preserve EXTRACT(date_part FROM datetime) calls (PR #3729 by @georgesittas)
fb066a6 - oracle: Decouple NVL() from COALESCE() (PR #3734 by @VaggelisD)
c790c3b - tsql: parse rhs of x::varchar(max) into a type (PR #3737 by @georgesittas)84416d2 - teradata: clean up CurrentTimestamp generation logic (commit by @georgesittas)`6bf9853` - tsql: cast shorthand closes #3760 *(PR #3720 by @tobymao)*
due to `9fb1d79` - extract unit should be a var, not a column *(PR #3712 by @tobymao)*:
due to 9fb1d79 - extract unit should be a var, not a column (PR #3712 by @tobymao):
extract unit should be a var, not a column (#3712)
due to ae1816f - simplify no longer removes neg, add to_py (PR #3714 by @tobymao):
simplify no longer removes neg, add to_py (#3714)
due to beaf9cc - coalesce left-hand side of join conditions produced by expanding USING (PR #3715 by @georgesittas):
coalesce left-hand side of join conditions produced by expanding USING (#3715)
97739fe - add Select expression parser (commit by @georgesittas)1c2279c - duckdb: Transpile exp.Length from other dialects (PR #3708 by @VaggelisD)23dac71 - snowflake: add support for CONNECT_BY_ROOT expression (PR #3717 by @georgesittas)
4f050e0 - transpile BigQuery's SAFE_CAST with FORMAT to DuckDB (PR #3718 by @georgesittas)
3a86d7e - non deterministic aggs in planner closes #3709 (commit by @tobymao)3b8568d - clickhouse: extract closes #3711 (commit by @tobymao)9fb1d79 - extract unit should be a var, not a column (PR #3712 by @tobymao)ae1816f - simplify no longer removes neg, add to_py (PR #3714 by @tobymao)beaf9cc - optimizer: coalesce left-hand side of join conditions produced by expanding USING (PR #3715 by @georgesittas)`972ce7d` - control ParseJSON generation logic with a flag *(PR #3707 by @georgesittas)*
972ce7d - control ParseJSON generation logic with a flag (PR #3707 by @georgesittas)`a1327c7` - tsql: Add support for scope qualifier operator *(PR #3703 by @VaggelisD)*
a1327c7 - tsql: Add support for scope qualifier operator (PR #3703 by @VaggelisD)
842a9f0 - parser: preserve Cast expression when it's 'safe' and has a format (PR #3705 by @georgesittas)
fc0411d - parser: explicitly check for identifiers in _parse_types (PR #3704 by @georgesittas)
e9236e3 - add EXPAND_ALIAS_REFS_ONLY_IN_GROUP_BY dialect constant (PR #3702 by @georgesittas)92c6ebb - tsql: make ScopeResolution round-trippable (PR #3706 by @georgesittas)`4ed02b0` - transpile TRY_PARSE_JSON Snowflake -> DuckDB *(PR #3696 by @georgesittas)*
4ed02b0 - transpile TRY_PARSE_JSON Snowflake -> DuckDB (PR #3696 by @georgesittas)
60fa5e3 - snowflake: add support for dynamic table DDL (commit by @georgesittas)442c61d - tokenizer: don't treat escapes in raw strings as such for some dialects (PR #3689 by @georgesittas)
f3e928e - parser: make parse_var_or_string more lenient (PR #3695 by @georgesittas)
806a7e4 - remove tokenizer cache for multi-threading (commit by @tobymao)3fba603 - don't treat /*+ as a HINT token in dialects that don't support hints (PR #3697 by @georgesittas)
e5d534c - optimizer: Force early alias expansion in BQ & CH (PR #3699 by @VaggelisD)
1cfb1ff - proper parsing of unit in spark/databricks date_diff (PR #3701 by @georgesittas)
8b16199 - bump sqlglotrs to v0.2.8 (commit by @georgesittas)due to `84d820f` - Time/Datetime/Timestamp function additions *(PR #3666 by @VaggelisD)*:
due to 84d820f - Time/Datetime/Timestamp function additions (PR #3666 by @VaggelisD):
Time/Datetime/Timestamp function additions (#3666)
due to acbc81d - Preserve JSON/VARIANT path with operators (PR #3678 by @VaggelisD):
Preserve JSON/VARIANT path with operators (#3678)
84d820f - bigquery: Time/Datetime/Timestamp function additions (PR #3666 by @VaggelisD)d46ad95 - tokenizer: add support for nested comments (PR #3670 by @georgesittas)
ac0e89c - snowflake: add SECURE post table property fixes #3677 (commit by @georgesittas)acbc81d - databricks: Preserve JSON/VARIANT path with operators (PR #3678 by @VaggelisD)
07158c7 - clickhouse: Fix roundtrips of DATE/TIMESTAMP functions (PR #3683 by @VaggelisD)
79aea2a - doris: ensure LAG/LEAD are generated with three arguments (commit by @georgesittas)08fb2ec - parser: check if FROM exists when making implicit unnest explicit fixes #3671 (commit by @georgesittas)049fc5a - bigquery: handle the case-sensitive strategy in normalize_identifier (PR #3667 by @georgesittas)9e1b6aa - parser: handle another edge case in struct field type parser (PR #3682 by @georgesittas)
a1a0278 - jsonbcontains default gen (commit by @tobymao)bf44942 - oracle: Fix default NULL_ORDERING (PR #3688 by @VaggelisD)
7ae99fe - bump sqlglotrs to 0.2.7 (commit by @georgesittas)due to `d331e56` - Normalize time units in their full singular form *(PR #3652 by @VaggelisD)*:
due to d331e56 - Normalize time units in their full singular form (PR #3652 by @VaggelisD):
Normalize time units in their full singular form (#3652)
due to 468123e - create SetOperation class (PR #3661 by @georgesittas):
create SetOperation class (#3661)
e7a158b - set misc. dialect settings if available (PR #3649 by @georgesittas)ff3dabc - tsql: index on closes #3658 (commit by @tobymao)fb4d908 - tsql: clustered index closes #3659 (commit by @tobymao)88c4965 - mysql: delete redundant keywords (PR #3646 by @Toms1999)4c82c0d - Parse UNNEST as a function in base dialect (PR #3650 by @VaggelisD)
d331e56 - redshift: Normalize time units in their full singular form (PR #3652 by @VaggelisD)
a06ee36 - parser: edge case in _parse_types (PR #3656 by @georgesittas)
a739741 - teradata warning (commit by @tobymao)868f30d - improve schema error handling (PR #3663 by @georgesittas)
e8cab58 - clean up join mark elimination rule (PR #3653 by @georgesittas)468123e - create SetOperation class (PR #3661 by @georgesittas)
due to `d6cfb41` - Support for DATE_ADD functions *(PR #3609 by @VaggelisD)*:
due to d6cfb41 - Support for DATE_ADD functions (PR #3609 by @VaggelisD):
Support for DATE_ADD functions (#3609)
d6cfb41 - spark, databricks: Support for DATE_ADD functions (PR #3609 by @VaggelisD)
4b30b87 - postgres: Support DIV() func for integer division (PR #3602 by @VaggelisD)
ee9b01d - mysql: support ADD INDEX/KEY/UNIQUE in ALTER TABLE (PR #3621 by @georgesittas)
c49cefa - mysql: support STRAIGHT_JOIN (PR #3623 by @georgesittas)
e998308 - eliminate join marks (PR #3580 by @mrhopko)227e054 - oracle: support unicode strings u'...' (PR #3641 by @georgesittas)
6df5757 - bq datetime -> timestampfromparts (PR #3642 by @tobymao)6abd2c9 - oracle: Support for WITH READ ONLY / CHECK OPTION (PR #3639 by @VaggelisD)
514b3a5 - redshift: add support for Oracle style outer join markers #3611 (PR #3612 by @sandband)
6a607d3 - unnest should also be a function (commit by @tobymao)0e1a1fb - optimizer: don't use datetrunc type for right side (PR #3614 by @barakalon)d96459f - postgres: sha256 support (commit by @tobymao)05fe847 - snowflake: support fqns in masking/projection policy constraint (PR #3620 by @georgesittas)
caa3051 - snowflake: Allow SELECT keyword as JSON path key (PR #3627 by @VaggelisD)
96efb64 - tokenizer: properly handle tags that need to be identifiers in heredocs (PR #3630 by @georgesittas)
4f8edba - oracle: Allow optional format in TO_DATE (PR #3637 by @VaggelisD)
d8c6153 - oracle: don't apply eliminate_join_markers at parse time (commit by @georgesittas)1afe6ac - don't generate neq(0) if subquery predicate in ensure_bools (commit by @georgesittas)fc050bd - sqlite: Fix transpilation of GENERATED AS IDENTITY (PR #3634 by @VaggelisD)
47472d9 - duckdb: get rid of TEXT length to facilitate transpilation (PR #3633 by @georgesittas)6194c0f - clean up logic related to join marker parsing/generation (PR #3613 by @georgesittas)5396a8e - fix SQLFrame casing (PR #3616 by @eakmanrq)0397d6f - bump sqlglotrs to v0.2.6 (commit by @georgesittas)`97f8d1a` - add materialize dialect *(PR #3577 by @bobbyiliev)*
97f8d1a - add materialize dialect (PR #3577 by @bobbyiliev)bde5a8d - add risingwave dialect (PR #3598 by @neverchanje)5140817 - risingwave: clean up initial implementation of RisingWave (commit by @georgesittas)f920014 - materialize: clean up initial implementation of Materialize (PR #3608 by @georgesittas)`472058d` - bigquery: add support for GAP_FILL function *(commit by @georgesittas)*
472058d - bigquery: add support for GAP_FILL function (commit by @georgesittas)Nothing published for this version
`f7081c4` - builder other props closes #3588 *(commit by @tobymao)*
f7081c4 - builder other props closes #3588 (commit by @tobymao)13009ca - doris: use CSV syntax for GROUP_CONCAT (PR #3592 by @Toms1999)bf7fd12 - no_ilike_sql to lower both sides (PR #3593 by @barakalon)8d87568 - stop normalization_distance early (PR #3594 by @barakalon)3e38912 - duckdb: add reserved keywords (PR #3597 by @georgesittas)5683d5f - hive: generate TRUNC for TimestampTrunc (PR #3600 by @Toms1999)ff55ec1 - hive: generate string unit for TRUNC, parse it into TimestampTrunc too (commit by @georgesittas)12b6aa7 - snowflake: Fix COPY INTO with subquery (PR #3605 by @VaggelisD)
061be9b - optimize absorb_and_eliminate and remove_complements (PR #3595 by @barakalon)7dd244b - hive: test TRUNC roundtrip (commit by @georgesittas)Nothing published for this version
`158ca97` - duckdb: transpile TIMESTAMPNTZ into TIMESTAMP *(PR #3587 by @georgesittas)*
158ca97 - duckdb: transpile TIMESTAMPNTZ into TIMESTAMP (PR #3587 by @georgesittas)`60d9085` - postgres: collate with identifier closes #3578 *(commit by @tobymao)*
due to `0788c94` - Expand stars on BigQuery's tbl.struct_col.* selections *(PR #3531 by @VaggelisD)*:
due to 0788c94 - Expand stars on BigQuery's tbl.struct_col.* selections (PR #3531 by @VaggelisD):
Expand stars on BigQuery's tbl.struct_col.* selections (#3531)
due to 3e71393 - Refactor struct star expansion in BQ (PR #3576 by @VaggelisD):
Refactor struct star expansion in BQ (#3576)
0788c94 - optimizer: Expand stars on BigQuery's tbl.struct_col.* selections (PR #3531 by @VaggelisD)
14d63ee - bubble up Identifier comments to TableAliases (PR #3571 by @georgesittas)
ba90c22 - snowflake: COPY Postfix (PR #3564 by @VaggelisD)3e71393 - optimizer: Refactor struct star expansion in BQ (PR #3576 by @VaggelisD)1e1dc3f - optimizer: minor improvements in the struct star expansion (PR #3568 by @georgesittas)b12ea8c - minor style changes related to COPY INTO (commit by @georgesittas)`fb8db9f` - parser: edge case where TYPE_CONVERTERS leads to type instead of column *(PR #3566 by @georgesittas)*
fb8db9f - parser: edge case where TYPE_CONVERTERS leads to type instead of column (PR #3566 by @georgesittas)
aac8570 - use index2 instead of self._index in _parse_type index difference (commit by @georgesittas)`078471d` - mysql,doris: improve transpilation of INTERVAL (plural to singular) *(PR #3543 by @Toms1999)*
078471d - mysql,doris: improve transpilation of INTERVAL (plural to singular) (PR #3543 by @Toms1999)fe56e64 - postgres: add support for col int[size] column def syntax (PR #3548 by @georgesittas)
188dce8 - snowflake: add support for WITH-prefixed column constraints (PR #3549 by @georgesittas)
712d247 - add support for ALTER COLUMN DROP NOT NULL (PR #3550 by @noklam)
7c323bd - add option in schema's find method to ensure types are DataTypes (PR #3560 by @georgesittas)1a8a16b - clickhouse: improve struct type parsing (PR #3547 by @georgesittas)
970d3b0 - postgres: setting un-suffixed FLOAT as DOUBLE (#3551) (PR #3552 by @sandband)
e1a9a8b - redshift: add support for MINUS operator #3553 (PR #3555 by @sandband)beb0269 - tsql: adapt TimeStrToTime to avoid superfluous casts (PR #3558 by @Themiscodes)eae3c51 - use regex to split interval strings (PR #3556 by @georgesittas)
a67de5f - get rid of redundant dict_depth check in schema find (PR #3561 by @georgesittas)89a8984 - move UNESCAPED_SEQUENCES out of the _Dialect metaclass (commit by @georgesittas)893addf - add SET NOT NULL test (commit by @georgesittas)due to `80c622e` - add reserved keywords fixes #3526 *(commit by @georgesittas)*:
due to 80c622e - add reserved keywords fixes #3526 (commit by @georgesittas):
add reserved keywords fixes #3526
a255610 - add StringToArray expression (postgres), improve its transpilation (commit by @georgesittas)8f46d48 - redshift: transpile SPLIT_TO_STRING (commit by @georgesittas)80c622e - doris: add reserved keywords fixes #3526 (commit by @georgesittas)ebf5fc7 - hive: generate correct names for weekofyear, dayofmonth, dayofweek (PR #3533 by @oshyun)
3fe3c2c - parser: make _parse_type less aggressive, only parse column as last resort (PR #3541 by @georgesittas)
8afff02 - tsql: preserve REPLICATE roundtrip (commit by @georgesittas)due to `a077f17` - add reserved keywords *(PR #3525 by @georgesittas)*:
due to a077f17 - add reserved keywords (PR #3525 by @georgesittas):
add reserved keywords (#3525)
d958bba - snowflake: add support for CREATE WAREHOUSE (PR #3510 by @yingw787)
2105300 - databricks: Enable hex string literals (PR #3522 by @VaggelisD)
1ef3bb6 - snowflake: Add support for CREATE STREAMLIT (PR #3519 by @yingw787)
5cecbfa - unnest identifier closes #3512 (commit by @tobymao)33ab353 - snowflake: parse certain DB_CREATABLES as identifiers (commit by @georgesittas)d468f92 - doris: dont generate arrows for JSONExtract* closes #3513 (commit by @georgesittas)bfb9f98 - postgres: parse @> into ArrayContainsAll, improve transpilation (PR #3515 by @georgesittas)
4def45b - make UDF DDL property parsing more lenient closes #3517 (commit by @georgesittas)a077f17 - mysql: add reserved keywords (PR #3525 by @georgesittas)
358f30c - remove redundant postgres JSONB token mapping (commit by @georgesittas)due to `77d21d9` - parse : operator as JSONExtract (similar to Snowflake) *(PR #3508 by @georgesittas)*:
due to 77d21d9 - parse : operator as JSONExtract (similar to Snowflake) (PR #3508 by @georgesittas):
parse : operator as JSONExtract (similar to Snowflake) (#3508)
77d21d9 - databricks: parse : operator as JSONExtract (similar to Snowflake) (PR #3508 by @georgesittas)due to `e281db8` - Add ALTER TABLE SET *(PR #3485 by @VaggelisD)*:
due to e281db8 - Add ALTER TABLE SET (PR #3485 by @VaggelisD):
Add ALTER TABLE SET (#3485)
e281db8 - Add ALTER TABLE SET (PR #3485 by @VaggelisD)9aee21b - add RETURNS NULL ON NULL and STRICT properties (PR #3504 by @georgesittas)
`89c1d3a` - clickhouse: support generate TimestampTrunc, Variance, Stddev *(PR #3489 by @longxiaofei)*
89c1d3a - clickhouse: support generate TimestampTrunc, Variance, Stddev (PR #3489 by @longxiaofei)due to `846d5cd` - set default precision / width for DECIMAL type *(PR #3472 by @georgesittas)*:
due to 846d5cd - set default precision / width for DECIMAL type (PR #3472 by @georgesittas):
set default precision / width for DECIMAL type (#3472)
due to e3ff67b - preserve star clauses (EXCLUDE, RENAME, REPLACE) (PR #3477 by @georgesittas):
preserve star clauses (EXCLUDE, RENAME, REPLACE) (#3477)
due to b417c80 - parse TININT into UTINYINT to improve transpilation (PR #3486 by @georgesittas):
parse TININT into UTINYINT to improve transpilation (#3486)
due to 54e31af - add DECLARE statement parsing (PR #3462 by @jlucas-fsp):
add DECLARE statement parsing (#3462)
due to 7287bb9 - nested cte ordering closes #3488 (commit by @tobymao):
nested cte ordering closes #3488
2c29bf3 - snowflake: add support for CREATE TAG DDL statement (PR #3473 by @georgesittas)
2433993 - transpiler: handle different hex behavior for dialects (PR #3463 by @viplazylmht)
0009e09 - add epoch_ms of duckdb to other dialects (PR #3471 by @longxiaofei)461215b - clickhouse: add support for PROJECTION in CREATE TABLE statement (PR #3465 by @GaliFFun)54e31af - tsql: add DECLARE statement parsing (PR #3462 by @jlucas-fsp)c811adb - snowflake array_construct_compact to spark (commit by @tobymao)58d5f2b - presto: fix parsing and generating hash functions presto/trino (PR #3459 by @viplazylmht)
065281e - optimizer: fix multiple bugs in unnest_subqueries, clean up test suite (PR #3464 by @georgesittas)
80ba1e8 - preserve quotes for projections produced by the eliminate_qualify rule (PR #3470 by @aersam)
3bc1fbe - make quoting of alias_or_name in eliminate_qualify more robust (commit by @georgesittas)1843e9b - allow parameters in user-defined types (PR #3474 by @georgesittas)e004d2a - duckdb: preserve precedence of json extraction when converting to arrow syntax (PR #3478 by @georgesittas)
e3ff67b - snowflake: preserve star clauses (EXCLUDE, RENAME, REPLACE) (PR #3477 by @georgesittas)
428fd61 - mysql: generate CONCAT for DPipe (PR #3482 by @georgesittas)
b417c80 - tsql: parse TININT into UTINYINT to improve transpilation (PR #3486 by @georgesittas)a3ff49e - presto: fix DELETE DML statement for presto/trino (PR #3466 by @viplazylmht)7287bb9 - nested cte ordering closes #3488 (commit by @tobymao)5b64475 - allow rollup to be used as an identifier (PR #3495 by @georgesittas)
846d5cd - snowflake: set default precision / width for DECIMAL type (PR #3472 by @georgesittas)930f923 - clean up Hex / LowerHex implementation (PR #3483 by @georgesittas)883fcd7 - presto: make DELETE transpilation more robust (PR #3487 by @georgesittas)49f7f85 - tsql: handle TABLE <schema> more gracefully for DeclareItem (commit by @georgesittas)due to `510f8b5` - improve transpilation of TABLESAMPLE clause *(PR #3457 by @georgesittas)*:
due to 510f8b5 - improve transpilation of TABLESAMPLE clause (PR #3457 by @georgesittas):
improve transpilation of TABLESAMPLE clause (#3457)
`c3bb3da` - change python-version to 3.11 for build-rs *(commit by @georgesittas)*
c3bb3da - change python-version to 3.11 for build-rs (commit by @georgesittas)`cd8f568` - fix rust deployment workflow bug *(commit by @georgesittas)*
cd8f568 - fix rust deployment workflow bug (commit by @georgesittas)Nothing published for this version
Nothing published for this version
`130255e` - update rust *(commit by @tobymao)*
`116172a` - add support for ON property in ALTER and DROP statements *(PR #3450 by @GaliFFun)*
116172a - add support for ON property in ALTER and DROP statements (PR #3450 by @GaliFFun)aa104fd - add semi colon comments (commit by @tobymao)2c62267 - bigquery: fix SHA1 generator (PR #3453 by @viplazylmht)
fb3dea9 - clickhouse: fix parsing and generating hash functions (PR #3454 by @viplazylmht)
b76dfda - snowflake: COPY Subquery postfix (PR #3449 by @VaggelisD)
`33ac4fc` - add create view tsql *(commit by @tobymao)*
due to `9338ebc` - tsql drop view no catalog *(commit by @tobymao)*:
80670bb - snowflake: Support for APPROX_PERCENTILE (PR #3426 by @VaggelisD)
b46c5b3 - clickhouse: add support for partition expression (PR #3428 by @GaliFFun)07badc9 - clickhouse: add support for ALTER TABLE REPLACE PARTITION statement (PR #3441 by @GaliFFun)baf39e7 - redshift: improve ALTER TABLE .. ALTER .. support (PR #3444 by @georgesittas)e8014e2 - mysql: Parse REPLACE statement as Command (PR #3425 by @VaggelisD)
273731f - snowflake: parse CREATE SEQUENCE with commas (PR #3436 by @georgesittas)
761ba6f - don't generate connector comments when comments=False closes #3439 (commit by @georgesittas)a2a6eaa - handle empty string in connector comment padding (PR #3437 by @uncledata)1bc0ce5 - func to binary MOD generation (PR #3440 by @VaggelisD)
5cfb29c - bigquery: MOD edge case (commit by @georgesittas)9825c4c - improve error handling for nested schema levels (PR #3445 by @tobymao)c309def - duckdb: use name sequence instead of single _t for unnest alias (PR #3446 by @georgesittas)0927ae3 - executor: use timezone-aware object to represent datetime in UTC (PR #3447 by @georgesittas)9338ebc - tsql drop view no catalog (commit by @tobymao)30f9d30 - bump ruff to 0.4.3 (PR #3430 by @georgesittas)91bed56 - test 3.12 (commit by @tobymao)due to `258ad3b` - parse column instead of identifier for SET assignment LHS *(PR #3417 by @georgesittas)*:
due to 258ad3b - parse column instead of identifier for SET assignment LHS (PR #3417 by @georgesittas):
parse column instead of identifier for SET assignment LHS (#3417)
258ad3b - parse column instead of identifier for SET assignment LHS (PR #3417 by @georgesittas)
17c31da - lineage: get rid of comments in Node names (PR #3418 by @georgesittas)
ea197ea - snowflake: ensure OBJECT_CONSTRUCT is not generated inside of VALUES (PR #3419 by @georgesittas)`4dbcd4f` - refactor publish workflow for sqlglotrs releasing *(commit by @georgesittas)*
4dbcd4f - refactor publish workflow for sqlglotrs releasing (commit by @georgesittas)`aa4f90a` - refactor publish workflow for sqlglotrs releasing *(commit by @georgesittas)*
aa4f90a - refactor publish workflow for sqlglotrs releasing (commit by @georgesittas)`0deffd8` - refactor publish workflow for sqlglotrs releasing *(commit by @georgesittas)*
0deffd8 - refactor publish workflow for sqlglotrs releasing (commit by @georgesittas)`5125732` - refactor publish workflow for sqlglotrs releasing *(commit by @georgesittas)*
5125732 - refactor publish workflow for sqlglotrs releasing (commit by @georgesittas)`0a36dd8` - fix should-deploy-rs bash condition *(commit by @georgesittas)*
0a36dd8 - fix should-deploy-rs bash condition (commit by @georgesittas)`fc979a0` - snowflake: make FILE_FORMAT option always be uppercase in COPY INTO *(commit by @georgesittas)*
fc979a0 - snowflake: make FILE_FORMAT option always be uppercase in COPY INTO (commit by @georgesittas)1b5b77d - improve unsupported error documentation (PR #3406 by @georgesittas)fcb51af - release sqlglotrs only when Cargo.toml is updated (PR #3408 by @georgesittas)`2c2a788` - snowflake: COPY postfix *(PR #3398 by @VaggelisD)*
2c2a788 - snowflake: COPY postfix (PR #3398 by @VaggelisD)
due to `cc6259d` - Mark UDTF child scopes as ScopeType.SUBQUERY *(PR #3390 by @VaggelisD)*:
due to cc6259d - Mark UDTF child scopes as ScopeType.SUBQUERY (PR #3390 by @VaggelisD):
Mark UDTF child scopes as ScopeType.SUBQUERY (#3390)
due to 33bae9b - get rid of superfluous "parameters" arg in RegexpReplace (PR #3394 by @georgesittas):
get rid of superfluous "parameters" arg in RegexpReplace (#3394)
due to 3768514 - snowflake optional merge insert (commit by @tobymao):
snowflake optional merge insert
due to d1b4f1f - Introducing TIMESTAMP_NTZ token and data type (PR #3386 by @VaggelisD):
Introducing TIMESTAMP_NTZ token and data type (#3386)
d1b4f1f - Introducing TIMESTAMP_NTZ token and data type (PR #3386 by @VaggelisD)
16691f9 - prql: add support for AGGREGATE (PR #3395 by @fool1280)534fb80 - postgres: add support for anonymos index DDL syntax (PR #3403 by @georgesittas)a2afcca - mysql: don't cast into invalid numeric/text types (PR #3375 by @georgesittas)60b5c3b - spark: transpile presto TRY, fix JSON casting issue (PR #3376 by @georgesittas)
3e8de71 - postgres: allow FOR clause without FROM in SUBSTRING closes #3377 (commit by @georgesittas)b2a7e55 - optimizer: Remove XOR from connector simplifications (PR #3380 by @VaggelisD)
477754c - trino: bring back TRIM parsing (PR #3385 by @georgesittas)
cc6259d - optimizer: Mark UDTF child scopes as ScopeType.SUBQUERY (PR #3390 by @VaggelisD)0d23b20 - allow joins in FROM expression parser (PR #3389 by @georgesittas)
e7021df - duckdb: Preserve DATE_SUB roundtrip (PR #3382 by @VaggelisD)
641b296 - postgres: tokenize INT8 as BIGINT (PR #3392 by @georgesittas)
33bae9b - get rid of superfluous "parameters" arg in RegexpReplace (PR #3394 by @georgesittas)
3768514 - snowflake optional merge insert (commit by @tobymao)f44cd24 - make generated constraint parsing more lenient fixes #3397 (commit by @georgesittas)00ff877 - tsql: quote hash sign as well for quoted temporary tables (PR #3401 by @georgesittas)
84b7026 - trino: support for data type 'tdigest' (PR #3402 by @suryaiyer95)24e1115 - trino|presto: adding cast support for "hyperloglog" column type (PR #3405 by @uncledata)`d2a6f16` - COPY TO/FROM statement *(PR #3359 by @VaggelisD)*
d2a6f16 - COPY TO/FROM statement (PR #3359 by @VaggelisD)f034ea0 - mysql: Transpile TimestampTrunc (PR #3367 by @VaggelisD)
f697cb1 - duckdb describe query closes #3353 (commit by @tobymao)6e0fc5d - export optimizer functions explicitly in init (PR #3358 by @georgesittas)
23d45ee - postgres: don't generate CommentColumnConstraint (PR #3357 by @georgesittas)e87685b - lineage: use source names of derived table sources for laterals (PR #3360 by @georgesittas)
e82a30b - postgres: don't generate SchemaCommentProperty (PR #3364 by @georgesittas)47dc52c - mysql: convert epoch extraction into UNIX_TIMESTAMP call (PR #3369 by @georgesittas)
b8f0979 - mysql: generate GROUP_CONCAT for ArrayAgg (PR #3370 by @georgesittas)
b928f54 - don't mutate the AST when creating DDL scopes (PR #3371 by @georgesittas)`719d394` - add a test for quoted aliases *(commit by @tobymao)*
due to `c5ce47b` - Combine aggregate functions with orderby from WITHIN GROUP *(PR #3352 by @VaggelisD)*:
due to c5ce47b - Combine aggregate functions with orderby from WITHIN GROUP (PR #3352 by @VaggelisD):
Combine aggregate functions with orderby from WITHIN GROUP (#3352)
80793cc - parse (a,) as a tuple instead of a paren (PR #3341 by @georgesittas)b3826f8 - allow comments to be attached for identifiers used in definitions (PR #3340 by @georgesittas)ce7d893 - clickhouse: Parse window functions in ParameterizedAggFuncs (PR #3347 by @VaggelisD)
0e54975 - tsql: only use target table name when generating sp_rename (PR #3342 by @georgesittas)52bdd0c - tsql: Convert TIMESTAMP to ROWVERSION, transpile both to BINARY (PR #3348 by @VaggelisD)
c5ce47b - duckdb: Combine aggregate functions with orderby from WITHIN GROUP (PR #3352 by @VaggelisD)
`68595eb` - edge case *(commit by @tobymao)*
`9cf6f4e` - don't allow any_token on reserved keywords *(commit by @tobymao)*
due to `290e408` - Preserve DPipe in simplify_concat *(PR #3317 by @VaggelisD)*:
due to 290e408 - Preserve DPipe in simplify_concat (PR #3317 by @VaggelisD):
Preserve DPipe in simplify_concat (#3317)
due to 83cff79 - add comprehensive reserved keywords for presto and redshift (PR #3322 by @tobymao):
add comprehensive reserved keywords for presto and redshift (#3322)
due to 61f5b12 - Introduce partition in exp.Table (PR #3327 by @VaggelisD):
Introduce partition in exp.Table (#3327)
due to 1832ff1 - dynamic styling for inline arrays (commit by @tobymao):
dynamic styling for inline arrays
due to 5fb7f5b - dont double indent comments (commit by @tobymao):
dont double indent comments
4f1691a - allow qualify to also annotate on the fly for unnest support (PR #3316 by @tobymao)83cff79 - add comprehensive reserved keywords for presto and redshift (PR #3322 by @tobymao)ef3311a - hive: Add 'STORED AS' option in INSERT DIRECTORY (PR #3326 by @VaggelisD)
7f9cb2d - clickhouse: Add support for DATE_FORMAT / formatDateTime (PR #3329 by @VaggelisD)
61f5b12 - Introduce partition in exp.Table (PR #3327 by @VaggelisD)
31744b2 - prql: handle NULL (PR #3331 by @fool1280)1105044 - tsql: add alter table rename (commit by @tobymao)1832ff1 - dynamic styling for inline arrays (commit by @tobymao)ef84f17 - optimizer: don't simplify parentheses when parent is SubqueryPredicate (PR #3315 by @georgesittas)290e408 - optimizer: Preserve DPipe in simplify_concat (PR #3317 by @VaggelisD)
52b957a - transform eliminate_qualify on generated columns (PR #3307 by @viplazylmht)eb8d7b8 - remove e*s mapping because it's not equivalent to %f (commit by @tobymao)9de1494 - allow bigquery udf with resered keyword closes #3332 (PR #3333 by @tobymao)e2b6213 - don't double comment unions (commit by @tobymao)5fb7f5b - dont double indent comments (commit by @tobymao)`506760d` - redshift: unqualify unnest columns *(PR #3314 by @georgesittas)*
506760d - redshift: unqualify unnest columns (PR #3314 by @georgesittas)0450521 - get rid of 1st projection pad for leading comma formatting (PR #3308 by @georgesittas)due to `32cdc36` - allow unions to be limited directly and stop subquerying since… *(PR #3301 by @tobymao)*:
due to 32cdc36 - allow unions to be limited directly and stop subquerying since… (PR #3301 by @tobymao):
allow unions to be limited directly and stop subquerying since… (#3301)
due to 3c97d34 - parse right-hand side of <value> IN (<query>) as a Subquery (PR #3304 by @georgesittas):
parse right-hand side of <value> IN (<query>) as a Subquery (#3304)
due to 75e0c69 - cast less aggressively (PR #3302 by @georgesittas):
cast less aggressively (#3302)
a721923 - prql: Add support for SORT (PR #3297 by @fool1280)2ea438b - is_negative helper method (commit by @tobymao)b28cd89 - improve transpilation of datetime functions to Teradata (PR #3295 by @maureen-daum)32cdc36 - allow unions to be limited directly and stop subquerying since… (PR #3301 by @tobymao)
1bc51df - teradata: handle transpile of quarter function (PR #3303 by @maureen-daum)4790414 - prql: Handle DESC with sort (PR #3299 by @fool1280)3c97d34 - parse right-hand side of <value> IN (<query>) as a Subquery (PR #3304 by @georgesittas)75e0c69 - cast less aggressively (PR #3302 by @georgesittas)d3472c6 - Add postgres transpilation for TIME_TO_UNIX (PR #3305 by @crericha)2224881 - case when / if should ignore null types (commit by @tobymao)5b2feb7 - allow unnesting to bring struct fields into scope (commit by @tobymao)`eabb708` - prql: add filter, set operations *(PR #3291 by @fool1280)*
94c188d - optimizer: propagate recursive CTE source to children scopes early (PR #3294 by @georgesittas)281db61 - replace fully qualified columns with generated table aliases since they become invalid (commit by @tobymao)`942856d` - postgres: add COMMENT ON MATERIALIZED VIEW *(PR #3293 by @l-vincent-l)*
942856d - postgres: add COMMENT ON MATERIALIZED VIEW (PR #3293 by @l-vincent-l)fd24b27 - make exp.to_column more lenient (PR #3292 by @georgesittas)due to `6bba030` - transpile map retrieval to duckdb, transpile TRY_ELEMENT_AT *(PR #3277 by @georgesittas)*:
due to 6bba030 - transpile map retrieval to duckdb, transpile TRY_ELEMENT_AT (PR #3277 by @georgesittas):
transpile map retrieval to duckdb, transpile TRY_ELEMENT_AT (#3277)
due to 02218fc - allow to_column to properly parse quoted column paths, make types simpler (PR #3289 by @tobymao):
allow to_column to properly parse quoted column paths, make types simpler (#3289)
08222c2 - clickhouse: add support for MATERIALIZED, EPHEMERAL column constraints (PR #3275 by @pkit)6bba030 - transpile map retrieval to duckdb, transpile TRY_ELEMENT_AT (PR #3277 by @georgesittas)1726923 - desc history databricks closes #3280 (commit by @tobymao)0690cbc - snowflake: FINAL/RUNNING keywords in MATCH_RECOGNIZE MEASURES (PR #3284 by @VaggelisD)
1311ba3 - presto: add support for DISTINCT / ALL after GROUP BY (PR #3290 by @georgesittas)
f65d812 - move EphemeralColumnConstraint generation to base generator (commit by @georgesittas)6d1c44d - optimizer: unnest union subqueries (PR #3278 by @georgesittas)
a37d231 - presto: allow qualify to be an alias closes #3287 (commit by @tobymao)02218fc - allow to_column to properly parse quoted column paths, make types simpler (PR #3289 by @tobymao)fe0eb57 - pass quoted to the identifier (commit by @tobymao)`e33fb01` - prql: Add support for TAKE *(PR #3258 by @fool1280)*
One column per quarter.