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 `d044414` - support transpilation of function LEFT from Snowflake … *(PR #7419 by @fivetran-ashashankar)*:
due to d044414 - support transpilation of function LEFT from Snowflake … (PR #7419 by @fivetran-ashashankar):
support transpilation of function LEFT from Snowflake … (#7419)
due to 61bb18c - Transpilation support for TO_DECIMAL, TO_NUMBER,NUMERIC (PR #7315 by @fivetran-ashashankar):
Transpilation support for TO_DECIMAL, TO_NUMBER,NUMERIC (#7315)
d044414 - duckdb: support transpilation of function LEFT from Snowflake … (PR #7419 by @fivetran-ashashankar)11e0dab - add Expr.pipe and Expr.apply methods (PR #7442 by @OutSquareCapital)21f4ecc - duckdb: transpilation support for position with binary arguments (PR #7433 by @fivetran-ashashankar)d57221a - hive: add native AST support for USING JAR/FILE/ARCHIVE in CREATE FUNCTION (PR #7436 by @hashwnath)
8a070fd - duckdb: Add transpilation unsupported for COMPRESS function (PR #7445 by @fivetran-amrutabhimsenayachit)eb9dbac - bigquery: support AI.FORECAST function (PR #7457 by @RedZapdos123)
61bb18c - snowflake: Transpilation support for TO_DECIMAL, TO_NUMBER,NUMERIC (PR #7315 by @fivetran-ashashankar)4c29711 - duckdb: Add transpilation support for COLLATION function (PR #7443 by @fivetran-amrutabhimsenayachit)9cf3485 - snowflake: parse and generate ROW ACCESS POLICY on views [CLAUDE] (PR #7467 by @eakmanrq)09b5912 - sqlite: support PRAGMA full syntax (PR #7441 by @geooo109)
b61a85f - bigquery: column offset (PR #7451 by @geooo109)
b7c057d - bigquery: pipe syntax DISTINCT (PR #7450 by @geooo109)
2b3dba1 - presto: iterate over copy in eliminate_semi_and_anti_joins (PR #7455 by @Evgeniy-Sinyak)2fc0c25 - bigquery: parse MODEL-first AI/ML GENERATE signatures (PR #7463 by @RedZapdos123)
4deba62 - typing: add annotations in dialect/parser/schema modules (PR #7444 by @OutSquareCapital)c31e2e3 - Optimizer: improve typing coverage of optimizer modules (PR #7446 by @OutSquareCapital)08b51e8 - use ruff UP rule to modernize coding style (PR #7459 by @georgesittas)2e7dec0 - Bump sqlglot-mypy to 1.20 (PR #7439 by @VaggelisD)500e0ce - Fix uv sync picking up sqlglotc in python 3.9 (PR #7452 by @VaggelisD)0445c24 - Revert setup.py for sqlglot-mypy (PR #7458 by @VaggelisD)576b5a8 - add MaxCompute plugin to dialects list (PR #7466 by @azurechen97)Your coding agent can read these notes before it upgrades. Set up the MCP server →
`6983aed` - postgres: _date_add_sql bug w/ interval inputs *(PR #7440 by @georgesittas)*
6983aed - postgres: _date_add_sql bug w/ interval inputs (PR #7440 by @georgesittas)due to `4bc6857` - Transpilation support for STRIP_NULL_VALUE transpilation *(PR #7403 by @fivetran-ashashankar)*:
due to 4bc6857 - Transpilation support for STRIP_NULL_VALUE transpilation (PR #7403 by @fivetran-ashashankar):
Transpilation support for STRIP_NULL_VALUE transpilation (#7403)
due to e27477f - Compile annotate_types.py with mypyc (PR #7407 by @VaggelisD):
Compile annotate_types.py with mypyc (#7407)
due to 31595ba - Compile simplify.py with mypyc (PR #7415 by @VaggelisD):
Compile simplify.py with mypyc (#7415)
due to 395ada8 - Transpilation support for UNICODE transpilation. (PR #7408 by @fivetran-ashashankar):
Transpilation support for UNICODE transpilation. (#7408)
due to 7a91128 - give precises types to all **opts argument, optimize ensure_list() (PR #7393 by @OutSquareCapital):
give precises types to all **opts argument, optimize ensure_list() (#7393)
3f4e92e - duckdb: Add transpilation support to TRY_PARSE_JSON (PR #7406 by @fivetran-amrutabhimsenayachit)4bc6857 - snowflake: Transpilation support for STRIP_NULL_VALUE transpilation (PR #7403 by @fivetran-ashashankar)395ada8 - snowflake: Transpilation support for UNICODE transpilation. (PR #7408 by @fivetran-ashashankar)8bebadf - duckdb: Support DuckDB table functions (PR #7410 by @pittst3r)62d7176 - duckdb: Add transpilation support for BIT_LENGTH (PR #7421 by @fivetran-amrutabhimsenayachit)c2b69d4 - sqlite: support virtual table ddl closes #7425 (commit by @georgesittas)3f31ffe - duckdb: Add transpilation support for CHR function. (PR #7430 by @fivetran-amrutabhimsenayachit)22a5bc2 - optimizer: simplify ranges with negative constants (PR #7405 by @geooo109)24738e4 - bigquery: nested queries in EXPORT statement fixes #7409 (commit by @georgesittas)2ac9a20 - duckdb: support TRUNC with decimal arg (PR #7414 by @geooo109)
64c4438 - duckdb: transpilation for snowflake TRUNC with non integer scale (PR #7417 by @geooo109)9068242 - bigquery: support hyphen, numbers, single dot as JSON keys (PR #7420 by @geooo109)8e0b9f5 - snowflake: Fix annotate_types crashes for FLATTEN over STRUCT and WithinGroup (PR #7434 by @georgesittas)e27477f - optimizer: Compile annotate_types.py with mypyc (PR #7407 by @VaggelisD)31595ba - optimizer: Compile simplify.py with mypyc (PR #7415 by @VaggelisD)247548f - Expressions: add into_expr method to DType enum (PR #7411 by @OutSquareCapital)7a91128 - give precises types to all **opts argument, optimize ensure_list() (PR #7393 by @OutSquareCapital)ab8f808 - expressions: Remove mypyc init_subclass workaround and simplify EXPR_CLASSES (PR #7426 by @VaggelisD)ce16997 - clean tokenizer/dialect code from **opts, and minor typing improvements (PR #7422 by @OutSquareCapital)`f7bb6be` - use collections.abc and built-in types for typing to avoid deprecation *(PR #7329 by @OutSquareCapital)*
due to 0921899 - support for TEXTLEN function (PR #7346 by @AbhishekASLK):
support for TEXTLEN function (#7346)
due to 83e7851 - Compile base Generator with mypyc (PR #7351 by @VaggelisD):
Compile base Generator with mypyc (#7351)
due to a424037 - Extract and compile generator (PR #7362 by @VaggelisD):
Extract and compile generator (#7362)
due to a482dc5 - Extract and compile generator (PR #7363 by @VaggelisD):
Extract and compile generator (#7363)
due to cb78bc3 - Extract and compile generator (PR #7365 by @VaggelisD):
Extract and compile generator (#7365)
due to adf0032 - Extract and compile generator (PR #7366 by @VaggelisD):
Extract and compile generator (#7366)
due to 7d26eed - Extract and compile generator (PR #7367 by @VaggelisD):
Extract and compile generator (#7367)
due to 56e7a88 - Extract and compile generator (PR #7370 by @VaggelisD):
Extract and compile generator (#7370)
due to 2e8d3dd - Extract and compile generator (PR #7374 by @VaggelisD):
Extract and compile generator (#7374)
due to b1d5a06 - Extract and compile generator (PR #7364 by @VaggelisD):
Extract and compile generator (#7364)
due to 3ab4cf2 - Extract and compile generator (PR #7371 by @VaggelisD):
Extract and compile generator (#7371)
due to 0a13068 - Extract and compile generator (PR #7376 by @VaggelisD):
Extract and compile generator (#7376)
due to 09cc35d - Extract and compile generator (PR #7373 by @VaggelisD):
Extract and compile generator (#7373)
due to d301233 - Extract and compile generator (PR #7372 by @VaggelisD):
Extract and compile generator (#7372)
due to d1b0d8f - Fix [NOT] REGEXP / REGEXP_LIKE transpilation from Snowflake to DuckDB (PR #7354 by @fivetran-amrutabhimsenayachit):
Fix [NOT] REGEXP / REGEXP_LIKE transpilation from Snowflake to DuckDB (#7354)
due to 53d56d4 - Extract and compile generator (PR #7369 by @VaggelisD):
Extract and compile generator (#7369)
due to 586e28e - Extract and compile generator (PR #7377 by @VaggelisD):
Extract and compile generator (#7377)
due to dcf01c1 - Extract and compile generator (PR #7379 by @VaggelisD):
Extract and compile generator (#7379)
due to f7668a7 - Extract and compile generator (PR #7368 by @VaggelisD):
Extract and compile generator (#7368)
due to 21693d7 - refactor JSON extract (PR #7302 by @geooo109):
refactor JSON extract (#7302)
due to 850bf1e - Extract and compile generator (PR #7375 by @VaggelisD):
Extract and compile generator (#7375)
due to 1b14a79 - Extract and compile generator (PR #7381 by @VaggelisD):
Extract and compile generator (#7381)
due to fcc09dd - Add transpilation support for ARRAY_UNIQUE_AGG function (PR #7386 by @fivetran-amrutabhimsenayachit):
Add transpilation support for ARRAY_UNIQUE_AGG function (#7386)
4a077ca - duckdb: Add transpilation support for neg position args for CHARINDEX (PR #7334 by @fivetran-amrutabhimsenayachit)0921899 - redshift: support for TEXTLEN function (PR #7346 by @AbhishekASLK)64f7e6c - duckdb: Add transpilation support for check_json function (PR #7353 by @fivetran-amrutabhimsenayachit)4743e76 - optimizer: annotate types for ORDER BY alias references (PR #7281 by @doripo)d1b0d8f - duckdb: Fix [NOT] REGEXP / REGEXP_LIKE transpilation from Snowflake to DuckDB (PR #7354 by @fivetran-amrutabhimsenayachit)d5f74a6 - duckdb: Add tests for NOT RLIKE to check the full match semantics (PR #7384 by @fivetran-amrutabhimsenayachit)3a52141 - postgres: handle non-literal interval values in datetime addition (PR #7360 by @georgesittas)fcc09dd - duckdb: Add transpilation support for ARRAY_UNIQUE_AGG function (PR #7386 by @fivetran-amrutabhimsenayachit)263bb7f - duckdb: do not issue CREATE unsupported iceberg property warning (PR #7396 by @treysp)438f031 - duckdb: support the full SHOW TABLES syntax spec (commit by @georgesittas)7216cf9 - snowflake: support DROP ICEBERG TABLE (PR #7398 by @treysp)b6ada45 - snowflake: support ALTER ICEBERG TABLE (PR #7401 by @treysp)877e184 - duckdb: Add transpilation support for ILIKE ANY, LIKE ANY/ALL functions for ESCAPE pattern (PR #7394 by @fivetran-amrutabhimsenayachit)d257e76 - clickhouse: lowercase dateTrunc units for versions before 23.12 (PR #7331 by @markcheney1)2cb9772 - optimizer: enhance simplify_parens to handle additional parent types (PR #7339 by @MuSilk)
9973623 - optimizer: qualify column named END (PR #7345 by @geooo109)
13e971d - clickhouse: UUID property (PR #7349 by @geooo109)
2a248f1 - optimizer: fix correlated subquery (PR #7343 by @fivetran-amrutabhimsenayachit)
0624bbf - mysql: Fix AttributeError crash when transpiling IGNORE/RESPECT NULLS (PR #7361 by @ShubhamKapoor992)
0344937 - handle pipe operator after subquery closes #7388 (PR #7391 by @georgesittas)2b19bdc - bigquery: support parentheses for CAST FORMAT syntax (PR #7395 by @ShubhamKapoor992)
83e7851 - generator: Compile base Generator with mypyc (PR #7351 by @VaggelisD)a424037 - tableau: Extract and compile generator (PR #7362 by @VaggelisD)a482dc5 - teradata: Extract and compile generator (PR #7363 by @VaggelisD)cb78bc3 - druid: Extract and compile generator (PR #7365 by @VaggelisD)adf0032 - sqlite: Extract and compile generator (PR #7366 by @VaggelisD)7d26eed - dremio: Extract and compile generator (PR #7367 by @VaggelisD)56e7a88 - snowflake: Extract and compile generator (PR #7370 by @VaggelisD)2e8d3dd - hive: Extract and compile generator (PR #7374 by @VaggelisD)b1d5a06 - drill: Extract and compile generator (PR #7364 by @VaggelisD)3ab4cf2 - oracle: Extract and compile generator (PR #7371 by @VaggelisD)0a13068 - postgres: Extract and compile generator (PR #7376 by @VaggelisD)09cc35d - tsql: Extract and compile generator (PR #7373 by @VaggelisD)d301233 - bigquery: Extract and compile generator (PR #7372 by @VaggelisD)53d56d4 - exasol: Extract and compile generator (PR #7369 by @VaggelisD)586e28e - spark: Extract and compile generator (PR #7377 by @VaggelisD)dcf01c1 - presto: Extract and compile generator (PR #7379 by @VaggelisD)f7668a7 - clickhouse: Extract and compile generator (PR #7368 by @VaggelisD)850bf1e - duckdb: Extract and compile generator (PR #7375 by @VaggelisD)1b14a79 - mysql: Extract and compile generator (PR #7381 by @VaggelisD)3582aa5 - generators: Cleanup and fully compile all generators (PR #7389 by @VaggelisD)4e9ed57 - benchworkflow (PR #7340 by @tobymao)0fce391 - refactor duckdb strposition_sql (commit by @geooo109)f7bb6be - use collections.abc and built-in types for typing to avoid deprecation (PR #7329 by @OutSquareCapital)f5e0a8a - always run sqlglot integration tests (PR #7350 by @georgesittas)f0f04d9 - Fix mypyc setup (PR #7382 by @VaggelisD)47325ce - only trigger the benchmark job manually (PR #7383 by @georgesittas)21693d7 - parser: refactor JSON extract (PR #7302 by @geooo109)c1842b2 - added annotations to all **opts arguments (PR #7342 by @OutSquareCapital)`f87ebe0` - use mypyc i64 for parser index fields (~1.6% faster) *(commit by @tobymao)*
due to `936617e` - escape comment markers in sanitize_comment for all dialects *(PR #7301 by @llimllib)*:
due to 936617e - escape comment markers in sanitize_comment for all dialects (PR #7301 by @llimllib):
escape comment markers in sanitize_comment for all dialects (#7301)
due to 4f6bcd3 - Add transpilation support for ARRAY_TO_STRING function (PR #7289 by @fivetran-amrutabhimsenayachit):
Add transpilation support for ARRAY_TO_STRING function (#7289)
4f6bcd3 - duckdb: Add transpilation support for ARRAY_TO_STRING function (PR #7289 by @fivetran-amrutabhimsenayachit)b41a99a - duckdb: FROM pipe syntax in subquery (PR #7311 by @geooo109)
936617e - escape comment markers in sanitize_comment for all dialects (PR #7301 by @llimllib)6ddaee3 - expressions: restore Expression.alias behaviour for non-Identifier alias nodes (PR #7310 by @treff7es)ce08047 - snowflake: ILIKE/LIKE ANY/ALL with single element transpilation to duckdb (PR #7314 by @geooo109)
8a52de6 - parser: Add builder for ARRAY_INTERSECT (PR #7328 by @VaggelisD)
f8a7ab2 - parser: Do not consume constraints following UNIQUE (PR #7330 by @VaggelisD)
64509a2 - sqlglotc sdist install fails when ../sqlglot dir doesn't exist (PR #7337 by @tobymao)
0ac52aa - move instance variables to init for perf (commit by @tobymao)c95ae50 - optimize parser for nested function calls (-41% on nested_funct… (PR #7307 by @tobymao)1697bc3 - optimize parser fast path for simple table references (commit by @tobymao)18f15ca - inline token parsing for massive gains (PR #7335 by @tobymao)fe7874f - update changelog with v30 release notes (PR #7309 by @georgesittas)8a914f0 - use ProcessPoolExecutor in test_executor (PR #7313 by @georgesittas)604fe3f - improve integration test submodule automations (PR #7320 by @georgesittas)c7b55c1 - Fix uv sync failing for sqlglotc (PR #7322 by @VaggelisD)
158424c - update readme (commit by @tobymao)`7bcad5c` - auto pin sqlglotc version to sqlglot so there's no version mismatch closes #7304 *(commit by @tobymao)*
This required restructuring several internal modules, which introduces breaking changes for users who depend on internal APIs, subclass parsers, or im…
SQLGlot v30 is a major release focused on performance and compilation. Some of the core components of the library are now fully compilable by mypyc, delivering significant speedups when installed with the [c] extra. This required restructuring several internal modules, which introduces breaking changes for users who depend on internal APIs, subclass parsers, or import from internal paths.
If you only use the public API (
sqlglot.parse,sqlglot.parse_one,sqlglot.transpile,sqlglot.exp.*,sqlglot.optimizer.*), most code will work without changes.
due to `fdfdfb1` - support GET_CURRENT_TIME() for DuckDB *(PR #7126 by @AbhishekASLK)*:
due to fdfdfb1 - support GET_CURRENT_TIME() for DuckDB (PR #7126 by @AbhishekASLK):
support GET_CURRENT_TIME() for DuckDB (#7126)
fdfdfb1 - duckdb: support GET_CURRENT_TIME() for DuckDB (PR #7126 by @AbhishekASLK)due to `c8ddcc3` - Annotate COLLATION(expr) for Spark/DBX *(PR #6957 by @AbhishekASLK)*:
due to c8ddcc3 - Annotate COLLATION(expr) for Spark/DBX (PR #6957 by @AbhishekASLK):
Annotate COLLATION(expr) for Spark/DBX (#6957)
due to fc4b332 - Annotate BITMAP_COUNT(expr) for Spark/DBX (PR #6956 by @AbhishekASLK):
Annotate BITMAP_COUNT(expr) for Spark/DBX (#6956)
due to 8725010 - add exp.Trunc for numeric truncation (PR #6923 by @doripo):
add exp.Trunc for numeric truncation (#6923)
due to 1418494 - Annotate FORMAT_STRING(expr) for Spark/DBX (PR #6962 by @AbhishekASLK):
Annotate FORMAT_STRING(expr) for Spark/DBX (#6962)
due to 37fa84e - support CURRENT_VERSION() transpilation for Spark (PR #6964 by @AbhishekASLK):
support CURRENT_VERSION() transpilation for Spark (#6964)
due to 51d3ebd - transpile CURRENT_VERSION() to MySQL (PR #6965 by @AbhishekASLK):
transpile CURRENT_VERSION() to MySQL (#6965)
due to 9008553 - transpile CURRENT_VERSION() to ClickHouse, Postgres, Trino, Redshift (PR #6966 by @AbhishekASLK):
transpile CURRENT_VERSION() to ClickHouse, Postgres, Trino, Redshift (#6966)
due to e8b379e - Map SQLITE_VERSION() to exp.CurrentVersion expression (PR #6967 by @AbhishekASLK):
Map SQLITE_VERSION() to exp.CurrentVersion expression (#6967)
due to dfd299f - Annotate RANDSTR(expr) for Spark/DBX (PR #6971 by @AbhishekASLK):
Annotate RANDSTR(expr) for Spark/DBX (#6971)
due to 969e45d - Annotate REPEAT(expr) for Hive, Spark, DBX (PR #6974 by @AbhishekASLK):
Annotate REPEAT(expr) for Hive, Spark, DBX (#6974)
due to ade3639 - transpilation support current_database (PR #6973 by @fivetran-ashashankar):
transpilation support current_database (#6973)
due to 57093d1 - Annotate OVERLAY(expr) for Spark/DBX (PR #6970 by @AbhishekASLK):
Annotate OVERLAY(expr) for Spark/DBX (#6970)
due to f5b2328 - Annotate RIGHT(expr) for Spark/DBX (PR #6980 by @AbhishekASLK):
Annotate RIGHT(expr) for Spark/DBX (#6980)
due to 61a0d3f - add support for JAROWINKLER_SIMILARITY (PR #6977 by @kyle-cheung):
add support for JAROWINKLER_SIMILARITY (#6977)
due to 9d1f4e0 - transpilation support current_schema (PR #6976 by @fivetran-ashashankar):
transpilation support current_schema (#6976)
due to 0d345aa - Annotate REPLACE(expr) for Hive, Spark and DBX (PR #6975 by @AbhishekASLK):
Annotate REPLACE(expr) for Hive, Spark and DBX (#6975)
due to 19f9000 - transpilation support current_version (PR #6960 by @fivetran-ashashankar):
transpilation support current_version (#6960)
due to f103a16 - support parsing VERSION() for ClickHouse (PR #6986 by @AbhishekASLK):
support parsing VERSION() for ClickHouse (#6986)
due to 2751c8f - parse support for VERSION() (PR #6985 by @AbhishekASLK):
parse support for VERSION() (#6985)
due to 37db91c - Annotate REVERSE(expr) for Hive, Spark and DBX (PR #6979 by @AbhishekASLK):
Annotate REVERSE(expr) for Hive, Spark and DBX (#6979)
due to f4d53a2 - support parsing VERSION() for Postgres/Redshift (PR #6987 by @AbhishekASLK):
support parsing VERSION() for Postgres/Redshift (#6987)
due to 71bb0c3 - support for version() for trino (PR #6988 by @AbhishekASLK):
support for version() for trino (#6988)
due to fbca704 - Annotate SPLIT(expr) for Hive/Spark/DBX (PR #6990 by @AbhishekASLK):
Annotate SPLIT(expr) for Hive/Spark/DBX (#6990)
due to 264e95f - Move TRANSLATE(expr) annotator to base (PR #6992 by @AbhishekASLK):
Move TRANSLATE(expr) annotator to base (#6992)
due to eb8ad51 - Annotate FILTER(expr, func) for Spark/DBX (PR #6995 by @AbhishekASLK):
Annotate FILTER(expr, func) for Spark/DBX (#6995)
due to 12e0869 - annotate CURRENT_TIMESTAMP for MySQL (PR #7004 by @AbhishekASLK):
annotate CURRENT_TIMESTAMP for MySQL (#7004)
due to cbdad37 - support CURTIME() for MySQL/SingleStore (PR #7005 by @AbhishekASLK):
support CURTIME() for MySQL/SingleStore (#7005)
due to d16cc62 - annotate ADD_MONTH(expr) for Hive/Spark/DBX (PR #7003 by @AbhishekASLK):
annotate ADD_MONTH(expr) for Hive/Spark/DBX (#7003)
due to 6381c48 - support NOW() for exasol (PR #7006 by @AbhishekASLK):
support NOW() for exasol (#7006)
due to d9ea168 - annotate CURRENT_USER to base (PR #7007 by @AbhishekASLK):
annotate CURRENT_USER to base (#7007)
due to 7a2a777 - annotate FROM_UTC_TIMESTAMP(expr) for Spark/DBX (PR #7008 by @AbhishekASLK):
annotate FROM_UTC_TIMESTAMP(expr) for Spark/DBX (#7008)
due to 8be32fd - support MAKE_TIMESTAMP(expr) for Spark/DBX (PR #7009 by @AbhishekASLK):
support MAKE_TIMESTAMP(expr) for Spark/DBX (#7009)
due to b951d74 - annotate NEXT_DAY(expr) for Hive/Spark/DBX (PR #7010 by @AbhishekASLK):
annotate NEXT_DAY(expr) for Hive/Spark/DBX (#7010)
due to 404797a - Move CURRENT_SCHEMA() to Base Annotator (PR #7021 by @AbhishekASLK):
Move CURRENT_SCHEMA() to Base Annotator (#7021)
due to 994d3a3 - robust STAR with EXCLUDE (redshift) (PR #6972 by @geooo109):
robust STAR with EXCLUDE (redshift) (#6972)
due to 3ea80fb - annotate REVERSE(str) for DuckDB (PR #7018 by @AbhishekASLK):
annotate REVERSE(str) for DuckDB (#7018)
due to 352fb94 - annotate ISODOW(expr) for DuckDB (PR #7016 by @AbhishekASLK):
annotate ISODOW(expr) for DuckDB (#7016)
due to c2e5954 - annotate COUNTIF(expr) for DuckDB (PR #7012 by @AbhishekASLK):
annotate COUNTIF(expr) for DuckDB (#7012)
due to e35ee14 - annotate CountIf(expr) for ClickHouse (PR #7013 by @AbhishekASLK):
annotate CountIf(expr) for ClickHouse (#7013)
due to b73be3e - support today() for duckdb (PR #7015 by @AbhishekASLK):
support today() for duckdb (#7015)
due to 36e3310 - support current_schema as no_param (PR #7000 by @AbhishekASLK):
support current_schema as no_param (#7000)
due to fd8860b - annotate FORMAT(expr) for DuckDB (PR #7017 by @AbhishekASLK):
annotate FORMAT(expr) for DuckDB (#7017)
due to eecdfa1 - Annotate DAYOFWEEK(expr), DAYOFMONTH(expr) for Hive/Spark/DBX (PR #6996 by @AbhishekASLK):
Annotate DAYOFWEEK(expr), DAYOFMONTH(expr) for Hive/Spark/DBX (#6996)
due to 4fc26f0 - annotate TIME_BUCKET(expr) for DuckDB (PR #7014 by @AbhishekASLK):
annotate TIME_BUCKET(expr) for DuckDB (#7014)
due to 00e6d9a - annotate UNIX_DATE(expr) for Spark/DBX (PR #7011 by @AbhishekASLK):
annotate UNIX_DATE(expr) for Spark/DBX (#7011)
due to 86a5509 - support user for exasol (PR #7001 by @AbhishekASLK):
support user for exasol (#7001)
due to b27c163 - support CURDATE for Exasol (PR #6999 by @AbhishekASLK):
support CURDATE for Exasol (#6999)
due to 47dc558 - annotate ARRAY_COMPACT(expr) for Spark/DBX (PR #7034 by @AbhishekASLK):
annotate ARRAY_COMPACT(expr) for Spark/DBX (#7034)
due to 9d7db06 - Generator for ARRAY_INSERT(expr) (PR #7036 by @AbhishekASLK):
Generator for ARRAY_INSERT(expr) (#7036)
due to 235b8ac - annotate ARRAY_INTERSECT(expr) for Hive/Spark/DBX (PR #7037 by @AbhishekASLK):
annotate ARRAY_INTERSECT(expr) for Hive/Spark/DBX (#7037)
due to f476d07 - update transpilation of SEQ functions and GENERATOR for DuckDB (PR #7029 by @fivetran-kwoodbeck):
update transpilation of SEQ functions and GENERATOR for DuckDB (#7029)
due to 643a6c7 - Transpilation support for Snowflake REGEXP_LIKE to DuckDB (PR #7030 by @fivetran-kwoodbeck):
Transpilation support for Snowflake REGEXP_LIKE to DuckDB (#7030)
due to b1f0542 - tokenizer optimizations (PR #7038 by @geooo109):
tokenizer optimizations (#7038)
due to 70d6f2b - annotate ARRAY_INSERT(expr) for Spark/DBX (PR #7044 by @AbhishekASLK):
annotate ARRAY_INSERT(expr) for Spark/DBX (#7044)
due to 3019d0a - Map BIT_GET to GETBIT for Spark/DBX (PR #7041 by @AbhishekASLK):
Map BIT_GET to GETBIT for Spark/DBX (#7041)
due to 27ae429 - transpile BIT_COUNT to DuckDB (PR #7039 by @AbhishekASLK):
transpile BIT_COUNT to DuckDB (#7039)
due to f6cbd27 - Add support for trigger DDL statements (PR #6978 by @fivetran-amrutabhimsenayachit):
Add support for trigger DDL statements (#6978)
due to 749cf18 - require original SQL in Parser.parse (PR #7045 by @georgesittas):
require original SQL in Parser.parse (#7045)
due to f9d1f73 - refactor colon (extract) parsing precedence (PR #7046 by @georgesittas):
refactor colon (extract) parsing precedence (#7046)
due to c5939c1 - Map curdate to current_date for Spark/DBX (PR #7048 by @AbhishekASLK):
Map curdate to current_date for Spark/DBX (#7048)
due to 58419e1 - move SessionUser to base (PR #7049 by @AbhishekASLK):
move SessionUser to base (#7049)
due to 13ee312 - use IntEnum instead of auto/string enums (PR #7050 by @georgesittas):
use IntEnum instead of auto/string enums (#7050)
due to f98cba1 - move exp.Rand to base (PR #7065 by @AbhishekASLK):
move exp.Rand to base (#7065)
due to 4f8a49c - Transpilation support for Snowflake REGEXP_COUNT to DuckDB (PR #7054 by @fivetran-kwoodbeck):
Transpilation support for Snowflake REGEXP_COUNT to DuckDB (#7054)
due to eaba8dc - move DEGREES(expr) to base (PR #7074 by @AbhishekASLK):
move DEGREES(expr) to base (#7074)
due to a87c1b4 - annotate DEGREES(expr) for T-SQL (PR #7077 by @AbhishekASLK):
annotate DEGREES(expr) for T-SQL (#7077)
due to f057a1b - move MONTHNAME to base (PR #7083 by @AbhishekASLK):
move MONTHNAME to base (#7083)
due to dd2cf85 - support UTCTimestamp (PR #7082 by @AbhishekASLK):
support UTCTimestamp (#7082)
due to 7ff13c6 - transpilation support map_contains_key (PR #7070 by @fivetran-ashashankar):
transpilation support map_contains_key (#7070)
due to 6fa494d - support arrayCompact(expr) function (PR #7084 by @AbhishekASLK):
support arrayCompact(expr) function (#7084)
due to a58c37d - transpilation of Snowflake REGEXP_REPLACE to DuckDB (PR #7078 by @fivetran-kwoodbeck):
transpilation of Snowflake REGEXP_REPLACE to DuckDB (#7078)
due to dfcd5d7 - Add Exasol reserved keywords to exasol dialect (PR #7086 by @nnamdi16):
Add Exasol reserved keywords to exasol dialect (#7086)
due to 7664358 - fix parsing error in json_value for exasol dialect (PR #7088 by @nnamdi16):
fix parsing error in json_value for exasol dialect (#7088)
due to 217e960 - annotate ARRAY_CONTAINS (PR #7099 by @geooo109):
annotate ARRAY_CONTAINS (#7099)
due to 1074d66 - transpilation of Snowflake REGEXP_INSTR to DuckDB (PR #7097 by @fivetran-kwoodbeck):
transpilation of Snowflake REGEXP_INSTR to DuckDB (#7097)
due to ab1c2ab - annotate PERCENTILE/APPROX_PERCENTILE for hive, spark2, spark, dbx (PR #7100 by @geooo109):
annotate PERCENTILE/APPROX_PERCENTILE for hive, spark2, spark, dbx (#7100)
due to 0f8287d - annotate BIT_OR(expr) for Spark/DBX (PR #7101 by @AbhishekASLK):
annotate BIT_OR(expr) for Spark/DBX (#7101)
due to e19abfd - annotate BIT_AND(expr) for Spark/DBX (PR #7103 by @AbhishekASLK):
annotate BIT_AND(expr) for Spark/DBX (#7103)
due to 0c4f74f - parse and annotate ELEMENT_AT for spark2, spark, dbx (PR #7104 by @geooo109):
parse and annotate ELEMENT_AT for spark2, spark, dbx (#7104)
due to 8b8aef0 - annotate BIT_XOR(expr) for Spark/DBX (PR #7106 by @AbhishekASLK):
annotate BIT_XOR(expr) for Spark/DBX (#7106)
due to 1b1d57a - transpilation of Snowflake REGEXP_SUBSTR and REGEXP_SUBSTR_ALL to DuckDB (PR #7095 by @fivetran-kwoodbeck):
transpilation of Snowflake REGEXP_SUBSTR and REGEXP_SUBSTR_ALL to DuckDB (#7095)
due to 4f964db - remove prefix from data type and cleanup (commit by @tobymao):
remove prefix from data type and cleanup
due to 0858599 - support arrayConcat to clickhouse (PR #7108 by @AbhishekASLK):
support arrayConcat to clickhouse (#7108)
due to 73ab9af - support arrayDistinct(expr) for clickhouse (PR #7114 by @AbhishekASLK):
support arrayDistinct(expr) for clickhouse (#7114)
due to 37fa8c7 - Split core functionality to TokenizerCore (PR #7116 by @VaggelisD):
Split core functionality to TokenizerCore (#7116)
due to 1150e39 - expression_core which is now compilable by mypyc (PR #7117 by @tobymao):
expression_core which is now compilable by mypyc (#7117)
due to f796956 - annotate ArrayDistinct for Hive/Spark/DBX (PR #7119 by @AbhishekASLK):
annotate ArrayDistinct for Hive/Spark/DBX (#7119)
due to 2069b06 - annotate ARRAY_EXCEPT for Hive/Spark/DBX (PR #7123 by @AbhishekASLK):
annotate ARRAY_EXCEPT for Hive/Spark/DBX (#7123)
due to 5a30754 - support current_localtimestamp() for DuckDB (PR #7128 by @AbhishekASLK):
support current_localtimestamp() for DuckDB (#7128)
due to 93bf337 - annotate date_diff(expr) for DuckDB (PR #7125 by @AbhishekASLK):
annotate date_diff(expr) for DuckDB (#7125)
c8ddcc3 - optimizer: Annotate COLLATION(expr) for Spark/DBX (PR #6957 by @AbhishekASLK)fc4b332 - optimizer: Annotate BITMAP_COUNT(expr) for Spark/DBX (PR #6956 by @AbhishekASLK)8725010 - add exp.Trunc for numeric truncation (PR #6923 by @doripo)1418494 - optimizer: Annotate FORMAT_STRING(expr) for Spark/DBX (PR #6962 by @AbhishekASLK)ff1fd52 - generator: Add numeric TRUNC output for additional dialects (PR #6961 by @doripo)37fa84e - snowflake: support CURRENT_VERSION() transpilation for Spark (PR #6964 by @AbhishekASLK)51d3ebd - snowflake: transpile CURRENT_VERSION() to MySQL (PR #6965 by @AbhishekASLK)9008553 - snowflake: transpile CURRENT_VERSION() to ClickHouse, Postgres, Trino, Redshift (PR #6966 by @AbhishekASLK)e8b379e - sqlite: Map SQLITE_VERSION() to exp.CurrentVersion expression (PR #6967 by @AbhishekASLK)dfd299f - optimizer: Annotate RANDSTR(expr) for Spark/DBX (PR #6971 by @AbhishekASLK)969e45d - optimizer: Annotate REPEAT(expr) for Hive, Spark, DBX (PR #6974 by @AbhishekASLK)ade3639 - snowflake: transpilation support current_database (PR #6973 by @fivetran-ashashankar)57093d1 - optimizer: Annotate OVERLAY(expr) for Spark/DBX (PR #6970 by @AbhishekASLK)f5b2328 - optimizer: Annotate RIGHT(expr) for Spark/DBX (PR #6980 by @AbhishekASLK)61a0d3f - snowflake: add support for JAROWINKLER_SIMILARITY (PR #6977 by @kyle-cheung)9d1f4e0 - snowflake: transpilation support current_schema (PR #6976 by @fivetran-ashashankar)0d345aa - optimizer: Annotate REPLACE(expr) for Hive, Spark and DBX (PR #6975 by @AbhishekASLK)19f9000 - snowflake: transpilation support current_version (PR #6960 by @fivetran-ashashankar)f103a16 - optimizer: support parsing VERSION() for ClickHouse (PR #6986 by @AbhishekASLK)2751c8f - mysql: parse support for VERSION() (PR #6985 by @AbhishekASLK)37db91c - optimizer: Annotate REVERSE(expr) for Hive, Spark and DBX (PR #6979 by @AbhishekASLK)f4d53a2 - postgres: support parsing VERSION() for Postgres/Redshift (PR #6987 by @AbhishekASLK)71bb0c3 - trino: support for version() for trino (PR #6988 by @AbhishekASLK)fbca704 - optimizer: Annotate SPLIT(expr) for Hive/Spark/DBX (PR #6990 by @AbhishekASLK)264e95f - optimizer: Move TRANSLATE(expr) annotator to base (PR #6992 by @AbhishekASLK)eb8ad51 - optimizer: Annotate FILTER(expr, func) for Spark/DBX (PR #6995 by @AbhishekASLK)12e0869 - optimizer: annotate CURRENT_TIMESTAMP for MySQL (PR #7004 by @AbhishekASLK)cbdad37 - mysql: support CURTIME() for MySQL/SingleStore (PR #7005 by @AbhishekASLK)d16cc62 - optimizer: annotate ADD_MONTH(expr) for Hive/Spark/DBX (PR #7003 by @AbhishekASLK)6381c48 - exasol: support NOW() for exasol (PR #7006 by @AbhishekASLK)d9ea168 - optimizer: annotate CURRENT_USER to base (PR #7007 by @AbhishekASLK)7a2a777 - optimizer: annotate FROM_UTC_TIMESTAMP(expr) for Spark/DBX (PR #7008 by @AbhishekASLK)8be32fd - spark: support MAKE_TIMESTAMP(expr) for Spark/DBX (PR #7009 by @AbhishekASLK)b951d74 - optimizer: annotate NEXT_DAY(expr) for Hive/Spark/DBX (PR #7010 by @AbhishekASLK)404797a - optimizer: Move CURRENT_SCHEMA() to Base Annotator (PR #7021 by @AbhishekASLK)994d3a3 - parser: robust STAR with EXCLUDE (redshift) (PR #6972 by @geooo109)
3ea80fb - optimizer: annotate REVERSE(str) for DuckDB (PR #7018 by @AbhishekASLK)352fb94 - optimizer: annotate ISODOW(expr) for DuckDB (PR #7016 by @AbhishekASLK)c2e5954 - optimizer: annotate COUNTIF(expr) for DuckDB (PR #7012 by @AbhishekASLK)e35ee14 - optimizer: annotate CountIf(expr) for ClickHouse (PR #7013 by @AbhishekASLK)6971c17 - snowflake: support aliases in semantic view dimensions (PR #6994 by @georgesittas)
b73be3e - duckdb: support today() for duckdb (PR #7015 by @AbhishekASLK)36e3310 - exasol: support current_schema as no_param (PR #7000 by @AbhishekASLK)fd8860b - optimizer: annotate FORMAT(expr) for DuckDB (PR #7017 by @AbhishekASLK)eecdfa1 - optimizer: Annotate DAYOFWEEK(expr), DAYOFMONTH(expr) for Hive/Spark/DBX (PR #6996 by @AbhishekASLK)4fc26f0 - optimizer: annotate TIME_BUCKET(expr) for DuckDB (PR #7014 by @AbhishekASLK)00e6d9a - optimizer: annotate UNIX_DATE(expr) for Spark/DBX (PR #7011 by @AbhishekASLK)86a5509 - exasol: support user for exasol (PR #7001 by @AbhishekASLK)b27c163 - optimizer: support CURDATE for Exasol (PR #6999 by @AbhishekASLK)47dc558 - optimizer: annotate ARRAY_COMPACT(expr) for Spark/DBX (PR #7034 by @AbhishekASLK)235b8ac - optimizer: annotate ARRAY_INTERSECT(expr) for Hive/Spark/DBX (PR #7037 by @AbhishekASLK)643a6c7 - snowflake: Transpilation support for Snowflake REGEXP_LIKE to DuckDB (PR #7030 by @fivetran-kwoodbeck)70d6f2b - optimizer: annotate ARRAY_INSERT(expr) for Spark/DBX (PR #7044 by @AbhishekASLK)1011fca - duckdb: transpile Snowflake's current_schemas (PR #7042 by @fivetran-ashashankar)3019d0a - spark: Map BIT_GET to GETBIT for Spark/DBX (PR #7041 by @AbhishekASLK)27ae429 - spark: transpile BIT_COUNT to DuckDB (PR #7039 by @AbhishekASLK)f6cbd27 - postgres: Add support for trigger DDL statements (PR #6978 by @fivetran-amrutabhimsenayachit)
c5939c1 - spark: Map curdate to current_date for Spark/DBX (PR #7048 by @AbhishekASLK)58419e1 - optimizer: move SessionUser to base (PR #7049 by @AbhishekASLK)3c67ec0 - duckdb: Add traspilation support for NULL values in ARRAY_CONTAINS function (PR #7055 by @fivetran-amrutabhimsenayachit)f98cba1 - optimizer: move exp.Rand to base (PR #7065 by @AbhishekASLK)4f8a49c - snowflake: Transpilation support for Snowflake REGEXP_COUNT to DuckDB (PR #7054 by @fivetran-kwoodbeck)eaba8dc - optimizer: move DEGREES(expr) to base (PR #7074 by @AbhishekASLK)a87c1b4 - optimizer: annotate DEGREES(expr) for T-SQL (PR #7077 by @AbhishekASLK)f057a1b - optimizer: move MONTHNAME to base (PR #7083 by @AbhishekASLK)dd2cf85 - clickhouse: support UTCTimestamp (PR #7082 by @AbhishekASLK)7ff13c6 - snowflake: transpilation support map_contains_key (PR #7070 by @fivetran-ashashankar)6fa494d - clickhouse: support arrayCompact(expr) function (PR #7084 by @AbhishekASLK)a58c37d - snowflake: transpilation of Snowflake REGEXP_REPLACE to DuckDB (PR #7078 by @fivetran-kwoodbeck)3a453d0 - duckdb: Add transpilation support for NULLs in ARRAY_DISTINCT (PR #7069 by @fivetran-amrutabhimsenayachit)dfcd5d7 - exasol: Add Exasol reserved keywords to exasol dialect (PR #7086 by @nnamdi16)b569a3d - DuckDb: Add transpilation support for ARRAY_MAX and ARRAY_MIN functions (PR #7080 by @fivetran-amrutabhimsenayachit)1074d66 - snowflake: transpilation of Snowflake REGEXP_INSTR to DuckDB (PR #7097 by @fivetran-kwoodbeck)ab1c2ab - optimizer: annotate PERCENTILE/APPROX_PERCENTILE for hive, spark2, spark, dbx (PR #7100 by @geooo109)
0f8287d - optimizer: annotate BIT_OR(expr) for Spark/DBX (PR #7101 by @AbhishekASLK)e19abfd - optimizer: annotate BIT_AND(expr) for Spark/DBX (PR #7103 by @AbhishekASLK)0c4f74f - optimizer: parse and annotate ELEMENT_AT for spark2, spark, dbx (PR #7104 by @geooo109)
8b8aef0 - optimizer: annotate BIT_XOR(expr) for Spark/DBX (PR #7106 by @AbhishekASLK)ce09e81 - DuckDB: Enable transpilation for ARRAY_EXCEPT function (PR #7094 by @fivetran-amrutabhimsenayachit)1b1d57a - snowflake: transpilation of Snowflake REGEXP_SUBSTR and REGEXP_SUBSTR_ALL to DuckDB (PR #7095 by @fivetran-kwoodbeck)0858599 - clickhouse: support arrayConcat to clickhouse (PR #7108 by @AbhishekASLK)9100ea7 - parser: support DECLARE spark, dbx (PR #7113 by @geooo109)
73ab9af - clickhouse: support arrayDistinct(expr) for clickhouse (PR #7114 by @AbhishekASLK)f796956 - optimizer: annotate ArrayDistinct for Hive/Spark/DBX (PR #7119 by @AbhishekASLK)2069b06 - optimizer: annotate ARRAY_EXCEPT for Hive/Spark/DBX (PR #7123 by @AbhishekASLK)5a30754 - duckdb: support current_localtimestamp() for DuckDB (PR #7128 by @AbhishekASLK)836cc60 - parser: Limit named PK parsing to MySQL only (PR #6991 by @VaggelisD)
495920e - snowflake: Parse MODIFY as ALTER in ALTER TABLE (PR #7024 by @VaggelisD)
1e753a3 - parser: parse cast argument using _parse_assignment closes #7027 (commit by @georgesittas)67e47a4 - Support missing meta when updating position metadata for an expression (PR #7032 by @izeigerman)9bffc99 - snowflake: wrap jarowinkler similarity in UPPER for case-insensitivty (PR #7022 by @kyle-cheung)9d7db06 - spark: Generator for ARRAY_INSERT(expr) (PR #7036 by @AbhishekASLK)
f476d07 - duckdb: update transpilation of SEQ functions and GENERATOR for DuckDB (PR #7029 by @fivetran-kwoodbeck)
aa14297 - duckdb: transpile LATERAL VIEW INLINE from spark to DuckDB (PR #7033 by @fivetran-felixhuang)f9d1f73 - snowflake: refactor colon (extract) parsing precedence (PR #7046 by @georgesittas)5ef8bef - bigquery: Parse & generate table alias before its version (PR #7075 by @VaggelisD)
bd4db6b - parser: INTERVAL units with DCOLON (PR #7076 by @geooo109)
7664358 - exasol: fix parsing error in json_value for exasol dialect (PR #7088 by @nnamdi16)af8c3e9 - missing comments in subquery (commit by @tobymao)217e960 - optimizer: annotate ARRAY_CONTAINS (PR #7099 by @geooo109)3ff4e0d - deploy: Fix _version not exists (PR #7129 by @VaggelisD)93bf337 - optimizer: annotate date_diff(expr) for DuckDB (PR #7125 by @AbhishekASLK)4a38462 - deploy: Use GA ARM machine (PR #7131 by @VaggelisD)a8aa371 - improve DataType.build perf by removing unnecessary constructor (PR #7092 by @georgesittas)f12a58f - extract Column instance check out of _set_type in annotate_types (PR #7091 by @georgesittas)ddbf64c - optimize large query performance in optimizer pipeline (PR #7090 by @sabrikaragonen)
749cf18 - require original SQL in Parser.parse (PR #7045 by @georgesittas)
13ee312 - use IntEnum instead of auto/string enums (PR #7050 by @georgesittas)4f964db - remove prefix from data type and cleanup (commit by @tobymao)1150e39 - expression_core which is now coNothing published for this version
due to `55698db` - Annotate MAKE_TIME(expr) for DuckDB *(PR #6931 by @AbhishekASLK)*:
due to 55698db - Annotate MAKE_TIME(expr) for DuckDB (PR #6931 by @AbhishekASLK):
Annotate MAKE_TIME(expr) for DuckDB (#6931)
due to e750ce7 - Transpilation for SHA2 and SHA2_BINARY from Snowflake to DuckDB (PR #6929 by @fivetran-kwoodbeck):
Transpilation for SHA2 and SHA2_BINARY from Snowflake to DuckDB (#6929)
due to 9b05968 - Annotate BIT_LENGTH(expr) for DuckDB (PR #6932 by @AbhishekASLK):
Annotate BIT_LENGTH(expr) for DuckDB (#6932)
due to 2050362 - Annotate LENGTH(expr) for DuckDB (PR #6937 by @AbhishekASLK):
Annotate LENGTH(expr) for DuckDB (#6937)
due to e803c7f - Moved SIN, COS, TAN, COT to Base (PR #6936 by @AbhishekASLK):
Moved SIN, COS, TAN, COT to Base (#6936)
due to 973d25d - support transpilation of ARRAY_REMOVE_AT (PR #6930 by @fivetran-MichaelLee):
support transpilation of ARRAY_REMOVE_AT (#6930)
due to 2e2ff03 - Refactor RPAD/LPAD (PR #6869 by @fivetran-ashashankar):
Refactor RPAD/LPAD (#6869)
due to 62aeff8 - Annotate CURRENT_CATALOG to Base (PR #6940 by @AbhishekASLK):
Annotate CURRENT_CATALOG to Base (#6940)
due to 04002ae - transpile NTH_VALUE from Snowflake to DuckDB (PR #6882 by @fivetran-felixhuang):
transpile NTH_VALUE from Snowflake to DuckDB (#6882)
due to bdce7c7 - Annotate DAYOFMONTH(expr), DAYOFYEAR(expr) for MySQL (PR #6941 by @AbhishekASLK):
Annotate DAYOFMONTH(expr), DAYOFYEAR(expr) for MySQL (#6941)
due to edbbb59 - Annotate WEEK(expr) for MySQL (PR #6942 by @AbhishekASLK):
Annotate WEEK(expr) for MySQL (#6942)
due to ccb484b - Annotate HOUR(expr) for MySQL, Hive, Spark, DBX (PR #6943 by @AbhishekASLK):
Annotate HOUR(expr) for MySQL, Hive, Spark, DBX (#6943)
due to 852adec - Move MD5(expr) to Base (PR #6944 by @AbhishekASLK):
Move MD5(expr) to Base (#6944)
due to 2326eae - Move ASIN, ACOS, ATAN to Base (PR #6945 by @AbhishekASLK):
Move ASIN, ACOS, ATAN to Base (#6945)
due to 7989906 - Move ASINH, ACOSH, ATANH to Base (PR #6946 by @AbhishekASLK):
Move ASINH, ACOSH, ATANH to Base (#6946)
due to 713d22f - Annotate LENGTH, LEVENSHTEIN_DISTANCE for Presto/Trino (PR #6947 by @AbhishekASLK):
Annotate LENGTH, LEVENSHTEIN_DISTANCE for Presto/Trino (#6947)
due to 0e872dc - Annotate POSITION and STRPOS for Trino/Presto (PR #6948 by @AbhishekASLK):
Annotate POSITION and STRPOS for Trino/Presto (#6948)
due to d01657a - Annotate WIDTH_BUCKET(expr) for Presto/Trino (PR #6950 by @AbhishekASLK):
Annotate WIDTH_BUCKET(expr) for Presto/Trino (#6950)
due to cec0f27 - Annotate BITWISE OPERATORS for Presto/Trino (PR #6951 by @AbhishekASLK):
Annotate BITWISE OPERATORS for Presto/Trino (#6951)
due to 2292d0d - Move SINH, COSH, TANH to Base (PR #6954 by @AbhishekASLK):
Move SINH, COSH, TANH to Base (#6954)
due to 686ab6a - Use replace instead of set for JSON dot access identifiers (PR #6953 by @georgesittas):
Use replace instead of set for JSON dot access identifiers (#6953)
55698db - optimizer: Annotate MAKE_TIME(expr) for DuckDB (PR #6931 by @AbhishekASLK)e750ce7 - snowflake: Transpilation for SHA2 and SHA2_BINARY from Snowflake to DuckDB (PR #6929 by @fivetran-kwoodbeck)9b05968 - optimizer: Annotate BIT_LENGTH(expr) for DuckDB (PR #6932 by @AbhishekASLK)2050362 - optimizer: Annotate LENGTH(expr) for DuckDB (PR #6937 by @AbhishekASLK)e803c7f - optimizer: Moved SIN, COS, TAN, COT to Base (PR #6936 by @AbhishekASLK)973d25d - duckdb: support transpilation of ARRAY_REMOVE_AT (PR #6930 by @fivetran-MichaelLee)2e2ff03 - snowflake: Refactor RPAD/LPAD (PR #6869 by @fivetran-ashashankar)62aeff8 - optimizer: Annotate CURRENT_CATALOG to Base (PR #6940 by @AbhishekASLK)04002ae - snowflake: transpile NTH_VALUE from Snowflake to DuckDB (PR #6882 by @fivetran-felixhuang)ccb484b - optimizer: Annotate HOUR(expr) for MySQL, Hive, Spark, DBX (PR #6943 by @AbhishekASLK)852adec - optimizer: Move MD5(expr) to Base (PR #6944 by @AbhishekASLK)2326eae - optimizer: Move ASIN, ACOS, ATAN to Base (PR #6945 by @AbhishekASLK)7989906 - optimizer: Move ASINH, ACOSH, ATANH to Base (PR #6946 by @AbhishekASLK)713d22f - optimizer: Annotate LENGTH, LEVENSHTEIN_DISTANCE for Presto/Trino (PR #6947 by @AbhishekASLK)0e872dc - optimizer: Annotate POSITION and STRPOS for Trino/Presto (PR #6948 by @AbhishekASLK)d01657a - optimizer: Annotate WIDTH_BUCKET(expr) for Presto/Trino (PR #6950 by @AbhishekASLK)cec0f27 - optimizer: Annotate BITWISE OPERATORS for Presto/Trino (PR #6951 by @AbhishekASLK)2292d0d - optimizer: Move SINH, COSH, TANH to Base (PR #6954 by @AbhishekASLK)12c7cf4 - dremio: Generate exp.TryCast as CAST (PR #6928 by @VaggelisD)
087f70b - tsql: datepart when part is quoted (PR #6934 by @flow3d)bdce7c7 - optimizer: Annotate DAYOFMONTH(expr), DAYOFYEAR(expr) for MySQL (PR #6941 by @AbhishekASLK)edbbb59 - optimizer: Annotate WEEK(expr) for MySQL (PR #6942 by @AbhishekASLK)686ab6a - optimizer: Use replace instead of set for JSON dot access identifiers (PR #6953 by @georgesittas)due to `e9ff474` - Annotate MINUTE, MONTH for DuckDB *(PR #6919 by @AbhishekASLK)*:
due to e9ff474 - Annotate MINUTE, MONTH for DuckDB (PR #6919 by @AbhishekASLK):
Annotate MINUTE, MONTH for DuckDB (#6919)
due to 96dc339 - Annotate DAYOFWEEK, DAYOFYEAR for DuckDB (PR #6920 by @AbhishekASLK):
Annotate DAYOFWEEK, DAYOFYEAR for DuckDB (#6920)
due to b56f685 - Annotate DAY, HOUR, SECOND and DAYOFMONTH (PR #6922 by @AbhishekASLK):
Annotate DAY, HOUR, SECOND and DAYOFMONTH (#6922)
due to 6e418ec - Annotate EPOCH(expr) for DuckDB (PR #6924 by @AbhishekASLK):
Annotate EPOCH(expr) for DuckDB (#6924)
due to abd8d1b - Transpilation of SHA1 from Snowflake to DuckDB (PR #6888 by @fivetran-kwoodbeck):
Transpilation of SHA1 from Snowflake to DuckDB (#6888)
due to b2f5430 - Annotate TO_DAYS(expr) for DuckDB (PR #6925 by @AbhishekASLK):
Annotate TO_DAYS(expr) for DuckDB (#6925)
e9ff474 - optimizer: Annotate MINUTE, MONTH for DuckDB (PR #6919 by @AbhishekASLK)96dc339 - optimizer: Annotate DAYOFWEEK, DAYOFYEAR for DuckDB (PR #6920 by @AbhishekASLK)b56f685 - optimizer: Annotate DAY, HOUR, SECOND and DAYOFMONTH (PR #6922 by @AbhishekASLK)6e418ec - optimizer: Annotate EPOCH(expr) for DuckDB (PR #6924 by @AbhishekASLK)abd8d1b - snowflake: Transpilation of SHA1 from Snowflake to DuckDB (PR #6888 by @fivetran-kwoodbeck)b2f5430 - optimizer: Annotate TO_DAYS(expr) for DuckDB (PR #6925 by @AbhishekASLK)dfb2d3b - generate API docs before checking out api-docs branch (PR #6921 by @georgesittas)due to `9d2a12a` - Annotate SIN for DuckDB *(PR #6892 by @AbhishekASLK)*:
due to 9d2a12a - Annotate SIN for DuckDB (PR #6892 by @AbhishekASLK):
Annotate SIN for DuckDB (#6892)
due to d8e13ae - Annotate COS for DuckDB (PR #6893 by @AbhishekASLK):
Annotate COS for DuckDB (#6893)
due to 25f718c - Annotate STUFF for TSQL (PR #6890 by @AbhishekASLK):
Annotate STUFF for TSQL (#6890)
due to bec45a5 - Annotate ISINF(expr) for DuckDB (PR #6894 by @AbhishekASLK):
Annotate ISINF(expr) for DuckDB (#6894)
due to aab8243 - Annotate ISNAN(expr) for Base (PR #6895 by @AbhishekASLK):
Annotate ISNAN(expr) for Base (#6895)
due to 482128e - Annotate TAN for DuckDB (PR #6896 by @AbhishekASLK):
Annotate TAN for DuckDB (#6896)
due to a6d7f6e - Annotate COT for DuckDB (PR #6897 by @AbhishekASLK):
Annotate COT for DuckDB (#6897)
due to 2ec7c2b - Annotate RANDOM() for DuckDB (PR #6898 by @AbhishekASLK):
Annotate RANDOM() for DuckDB (#6898)
due to a0b053d - Annotate ATAN(expr) for DuckDB (PR #6900 by @AbhishekASLK):
Annotate ATAN(expr) for DuckDB (#6900)
due to f39b514 - Annotate ASIN(expr) for DuckDB (PR #6901 by @AbhishekASLK):
Annotate ASIN(expr) for DuckDB (#6901)
due to 5fb98a1 - Annotate ACOS(expr) for DuckDB (PR #6902 by @AbhishekASLK):
Annotate ACOS(expr) for DuckDB (#6902)
due to 9e95d95 - Annotate ASINH(expr), ACOSH(expr), ATANH(expr) for DuckDB (PR #6903 by @AbhishekASLK):
Annotate ASINH(expr), ACOSH(expr), ATANH(expr) for DuckDB (#6903)
due to a8fef30 - Annotate DEGREES(expr) for MySQL (PR #6913 by @AbhishekASLK):
Annotate DEGREES(expr) for MySQL (#6913)
due to 887d03a - Annotate arc trignometric func for MySQL (PR #6912 by @AbhishekASLK):
Annotate arc trignometric func for MySQL (#6912)
due to dc6bc5a - Annotate SIN, COS, TAN, COT for MySQL (PR #6911 by @AbhishekASLK):
Annotate SIN, COS, TAN, COT for MySQL (#6911)
due to 6cae76f - Annotate SECOND(expr) to INT (PR #6910 by @AbhishekASLK):
Annotate SECOND(expr) to INT (#6910)
due to bd595a6 - Annotate QUARTER(expr) for DuckDB (PR #6905 by @AbhishekASLK):
Annotate QUARTER(expr) for DuckDB (#6905)
due to 8e625b5 - Annotate ATAN2 for DuckDB (PR #6904 by @AbhishekASLK):
Annotate ATAN2 for DuckDB (#6904)
due to ea678d2 - support transpilation of CURRENT_TIME from snowflake to duckdb (PR #6909 by @fivetran-felixhuang):
support transpilation of CURRENT_TIME from snowflake to duckdb (#6909)
due to 8e4f4b3 - Annotate QUARTER(expr) to INT instead of TINYINT (PR #6906 by @AbhishekASLK):
Annotate QUARTER(expr) to INT instead of TINYINT (#6906)
due to a94e45a - Annotate MONTH(expr) to INT instead of TINYINT (PR #6907 by @AbhishekASLK):
Annotate MONTH(expr) to INT instead of TINYINT (#6907)
due to db51b75 - Moved YEAR, QUARTER, WEEK to snowflake (PR #6918 by @AbhishekASLK):
Moved YEAR, QUARTER, WEEK to snowflake (#6918)
9d2a12a - duckdb: Annotate SIN for DuckDB (PR #6892 by @AbhishekASLK)d8e13ae - optimizer: Annotate COS for DuckDB (PR #6893 by @AbhishekASLK)25f718c - tsql: Annotate STUFF for TSQL (PR #6890 by @AbhishekASLK)bec45a5 - optimizer: Annotate ISINF(expr) for DuckDB (PR #6894 by @AbhishekASLK)aab8243 - optimmizer: Annotate ISNAN(expr) for Base (PR #6895 by @AbhishekASLK)482128e - optimizer: Annotate TAN for DuckDB (PR #6896 by @AbhishekASLK)a6d7f6e - optimizer: Annotate COT for DuckDB (PR #6897 by @AbhishekASLK)2ec7c2b - optimizer: Annotate RANDOM() for DuckDB (PR #6898 by @AbhishekASLK)a0b053d - optimizer: Annotate ATAN(expr) for DuckDB (PR #6900 by @AbhishekASLK)f39b514 - optimmizer: Annotate ASIN(expr) for DuckDB (PR #6901 by @AbhishekASLK)5fb98a1 - optimizer: Annotate ACOS(expr) for DuckDB (PR #6902 by @AbhishekASLK)9e95d95 - optimizer: Annotate ASINH(expr), ACOSH(expr), ATANH(expr) for DuckDB (PR #6903 by @AbhishekASLK)a8fef30 - optimizer: Annotate DEGREES(expr) for MySQL (PR #6913 by @AbhishekASLK)887d03a - optimizer: Annotate arc trignometric func for MySQL (PR #6912 by @AbhishekASLK)dc6bc5a - optimizer: Annotate SIN, COS, TAN, COT for MySQL (PR #6911 by @AbhishekASLK)6cae76f - mysql: Annotate SECOND(expr) to INT (PR #6910 by @AbhishekASLK)bd595a6 - optimizer: Annotate QUARTER(expr) for DuckDB (PR #6905 by @AbhishekASLK)8e625b5 - optimizer: Annotate ATAN2 for DuckDB (PR #6904 by @AbhishekASLK)ea678d2 - snowflake: support transpilation of CURRENT_TIME from snowflake to duckdb (PR #6909 by @fivetran-felixhuang)db51b75 - optimizer: Moved YEAR, QUARTER, WEEK to snowflake (PR #6918 by @AbhishekASLK)8e4f4b3 - optimizer: Annotate QUARTER(expr) to INT instead of TINYINT (PR #6906 by @AbhishekASLK)a94e45a - mysql: Annotate MONTH(expr) to INT instead of TINYINT (PR #6907 by @AbhishekASLK)1fd5914 - parser: Literal number strings (PR #6916 by @geooo109)
0a065be - postgres: Allow reserved tokens too in EXCLUDE WITH constraint (PR #6917 by @VaggelisD)
a65c870 - add CLAUDE.md to document guidelines for SQLGlot coding (PR #6899 by @fivetran-kwoodbeck)due to `ed4ba08` - add support for Bitwise NOT *(PR #6740 by @AbhishekASLK)*:
due to ed4ba08 - add support for Bitwise NOT (PR #6740 by @AbhishekASLK):
add support for Bitwise NOT (#6740)
due to 894c581 - annotate cot for spark and dbx (PR #6739 by @AbhishekASLK):
annotate cot for spark and dbx (#6739)
due to cc18c55 - add COSH function annotation for Hive and related dialects (PR #6738 by @AbhishekASLK):
add COSH function annotation for Hive and related dialects (#6738)
due to 03dd8bd - add SINH function annotation for Hive and related dialects (PR #6736 by @AbhishekASLK):
add SINH function annotation for Hive and related dialects (#6736)
due to 1c9cf7b - annotate snowflake ARRAY_COMPACT (PR #6735 by @fivetran-MichaelLee):
annotate snowflake ARRAY_COMPACT (#6735)
due to 9b1a634 - cast APPROX_QUANTILE results to DOUBLE to respect Snowflake's typing during transpilation (PR #6734 by @fivetran-BradfordPaskewitz):
cast APPROX_QUANTILE results to DOUBLE to respect Snowflake's typing during transpilation (#6734)
due to f644541 - add TO_BINARY function annotation for Spark and DBX dialect (PR #6743 by @AbhishekASLK):
add TO_BINARY function annotation for Spark and DBX dialect (#6743)
due to aeaa43d - Preserve key name in STRUCT for all identifiers (PR #6744 by @VaggelisD):
Preserve key name in STRUCT for all identifiers (#6744)
due to 27a7b68 - add annotation for ACOS function (PR #6747 by @AbhishekASLK):
add annotation for ACOS function (#6747)
due to 7b5279c - Fix optimizer for generate series (PR #6679 by @chrisqu777):
Fix optimizer for generate series (#6679)
due to a5ccfbb - add SHA function annotations for Hive (PR #6750 by @AbhishekASLK):
add SHA function annotations for Hive (#6750)
due to 2191273 - Transpilation support for Snowflake's BITMAP_CONSTRUCT_AGG function to DuckDB (PR #6745 by @fivetran-kwoodbeck):
Transpilation support for Snowflake's BITMAP_CONSTRUCT_AGG function to DuckDB (#6745)
due to ee0b213 - Annotate RANDN function for Spark and DBX (PR #6751 by @AbhishekASLK):
Annotate RANDN function for Spark and DBX (#6751)
due to e643817 - Annotate SPACE function to Hive (PR #6752 by @AbhishekASLK):
Annotate SPACE function to Hive (#6752)
due to 48336d0 - Exclude table-valued functions from unnest_subqueries (PR #6755 by @VaggelisD):
Exclude table-valued functions from unnest_subqueries (#6755)
due to 6befad0 - Annotate BIT_LENGTH for Spark and DBX (PR #6754 by @AbhishekASLK):
Annotate BIT_LENGTH for Spark and DBX (#6754)
due to 076058d - Annotate SHA1 and SHA256 function for DuckDB (PR #6753 by @AbhishekASLK):
Annotate SHA1 and SHA256 function for DuckDB (#6753)
due to ff1b5da - Annotate KURTOSIS function (PR #6757 by @AbhishekASLK):
Annotate KURTOSIS function (#6757)
due to af008bd - Annotate SIN, COS, TAN for Hive and inherited dialects (PR #6759 by @AbhishekASLK):
Annotate SIN, COS, TAN for Hive and inherited dialects (#6759)
due to 700fbe9 - Annotate CORR for Hive and inherited dialects (PR #6769 by @AbhishekASLK):
Annotate CORR for Hive and inherited dialects (#6769)
due to b87be58 - Annotate SEC for Spark and DBX (PR #6768 by @AbhishekASLK):
Annotate SEC for Spark and DBX (#6768)
due to 5a594ed - Annotate ATANH for Spark and DBX (PR #6767 by @AbhishekASLK):
Annotate ATANH for Spark and DBX (#6767)
due to 1f9672f - Annotate ATAN for Hive and inherited dialects (PR #6766 by @AbhishekASLK):
Annotate ATAN for Hive and inherited dialects (#6766)
due to 38d6816 - Support type inference for BQ SAFE functions (PR #6765 by @fivetran-BradfordPaskewitz):
Support type inference for BQ SAFE functions (#6765)
due to c89a127 - Implements transpilation for IS_NULL_VALUE (PR #6756 by @fivetran-ashashankar):
Implements transpilation for IS_NULL_VALUE (#6756)
due to 428d676 - avoid redundant cast when transpiling trunc from snowflake (PR #6771 by @georgesittas):
avoid redundant cast when transpiling trunc from snowflake (#6771)
due to 8163ffa - Implements transpilation for Snowflake's EQUAL_NULL (PR #6763 by @fivetran-ashashankar):
Implements transpilation for Snowflake's EQUAL_NULL (#6763)
due to 4c01cbe - Annotate CBRT for Hive and inherited dialects (PR #6772 by @AbhishekASLK):
Annotate CBRT for Hive and inherited dialects (#6772)
due to 237aec0 - Annotate CURRENT_CATALOG() for Hive, Spark, and DBX (PR #6773 by @AbhishekASLK):
Annotate CURRENT_CATALOG() for Hive, Spark, and DBX (#6773)
due to 82d533e - Annotate CURRENT_DATABASE() for Hive, Spark and DBX (PR #6774 by @AbhishekASLK):
Annotate CURRENT_DATABASE() for Hive, Spark and DBX (#6774)
due to 69c874f - properly support safe functions (PR #6775 by @georgesittas):
properly support safe functions (#6775)
due to b5674f6 - robust correlated subqueries annotation (PR #6764 by @geooo109):
robust correlated subqueries annotation (#6764)
due to 8634a8a - Added Snowflake to DuckDB transpilation for EXTRACT (PR #6706 by @fivetran-kwoodbeck):
Added Snowflake to DuckDB transpilation for EXTRACT (#6706)
due to 8cda928 - ARRAY_APPEND null propagation (PR #6762 by @fivetran-MichaelLee):
ARRAY_APPEND null propagation (#6762)
due to 2ab4376 - Annotate CURRENT_USER() for Hive, Spark and DBX (PR #6790 by @AbhishekASLK):
Annotate CURRENT_USER() for Hive, Spark and DBX (#6790)
due to ee08d77 - resolve parsing issue in substr with FROM/FOR syntax (PR #6791 by @AbhishekASLK):
resolve parsing issue in substr with FROM/FOR syntax (#6791)
due to fca6a94 - Annotate CURRENT_SCHEMA() for Hive, Spark and DBX (PR #6792 by @AbhishekASLK):
Annotate CURRENT_SCHEMA() for Hive, Spark and DBX (#6792)
due to d6ecc73 - add support for grouping_id() (PR #6793 by @AbhishekASLK):
add support for grouping_id() (#6793)
due to 7f4a150 - parse and annotate bq NET.REG_DOMAIN (PR #6777 by @geooo109):
parse and annotate bq NET.REG_DOMAIN (#6777)
due to ce0bbcf - Annotate MONTHNAME for Spark and DBX (PR #6794 by @AbhishekASLK):
Annotate MONTHNAME for Spark and DBX (#6794)
due to bc0a43c - Annotate MONTH for Hive, Spark and DBX (PR #6795 by @AbhishekASLK):
Annotate MONTH for Hive, Spark and DBX (#6795)
due to 86ca0b6 - Annotate MONTHS_BETWEEN for Hive, Spark and DBX (PR #6796 by @AbhishekASLK):
Annotate MONTHS_BETWEEN for Hive, Spark and DBX (#6796)
due to 590bcf1 - Annotate DATE_FROM_UNIX_DATE for Spark and DBX (PR #6797 by @AbhishekASLK):
Annotate DATE_FROM_UNIX_DATE for Spark and DBX (#6797)
due to 7e3df62 - parse DISTINCT as separate arg from quantile for PERCENTILE func (PR #6799 by @geooo109):
parse DISTINCT as separate arg from quantile for PERCENTILE func (#6799)
due to a2c4b08 - Annotate UNHEX for Hive, Spark and DBX (PR #6800 by @AbhishekASLK):
Annotate UNHEX for Hive, Spark and DBX (#6800)
due to 3ab49b6 - Annotate ASIN for Hive, Spark and DBX (PR #6807 by @AbhishekASLK):
Annotate ASIN for Hive, Spark and DBX (#6807)
due to d86e28a - Annotate ASINH for Spark and DBX (PR #6808 by @AbhishekASLK):
Annotate ASINH for Spark and DBX (#6808)
due to 8fe8d64 - ARRAY_PREPEND null propagation (PR #6809 by @fivetran-MichaelLee):
ARRAY_PREPEND null propagation (#6809)
due to 99b2b6a - robust parsing of ALL/DISTINCT for PERCENTILE_APPROX func (PR #6812 by @geooo109):
robust parsing of ALL/DISTINCT for PERCENTILE_APPROX func (#6812)
due to e6eff62 - Annotate GET_BIT for DuckDB (PR #6816 by @AbhishekASLK):
Annotate GET_BIT for DuckDB (#6816)
due to 70c2097 - Annotate DAYNAME for Base Dialect (PR #6817 by @AbhishekASLK):
Annotate DAYNAME for Base Dialect (#6817)
due to 2d5c3aa - Annotate CBRT for Base Dialect (PR #6819 by @AbhishekASLK):
Annotate CBRT for Base Dialect (#6819)
due to 0a478ad - introduce BYTE_STRING_ESCAPES concept for postgres/duckdb e-strings (PR #6818 by @georgesittas):
introduce BYTE_STRING_ESCAPES concept for postgres/duckdb e-strings (#6818)
due to 5673b09 - support transpilation of try_to_date from snowflake to duckdb (PR #6806 by @fivetran-felixhuang):
support transpilation of try_to_date from snowflake to duckdb (#6806)
due to c229079 - support transpilation try_to_double snowflake to duck db (PR #6821 by @fivetran-felixhuang):
support transpilation try_to_double snowflake to duck db (#6821)
due to dcf2cb9 - annotate fields of UNNEST(STRUCT) with ALIAS for bq (PR #6830 by @geooo109):
annotate fields of UNNEST(STRUCT) with ALIAS for bq (#6830)
due to 378349d - Annotate SOUNDEX for Hive, Spark and DBX (PR #6832 by @AbhishekASLK):
Annotate SOUNDEX for Hive, Spark and DBX (#6832)
due to 3972a6c - Transpile BASE64_ENCODE from Snowflake to DuckDB (PR #6826 by @fivetran-kwoodbeck):
Transpile BASE64_ENCODE from Snowflake to DuckDB (#6826)
due to a9daff7 - Transpilation of Snowflake SEQ1/2/4/8 and GENERATOR to DuckDB (PR #6810 by @fivetran-kwoodbeck):
Transpilation of Snowflake SEQ1/2/4/8 and GENERATOR to DuckDB (#6810)
due to 317d496 - Annotate SESSION_USER() for Spark and DBX (PR #6834 by @AbhishekASLK):
Annotate SESSION_USER() for Spark and DBX (#6834)
due to 98cc685 - Annotate FACTORIAL(expr) for Hive, Spark and DBX (PR #6835 by @AbhishekASLK):
Annotate FACTORIAL(expr) for Hive, Spark and DBX (#6835)
due to f8024e0 - Annotate QUARTER for Hive, Spark and DBX (PR #6840 by @AbhishekASLK):
Annotate QUARTER for Hive, Spark and DBX (#6840)
due to b3b36ba - robust representation of negative numbers (PR #6833 by @geooo109):
robust representation of negative numbers (#6833)
due to 6ebe5cc - ARRAY_CAT null propagation (PR #6829 by @fivetran-MichaelLee):
ARRAY_CAT null propagation (#6829)
due to 36211c2 - transpile BASE64_DECODE_STRING/BINARY to DuckDB (PR #6837 by @fivetran-kwoodbeck):
transpile BASE64_DECODE_STRING/BINARY to DuckDB (#6837)
due to 541abfe - annotate type for bq DATE_ADD (PR #6842 by @geooo109):
annotate type for bq DATE_ADD (#6842)
due to 8797e12 - add support for transpiling ARRAY_COMPACT (PR #6839 by @fivetran-MichaelLee):
add support for transpiling ARRAY_COMPACT (#6839)
due to 89f583a - Annotate SECOND for Hive, Spark and DBX (PR #6853 by @AbhishekASLK):
Annotate SECOND for Hive, Spark and DBX (#6853)
due to 3852e1d - Annotate ARRAY_SIZE(array) correctly for Spark and DBX (PR #6852 by @AbhishekASLK):
Annotate ARRAY_SIZE(array) correctly for Spark and DBX (#6852)
due to 4a7e5a1 - Transpilation for Snowflake EDITDISTANCE to Duckdb (PR #6846 by @fivetran-kwoodbeck):
Transpilation for Snowflake EDITDISTANCE to Duckdb (#6846)
due to 6f3b76b - Annotate SIN, COS, TAN, COT for T-SQL (PR #6851 by @AbhishekASLK):
Annotate SIN, COS, TAN, COT for T-SQL (#6851)
due to f1c4fa0 - input rounding issue when transpiling boolean logic functions to DuckDB (PR #6849 by @fivetran-felixhuang):
input rounding issue when transpiling boolean logic functions to DuckDB (#6849)
due to eb9887f - support ATN2 function AST (PR #6862 by @AbhishekASLK):
support ATN2 function AST (#6862)
due to 5922ba6 - Annotate inverse trigonometric functions for TSQL (PR #6865 by @AbhishekASLK):
Annotate inverse trigonometric functions for TSQL (#6865)
due to fc55b98 - Transpilation of MINHASH functions from Snowflake to DuckDB (PR #6859 by @fivetran-kwoodbeck):
Transpilation of MINHASH functions from Snowflake to DuckDB (#6859)
due to 3728646 - Annotate CURRENT_TIMEZONE() for TSQL (PR #6871 by @AbhishekASLK):
Annotate CURRENT_TIMEZONE() for TSQL (#6871)
due to c6bfe61 - improve some starrocks properties generation (PR #6827 by @jaogoy):
improve some starrocks properties generation (#6827)
due to 2103d1c - Annotate MD5 for Hive, Spark and DBX (PR #6878 by @AbhishekASLK):
Annotate MD5 for Hive, Spark and DBX (#6878)
due to 6f49775 - Transpilation of ARRAY_CONSTRUCT_COMPACT to duckdb (PR #6875 by @fivetran-MichaelLee):
Transpilation of ARRAY_CONSTRUCT_COMPACT to duckdb (#6875)
due to 37dc9c7 - support transpilation of ARRAY_INSERT (PR #6863 by @fivetran-MichaelLee):
support transpilation of ARRAY_INSERT (#6863)
due to 3a769d4 - Added transpilation of Snowflake ARRAYS_ZIP to DuckDB (PR #6874 by @fivetran-kwoodbeck):
Added transpilation of Snowflake ARRAYS_ZIP to DuckDB (#6874)
due to 9c39f08 - Annotate DAYOFWEEK for MySQL (PR #6885 by @AbhishekASLK):
Annotate DAYOFWEEK for MySQL (#6885)
due to 9a0aaab - Annotate SOUNDEX(expr) for TSQL (PR #6887 by @AbhishekASLK):
Annotate SOUNDEX(expr) for TSQL (#6887)
due to 3e94c60 - support transpilation of ARRAY_REMOVE (PR #6886 by @fivetran-MichaelLee):
support transpilation of ARRAY_REMOVE (#6886)
due to bce1b1f - Transpilation support for Snowflake MAP_CAT to DuckDB (PR #6881 by @fivetran-kwoodbeck):
Transpilation support for Snowflake MAP_CAT to DuckDB (#6881)
due to b49a656 - Annotate FACTORIAL(expr) for DuckDB (PR #6891 by @AbhishekASLK):
Annotate FACTORIAL(expr) for DuckDB (#6891)
due to 6ce073b - transpilation support for IS_ARRAY (PR #6877 by @fivetran-ashashankar):
transpilation support for IS_ARRAY (#6877)
due to 5f67a14 - bump sqlglotrs to 0.12.0 (commit by @georgesittas):
bump sqlglotrs to 0.12.0
ed4ba08 - postgres: add support for Bitwise NOT (PR #6740 by @AbhishekASLK)
894c581 - optimizer: annotate cot for spark and dbx (PR #6739 by @AbhishekASLK)cc18c55 - optimizer: add COSH function annotation for Hive and related dialects (PR #6738 by @AbhishekASLK)03dd8bd - optimizer: add SINH function annotation for Hive and related dialects (PR #6736 by @AbhishekASLK)9b1a634 - duckdb: cast APPROX_QUANTILE results to DOUBLE to respect Snowflake's typing during transpilation (PR #6734 by @fivetran-BradfordPaskewitz)f644541 - optimizer: add TO_BINARY function annotation for Spark and DBX dialect (PR #6743 by @AbhishekASLK)5a50d05 - duckdb: Add transpilation support for NEXT_DAY function (PR #6728 by @fivetran-amrutabhimsenayachit)27a7b68 - optimizer: add annotation for ACOS function (PR #6747 by @AbhishekASLK)c1995b2 - spark: add ACOSH function annotation (PR #6748 by @AbhishekASLK)a5ccfbb - optimizer: add SHA function annotations for Hive (PR #6750 by @AbhishekASLK)2191273 - snowflake: Transpilation support for Snowflake's BITMAP_CONSTRUCT_AGG function to DuckDB (PR #6745 by @fivetran-kwoodbeck)ee0b213 - optimizer: Annotate RANDN function for Spark and DBX (PR #6751 by @AbhishekASLK)e643817 - optimizer: Annotate SPACE function to Hive (PR #6752 by @AbhishekASLK)6befad0 - optimizer: Annotate BIT_LENGTH for Spark and DBX (PR #6754 by @AbhishekASLK)076058d - optimizer: Annotate SHA1 and SHA256 function for DuckDB (PR #6753 by @AbhishekASLK)ff1b5da - optimizer: Annotate KURTOSIS function (PR #6757 by @AbhishekASLK)af008bd - optimizer: Annotate SIN, COS, TAN for Hive and inherited dialects (PR #6759 by @AbhishekASLK)b87be58 - optimizer: Annotate SEC for Spark and DBX (PR #6768 by @AbhishekASLK)5a594ed - optimizer: Annotate ATANH for Spark and DBX (PR #6767 by @AbhishekASLK)1f9672f - optimizer: Annotate ATAN for Hive and inherited dialects (PR #6766 by @AbhishekASLK)38d6816 - bigquery: Support type inference for BQ SAFE functions (PR #6765 by @fivetran-BradfordPaskewitz)c89a127 - snowflake: Implements transpilation for IS_NULL_VALUE (PR #6756 by @fivetran-ashashankar)428d676 - duckdb: avoid redundant cast when transpiling trunc from snowflake (PR #6771 by @georgesittas)
8163ffa - snowflake: Implements transpilation for Snowflake's EQUAL_NULL (PR #6763 by @fivetran-ashashankar)4245205 - duckdb: Add transpilation support for TIME_FROM_PARTS function for overflow case (PR #6761 by @fivetran-amrutabhimsenayachit)4c01cbe - optimizer: Annotate CBRT for Hive and inherited dialects (PR #6772 by @AbhishekASLK)237aec0 - optimizer: Annotate CURRENT_CATALOG() for Hive, Spark, and DBX (PR #6773 by @AbhishekASLK)82d533e - optimizer: Annotate CURRENT_DATABASE() for Hive, Spark and DBX (PR #6774 by @AbhishekASLK)b5674f6 - optimizer: robust correlated subqueries annotation (PR #6764 by @geooo109)8634a8a - snowflake: Added Snowflake to DuckDB transpilation for EXTRACT (PR #6706 by @fivetran-kwoodbeck)8cda928 - databricks,duckdb,postgres,spark,snowflake: ARRAY_APPEND null propagation (PR #6762 by @fivetran-MichaelLee)2ab4376 - optimizer: Annotate CURRENT_USER() for Hive, Spark and DBX (PR #6790 by @AbhishekASLK)fca6a94 - optimizer: Annotate CURRENT_SCHEMA() for Hive, Spark and DBX (PR #6792 by @AbhishekASLK)7f4a150 - optimizer: parse and annotate bq NET.REG_DOMAIN (PR #6777 by @geooo109)ce0bbcf - optimizer: Annotate MONTHNAME for Spark and DBX (PR #6794 by @AbhishekASLK)bc0a43c - optimizer: Annotate MONTH for Hive, Spark and DBX (PR #6795 by @AbhishekASLK)86ca0b6 - optimizer: Annotate MONTHS_BETWEEN for Hive, Spark and DBX (PR #6796 by @AbhishekASLK)590bcf1 - optimizer: Annotate DATE_FROM_UNIX_DATE for Spark and DBX (PR #6797 by @AbhishekASLK)a2c4b08 - optimizer: Annotate UNHEX for Hive, Spark and DBX (PR #6800 by @AbhishekASLK)39db28e - duckdb: Add transpilation support for TIMESTAMP_FROM_PARTS function (PR #6801 by @fivetran-amrutabhimsenayachit)3ab49b6 - optimizer: Annotate ASIN for Hive, Spark and DBX (PR #6807 by @AbhishekASLK)d86e28a - optimizer: Annotate ASINH for Spark and DBX (PR #6808 by @AbhishekASLK)8fe8d64 - databricks,duckdb,postgres,spark,snowflake: ARRAY_PREPEND null propagation (PR #6809 by @fivetran-MichaelLee)1c31ae3 - duckdb: Add transpilation support for TIME_SLICE function (PR #6805 by @fivetran-amrutabhimsenayachit)88412cb - starrocks: add support for ROLLUP index property (PR #6814 by @petrikoro)e6eff62 - optimizer: Annotate GET_BIT for DuckDB (PR #6816 by @AbhishekASLK)70c2097 - optimizer: Annotate DAYNAME for Base Dialect (PR #6817 by @AbhishekASLK)2d5c3aa - optimizer: Annotate CBRT for Base Dialect (PR #6819 by @AbhishekASLK)5673b09 - snowflake: support transpilation of try_to_date from snowflake to duckdb (PR #6806 by @fivetran-felixhuang)c229079 - snowflake: support transpilation try_to_double snowflake to duck db (PR #6821 by @fivetran-felixhuang)378349d - optimizer: Annotate SOUNDEX for Hive, Spark and DBX (PR #6832 by @AbhishekASLK)3972a6c - snowflake: Transpile BASE64_ENCODE from Snowflake to DuckDB (PR #6826 by @fivetran-kwoodbeck)a9daff7 - snowflake: Transpilation of Snowflake SEQ1/2/4/8 and GENERATOR to DuckDB (PR #6810 by @fivetran-kwoodbeck)317d496 - optimizer: Annotate SESSION_USER() for Spark and DBX (PR #6834 by @AbhishekASLK)98cc685 - optimizer: Annotate FACTORIAL(expr) for Hive, Spark and DBX (PR #6835 by @AbhishekASLK)db057bb - postgres: support VARIADIC (PR #6841 by @syubogdanov)7dade98 - duckdb: Add transpilation support for REVERSE function (PR #6838 by @fivetran-amrutabhimsenayachit)36211c2 - snowflake: transpile BASE64_DECODE_STRING/BINARY to DuckDB (PR #6837 by @fivetran-kwoodbeck)541abfe - optimizer: annotate type for bq DATE_ADD (PR #6842 by @geooo109)8797e12 - duckdb: add support for transpiling ARRAY_COMPACT (PR #6839 by @fivetran-MichaelLee)89f583a - optimizer: Annotate SECOND for Hive, Spark and DBX (PR #6853 by @AbhishekASLK)4a7e5a1 - snowflake: Transpilation for Snowflake EDITDISTANCE to Duckdb (PR #6846 by @fivetran-kwoodbeck)6f3b76b - optimizer: Annotate SIN, COS, TAN, COT for T-SQL (PR #6851 by @AbhishekASLK)2a455ca - duckdb: Add transpilation support for FLATTEN (ARRAY_FLATTEN) (PR #6848 by @fivetran-amrutabhimsenayachit)e1b6529 - snowflake: support directed joins closes #6850 (PR #6856 by @georgesittas)c94284f - optimizer: UDF annotation (PR #6843 by @georgesittas)394bba4 - starrocks: add full support for partitions (PR #6804 by @petrikoro)
eb9887f - tsql: support ATN2 function AST (PR #6862 by @AbhishekASLK)5922ba6 - tsql: Annotate inverse trigonometric functions for TSQL (PR #6865 by @AbhishekASLK)f0618b9 - spark: support AS JSON suffix in describe statement closes #6866 (commit by @georgesittas)bf90b5d - duckdb: Add transpilation support for SPACE function (PR #6867 by @fivetran-amrutabhimsenayachit)fc55b98 - snowflake: Transpilation of MINHASH functions from Snowflake to DuckDB (PR #6859 by @fivetran-kwoodbeck)3728646 - tsql: Annotate CURRENT_TIMEZONE() for TSQL (PR #6871 by @AbhishekASLK)c6bfe61 - starrocks: improve some starrocks properties generation (PR #6827 by @jaogoy)2103d1c - optimizer: Annotate MD5 for Hive, Spark and DBX (PR #6878 by @AbhishekASLK)6f49775 - duckdb: Transpilation of ARRAY_CONSTRUCT_COMPACT to duckdb (PR #6875 by @fivetran-MichaelLee)37dc9c7 - duckdb: support transpilation of ARRAY_INSERT (PR #6863 by @fivetran-MichaelLee)3a769d4 - snowflake: Added transpilation of Snowflake ARRAYS_ZIP to DuckDB (PR #6874 by @fivetran-kwoodbeck)9a0aaab - optimizer: Annotate SOUNDEX(expr) for TSQL (PR #6887 by @AbhishekASLK)3e94c60 - duckdb: support transpilation of ARRAY_REMOVE (PR #6886 by @fivetran-MichaelLee)bce1b1f - snowflake: Transpilation support for Snowflake MAP_CAT to DuckDB (PR #6881 by @fivetran-kwoodbeck)ad2e9d3 - postgres: support function parameter mode (IN, OUT, INOUT, VARIADIC) (PR #6876 by @fivetran-amrutabhimsenayachit)
b49a656 - optimizer: Annotate FACTORIAL(expr) for DuckDB (PR #6891 by @AbhishekASLK)6ce073b - snowflake: transpilation support for IS_ARRAY (PR #6877 by @fivetran-ashashankar)aeaa43d - duckdb: Preserve key name in STRUCT for all identifiers (PR #6744 by @VaggelisD)
7b5279c - optimizer: Fix optimizer for generate series (PR #6679 by @chrisqu777)
48336d0 - optimizer: Exclude table-valued functions from unnest_subqueries (PR #6755 by @VaggelisD)700fbe9 - optimizer: Annotate CORR for Hive and inherited dialects (PR #6769 by @AbhishekASLK)69c874f - bigquery: properly support safe functions (PR #6775 by @georgesittas)ee08d77 - parser: resolve parsing issue in substr with FROM/FOR syntax (PR #6791 by @AbhishekASLK)
d6ecc73 - parser: add support for grouping_id() (PR #6793 by @AbhishekASLK)
7e3df62 - hive, spark, databriicks: parse DISTINCT as separate arg from quantile for PERCENTILE func (PR #6799 by @geooo109)
c2069b7 - starrocks: omit TABLE keyword for INSERT OVERWRITE fixes #6803 (commit by @georgesittas)99b2b6a - hive, spark2, spark, databricks: robust parsing of ALL/DISTINCT for PERCENTILE_APPROX func (PR #6812 by @geooo109)ba1d99f - starrocks: rewrite BETWEEN as comparison operators for DELETE (PR #6815 by @petrikoro)7e46829 - quote integration tests GHA heredoc delimiter (PR #6820 by @treysp)0a478ad - introduce BYTE_STRING_ESCAPES concept for postgres/duckdb e-strings (PR #6818 by @georgesittas)
d8f266b - merge_subqueries: Do not replace literals in GROUP BY (PR #6828 by @VaggelisD)
dcf2cb9 - optimizer: annotate fields of UNNEST(STRUCT) with ALIAS for bq (PR #6830 by @geooo109)f8024e0 - optimizer: Annotate QUARTER for Hive, Spark and DBX (PR #6840 by @AbhishekASLK)b3b36ba - parser: robust representation of negative numbers (PR #6833 by @geooo109)
6ebe5cc - duckdb,postgres,redshift,snowflake: ARRAY_CAT null propagation (PR #6829 by @fivetran-MichaelLee)5a1028a - snowflake: match_condition edge case when offset/limit are present (PR #6847 by @georgesittas)3852e1d - optimizer: Annotate ARRAY_SIZE(array) correctly for Spark and DBX (PR #6852 by @AbhishekASLK)7abc6b5 - Fix LATERAL VIEW POSEXPLODE transpilation (PR #6844 by @VaggelisD)
f1c4fa0 - snowflake: input rounding issue when transpiling boolean logic functions to DuckDB *(PR [#6849](httpdue to `06ce65a` - support transpilation of bitwise agg functions *(PR #6580 by @fivetran-MichaelLee)*:
due to 06ce65a - support transpilation of bitwise agg functions (PR #6580 by @fivetran-MichaelLee):
support transpilation of bitwise agg functions (#6580)
due to 1497ee6 - corrected handling of ToChar for Postgres (commit by @dhawkins1234):
corrected handling of ToChar for Postgres
due to c52705d - annotate EXISTS, ALL, ANY as BOOLEAN (PR #6590 by @doripo):
annotate EXISTS, ALL, ANY as BOOLEAN (#6590)
due to 8ef9d7b - support transpilation of GREATEST, GREATEST_IGNORE_NULLS, LEAST, LEAST_IGNORE_NULLS from snowflake to duckdb (PR #6579 by @fivetran-felixhuang):
support transpilation of GREATEST, GREATEST_IGNORE_NULLS, LEAST, LEAST_IGNORE_NULLS from snowflake to duckdb (#6579)
due to b93291b - support transpilation of TRY_TO_BOOLEAN from Snowflake to DuckDB (PR #6594 by @fivetran-felixhuang):
support transpilation of TRY_TO_BOOLEAN from Snowflake to DuckDB (#6594)
due to 00e596d - support transpilation of BOOLXOR_AGG, BOOLAND_AGG, and BOOLOR_AGG from Snowflake to DuckDB (PR #6592 by @fivetran-kwoodbeck):
support transpilation of BOOLXOR_AGG, BOOLAND_AGG, and BOOLOR_AGG from Snowflake to DuckDB (#6592)
due to 0ba33ad - Add transpilation support for DAYNAME and MONTHNAME functions. (PR #6603 by @fivetran-amrutabhimsenayachit):
Add transpilation support for DAYNAME and MONTHNAME functions. (#6603)
due to 62c0ef0 - Fix BQ's exp.Date transpilation (PR #6595 by @VaggelisD):
Fix BQ's exp.Date transpilation (#6595)
due to 77ff9d0 - annotate types for MAP_* functions (PR #6605 by @fivetran-kwoodbeck):
annotate types for MAP_* functions (#6605)
due to e7c1574 - Add transpilation support for DATE_DIFF function (PR #6609 by @fivetran-amrutabhimsenayachit):
Add transpilation support for DATE_DIFF function (#6609)
due to d8f0bbd - conditionally consume +/- in scientific literal notation (PR #6610 by @georgesittas):
conditionally consume +/- in scientific literal notation (#6610)
due to 13014e0 - move postgres range parsers to global level (PR #6591 by @AbhishekASLK):
move postgres range parsers to global level (#6591)
due to d26ff44 - support adjacent ranges operator (PR #6611 by @AbhishekASLK):
support adjacent ranges operator (#6611)
due to 1f3436b - bq robust literal/non-literal type annotation (PR #6600 by @geooo109):
bq robust literal/non-literal type annotation (#6600)
due to 8f38887 - annotate snowflake array construct (commit by @georgesittas):
annotate snowflake array construct
due to 870dba4 - support transpilation of LAST_DAY from Snowflake to Duckdb (PR #6614 by @fivetran-felixhuang):
support transpilation of LAST_DAY from Snowflake to Duckdb (#6614)
due to 870d600 - support: postgres point (PR #6615 by @AbhishekASLK):
support: postgres point (#6615)
due to 302fda0 - support and, or (PR #6625 by @AbhishekASLK):
support and, or (#6625)
due to fc5800d - support Snowflake to DuckDB transpilation of ZIPF (PR #6618 by @fivetran-kwoodbeck):
support Snowflake to DuckDB transpilation of ZIPF (#6618)
due to dea22ca - support RECORD type (PR #6635 by @AbhishekASLK):
support RECORD type (#6635)
due to 77783da - support: var-args in xor (PR #6634 by @AbhishekASLK):
support: var-args in xor (#6634)
due to b75a3e3 - handle BINARY keyword (PR #6636 by @AbhishekASLK):
handle BINARY keyword (#6636)
due to e7b5d6f - support transpilation of TRY_TO_BINARY from Snowflake to DuckDB (PR #6629 by @fivetran-felixhuang):
support transpilation of TRY_TO_BINARY from Snowflake to DuckDB (#6629)
due to 2bf9405 - USING keyword in chr (PR #6637 by @AbhishekASLK):
USING keyword in chr (#6637)
due to 235fc14 - support charset (PR #6633 by @AbhishekASLK):
support charset (#6633)
due to d46969d - annotate snowflake ARRAY_APPEND and ARRAY_PREPEND (PR #6645 by @fivetran-MichaelLee):
annotate snowflake ARRAY_APPEND and ARRAY_PREPEND (#6645)
due to 9c54329 - Type annotation for Snowflake ENCRYPT and DECRYPT functions (PR #6643 by @fivetran-kwoodbeck):
Type annotation for Snowflake ENCRYPT and DECRYPT functions (#6643)
due to 7870bd0 - type annotation for COVAR_POP and COVAR_SAMP (PR #6656 by @fivetran-kwoodbeck):
type annotation for COVAR_POP and COVAR_SAMP (#6656)
due to 2fa29b1 - Type annotation for ARRAY_REMOVE function (PR #6653 by @fivetran-MichaelLee):
Type annotation for ARRAY_REMOVE function (#6653)
due to 3d59af5 - Added UNIFORM transpilation for Snowflake to DuckDB (PR #6640 by @fivetran-kwoodbeck):
Added UNIFORM transpilation for Snowflake to DuckDB (#6640)
due to 5552f12 - annotation support for LOCALTIME function (PR #6651 by @AbhishekASLK):
annotation support for LOCALTIME function (#6651)
due to a669651 - Type annotation for Snowflake LOCALTIMESTAMP (PR #6652 by @fivetran-kwoodbeck):
Type annotation for Snowflake LOCALTIMESTAMP (#6652)
due to 40ccce4 - Transpile Snowflake NORMAL to DuckDB using Box-Muller transform (PR #6654 by @fivetran-kwoodbeck):
Transpile Snowflake NORMAL to DuckDB using Box-Muller transform (#6654)
due to d6bf569 - updates for Snowflake to DuckDB transpilation of TO_TIMESTAMP functions (PR #6622 by @fivetran-kwoodbeck):
updates for Snowflake to DuckDB transpilation of TO_TIMESTAMP functions (#6622)
due to 13251fd - annotation support for ELT function (PR #6659 by @AbhishekASLK):
annotation support for ELT function (#6659)
due to b287e4e - Support transpilation for BITMAP_BUCKET_NUMBER (PR #6668 by @fivetran-ashashankar):
Support transpilation for BITMAP_BUCKET_NUMBER (#6668)
due to d5b84cb - ignore comments in the semantic differ (PR #6675 by @georgesittas):
ignore comments in the semantic differ (#6675)
due to 399c80f - rename args for CovarSamp/Pop, stop inheriting from Binary (commit by @georgesittas):
rename args for CovarSamp/Pop, stop inheriting from Binary
due to c9a70c0 - update transpilation of DATE_TRUNC to duckdb (PR #6644 by @toriwei):
update transpilation of DATE_TRUNC to duckdb (#6644)
due to 460b3a2 - Allow varlen args in exp.MD5Digest (PR #6685 by @VaggelisD):
Allow varlen args in exp.MD5Digest (#6685)
due to dcdee68 - Allow non aggregation functions in PIVOT (PR #6687 by @VaggelisD):
Allow non aggregation functions in PIVOT (#6687)
due to a4be3fa - support SYSTIMESTAMP as NO_PAREN_FUNCTION (PR #6677 by @AbhishekASLK):
support SYSTIMESTAMP as NO_PAREN_FUNCTION (#6677)
due to 243448c - Transpile date extraction from Snowflake to DuckDB (YEAR*, WEEK*, DAY*, etc) (PR #6666 by @fivetran-kwoodbeck):
Transpile date extraction from Snowflake to DuckDB (YEAR*, WEEK*, DAY*, etc) (#6666)
due to 29cff1f - bq robust literal/non-literal binary annotation (PR #6688 by @geooo109):
bq robust literal/non-literal binary annotation (#6688)
due to 65acd6c - transpile snowflake SYSDATE (PR #6693 by @fivetran-ashashankar):
transpile snowflake SYSDATE (#6693)
due to 36ff96c - support transpilation of BITSHIFTLEFT and BITSHIFTRIGHT (PR #6586 by @fivetran-kwoodbeck):
support transpilation of BITSHIFTLEFT and BITSHIFTRIGHT (#6586)
due to fb8f57a - Fix UPDATE statement for multi tables (PR #6700 by @VaggelisD):
Fix UPDATE statement for multi tables (#6700)
due to 21f9d3c - Normalize struct field names when annotating types (PR #6674 by @vchan):
Normalize struct field names when annotating types (#6674)
due to 7362c23 - interval expressions (PR #6648 by @AbhishekASLK):
interval expressions (#6648)
due to a503a7a - annotate Encode for hive dialect hierarchy (commit by @georgesittas):
annotate Encode for hive dialect hierarchy
due to c447df7 - annotate the LOCALTIMESTAMP (PR #6709 by @AbhishekASLK):
annotate the LOCALTIMESTAMP (#6709)
due to e91a14b - annotate the CURRENT_TIMEZONE (PR #6708 by @AbhishekASLK):
annotate the CURRENT_TIMEZONE (#6708)
due to b53c8d4 - annotate the UNIX_TIMESTAMP (PR #6717 by @AbhishekASLK):
annotate the UNIX_TIMESTAMP (#6717)
due to cfb06ab - add support for transpiling ARRAY_AGG with ORDER BY (PR #6691 by @fivetran-MichaelLee):
add support for transpiling ARRAY_AGG with ORDER BY (#6691)
due to 2965077 - add support for JSON_KEYS func (PR #6718 by @geooo109):
add support for JSON_KEYS func (#6718)
due to bbaba5f - annotate type for snowflake ARRAY_CAT (PR #6721 by @fivetran-MichaelLee):
annotate type for snowflake ARRAY_CAT (#6721)
due to 0a1c7ab - support transpilation of GETBIT from snowflake to duckdb (PR #6692 by @fivetran-felixhuang):
support transpilation of GETBIT from snowflake to duckdb (#6692)
due to cb320c4 - bq annotate type for raw strings (PR #6723 by @geooo109):
bq annotate type for raw strings (#6723)
due to 09fa467 - Annotate ATAN2 for Spark & DBX (PR #6725 by @AbhishekASLK):
Annotate ATAN2 for Spark & DBX (#6725)
due to b59b3bf - Annotate TANH for Spark & DBX (PR #6726 by @AbhishekASLK):
Annotate TANH for Spark & DBX (#6726)
due to 917071b - Support transpilation of TO_TIME and TRY_TO_TIME from snowflake to duckdb (PR #6690 by @fivetran-kwoodbeck):
Support transpilation of TO_TIME and TRY_TO_TIME from snowflake to duckdb (#6690)
due to e50a97e - Type annotate for Snowflake Kurtosis (PR #6720 by @fivetran-kwoodbeck):
Type annotate for Snowflake Kurtosis (#6720)
due to 33b8a5d - bump sqlglotrs to 0.11.0 (commit by @georgesittas):
bump sqlglotrs to 0.11.0
06ce65a - snowflake: support transpilation of bitwise agg functions (PR #6580 by @fivetran-MichaelLee)82abf40 - duckdb: Add tranwspilation support for CEIL function (PR #6589 by @fivetran-amrutabhimsenayachit)9f9994d - duckdb: Add transpilation support for float/decimal numbers and preserve end-of-month logic & type (PR #6576 by @fivetran-amrutabhimsenayachit)8ef9d7b - snowflake: support transpilation of GREATEST, GREATEST_IGNORE_NULLS, LEAST, LEAST_IGNORE_NULLS from snowflake to duckdb (PR #6579 by @fivetran-felixhuang)b93291b - snowflake: support transpilation of TRY_TO_BOOLEAN from Snowflake to DuckDB (PR #6594 by @fivetran-felixhuang)00e596d - snowflake: support transpilation of BOOLXOR_AGG, BOOLAND_AGG, and BOOLOR_AGG from Snowflake to DuckDB (PR #6592 by @fivetran-kwoodbeck)0ba33ad - duckdb: Add transpilation support for DAYNAME and MONTHNAME functions. (PR #6603 by @fivetran-amrutabhimsenayachit)77ff9d0 - snowflake: annotate types for MAP_* functions (PR #6605 by @fivetran-kwoodbeck)e7c1574 - duckdb: Add transpilation support for DATE_DIFF function (PR #6609 by @fivetran-amrutabhimsenayachit)d26ff44 - postgres: support adjacent ranges operator (PR #6611 by @AbhishekASLK)8f38887 - optimizer: annotate snowflake array construct (commit by @georgesittas)870dba4 - snowflake: support transpilation of LAST_DAY from Snowflake to Duckdb (PR #6614 by @fivetran-felixhuang)fc5800d - snowflake: support Snowflake to DuckDB transpilation of ZIPF (PR #6618 by @fivetran-kwoodbeck)4aea018 - duckdb: Add transpilation support for nanoseconds used in date/time functions. (PR #6617 by @fivetran-amrutabhimsenayachit)dea22ca - singlestore: support RECORD type (PR #6635 by @AbhishekASLK)77783da - clickhouse: support: var-args in xor (PR #6634 by @AbhishekASLK)b75a3e3 - mysql: handle BINARY keyword (PR #6636 by @AbhishekASLK)c17878a - add ability to create dialect plugins (PR #6627 by @vgvoleg)
e7b5d6f - snowflake: support transpilation of TRY_TO_BINARY from Snowflake to DuckDB (PR #6629 by @fivetran-felixhuang)9c54329 - snowflake: Type annotation for Snowflake ENCRYPT and DECRYPT functions (PR #6643 by @fivetran-kwoodbeck)7870bd0 - snowflake: type annotation for COVAR_POP and COVAR_SAMP (PR #6656 by @fivetran-kwoodbeck)2fa29b1 - snowflake: Type annotation for ARRAY_REMOVE function (PR #6653 by @fivetran-MichaelLee)3d59af5 - snowflake: Added UNIFORM transpilation for Snowflake to DuckDB (PR #6640 by @fivetran-kwoodbeck)5552f12 - annotation support for LOCALTIME function (PR #6651 by @AbhishekASLK)a669651 - snowflake: Type annotation for Snowflake LOCALTIMESTAMP (PR #6652 by @fivetran-kwoodbeck)40ccce4 - duckdb: Transpile Snowflake NORMAL to DuckDB using Box-Muller transform (PR #6654 by @fivetran-kwoodbeck)d6bf569 - snowflake: updates for Snowflake to DuckDB transpilation of TO_TIMESTAMP functions (PR #6622 by @fivetran-kwoodbeck)51af50e - snowflake: support out of range values for DATE_FROM_PARTS when transpiling to DuckDB (PR #6671 by @toriwei)13251fd - mysql: annotation support for ELT function (PR #6659 by @AbhishekASLK)b287e4e - snowflake: Support transpilation for BITMAP_BUCKET_NUMBER (PR #6668 by @fivetran-ashashankar)d5b84cb - diff: ignore comments in the semantic differ (PR #6675 by @georgesittas)
26c16f2 - snowflake: transpile CORR with NaN-->NULL (PR #6619 by @treysp)c9a70c0 - snowflake: update transpilation of DATE_TRUNC to duckdb (PR #6644 by @toriwei)a4be3fa - oracle,exasol: support SYSTIMESTAMP as NO_PAREN_FUNCTION (PR #6677 by @AbhishekASLK)
243448c - duckdb: Transpile date extraction from Snowflake to DuckDB (YEAR*, WEEK*, DAY*, etc) (PR #6666 by @fivetran-kwoodbeck)efa77df - mysql: translate UPDATE … FROM … syntax to UPDATE … JOIN … when generating MySQL (PR #6655 by @brdbry)65acd6c - duckdb: transpile snowflake SYSDATE (PR #6693 by @fivetran-ashashankar)36ff96c - snowflake: support transpilation of BITSHIFTLEFT and BITSHIFTRIGHT (PR #6586 by @fivetran-kwoodbeck)142acd2 - pretty formatting for nested data types (PR #6707 by @treysp)a503a7a - optimizer: annotate Encode for hive dialect hierarchy (commit by @georgesittas)c447df7 - spark,databricks: annotate the LOCALTIMESTAMP (PR #6709 by @AbhishekASLK)e91a14b - spark,databricks: annotate the CURRENT_TIMEZONE (PR #6708 by @AbhishekASLK)b53c8d4 - hive,spark,databricks: annotate the UNIX_TIMESTAMP (PR #6717 by @AbhishekASLK)cfb06ab - duckdb: add support for transpiling ARRAY_AGG with ORDER BY (PR #6691 by @fivetran-MichaelLee)2965077 - parser: add support for JSON_KEYS func (PR #6718 by @geooo109)52de0a5 - duckdb: Add transpilation support for float/decimal numbers for TIME functions (PR #6719 by @fivetran-amrutabhimsenayachit)bbeb881 - oracle: Added support for IN/OUT keywords in stored procedure parameters (PR #6710 by @rsanchez-xtillion)0a1c7ab - snowflake: support transpilation of GETBIT from snowflake to duckdb (PR #6692 by @fivetran-felixhuang)cb320c4 - optimizer: bq annotate type for raw strings (PR #6723 by @geooo109)09fa467 - optimizer: Annotate ATAN2 for Spark & DBX (PR #6725 by @AbhishekASLK)b59b3bf - optimizer: Annotate TANH for Spark & DBX (PR #6726 by @AbhishekASLK)917071b - snowflake: Support transpilation of TO_TIME and TRY_TO_TIME from snowflake to duckdb (PR #6690 by @fivetran-kwoodbeck)e50a97e - snowflake: Type annotate for Snowflake Kurtosis (PR #6720 by @fivetran-kwoodbeck)197943f - postgres: support index predicate in conflict INSERT clause closes #6727 (commit by @georgesittas)8f16463 - presto: Add support for WEEK function (PR #6593 by @chrisqu777)1497ee6 - postgres: corrected handling of ToChar for Postgres (commit by @dhawkins1234)c52705d - optimizer: annotate EXISTS, ALL, ANY as BOOLEAN (PR #6590 by @doripo)eab6f72 - parser: only parse CREATE TABLE pk key ordering in tsql (PR #6604 by @geooo109)
62c0ef0 - duckdb: Fix BQ's exp.Date transpilation (PR #6595 by @VaggelisD)
d8f0bbd - tokenizer: conditionally consume +/- in scientific literal notation (PR #6610 by @georgesittas)
c0b3e5c - spark: make_interval week (PR #6612 by @AbhishekASLK)13014e0 - postgres: move postgres range parsers to global level (PR #6591 by @AbhishekASLK)1f3436b - optimizer: bq robust literal/non-literal type annotation (PR #6600 by @geooo109)870d600 - postgres: support: postgres point (PR #6615 by @AbhishekASLK)b8b22fa - trino: mark as supporting ...EXCEPT ALL (PR #6616 by @NickCrews)9382ebd - postgres: Fix exp.WidthBucket required args (PR #6621 by @VaggelisD)
302fda0 - clickhouse: support and, or (PR #6625 by @AbhishekASLK)00c80b1 - Parse joins with derived tables in UPDATE (PR #6632 by @VaggelisD)
2bf9405 - oracle: USING keyword in chr (PR #6637 by @AbhishekASLK)235fc14 - mysql,singlestore: support charset (PR #6633 by @AbhishekASLK)b0afbac - exasol: fix TO_CHAR parsing leaking canonical datetime format tokens (PR #6650 by @nnamdi16)6ecbb01 - druid: array expression should use square brackets (PR #6664 by @its-felix)af50c1c - duckdb: Fix NOT precedence for JSON extractions (PR #6670 by @kyle-cheung)460b3a2 - exasol: Allow varlen args in exp.MD5Digest (PR #6685 by @VaggelisD)
dcdee68 - spark: Allow non aggregation functions in PIVOT (PR #6687 by @VaggelisD)
29cff1f - optimizer: bq robust literal/non-literal binary annotation (PR #6688 by @geooo109)f866c83 - oracle: properly parse xmlelement (commit by @georgesittas)91b3678 - resolver: correctly resolve unnest alias shadowing for BigQuery (PR #6665 by @fivetran-MichaelLee)2a3f1fe - spark, databricks: parse LTRIM/RTRIM (PR #6699 by @geooo109)
fb8f57a - doris, starrocks: Fix UPDATE statement for multi tables (PR #6700 by @VaggelisD)21f9d3c - optimizer: Normalize struct field names when annotating types (PR #6674 by @vchan)7362c23 - oracle: interval expressions (PR #6648 by @AbhishekASLK)a84dbc2 - parser: prevent INTERVAL from consuming GENERATED as interval unit (PR #6714 by @harshsinh)
399c80f - rename args for CovarSamp/Pop, stop inheriting from Binary (commit by @georgesittas)14b03ae - flip Getbit lsb flag to msb since more dialects match lsb (commit by @georgesittas)e0193ea - Fix make style of 6593 (PR #6597 by @VaggelisD)0534db1 - Fix integration test failing with empty PR description (PR #6598 by @VaggelisD)c523e2a - Follow up of 6551 (PR #6599 by @VaggelisD)26c3c1f - Fix integration test condition for skipping fork PRs (PR #6606 by @VaggelisD)d0965ba - Add test for PR 6616 (commit by @VaggelisD)020fb05 - refactor duckdb ZIPF transpilation logic (commit by @georgesittas)a4e1dec - Refactor PR 6617 (PR #6630 by @VaggelisD)7f2a74c - refactor RANDSTR duckdb transpilation logic (PR #6631 by @georgesittas)9a41cfc - Refactor PR 6637 (commit by @VaggelisD)2f8ffcf - snowflake: Adding type annotation tests for Snowflake's STDDEV / STDDEV_SAMP, STDDEV_POP (PR #6641 by @fivetran-kwoodbeck)d46969d - optimizer: annotate snowflake ARRAY_APPEND and ARRAY_PREPEND (PR #6645 by @fivetran-MichaelLee)4deaabc - array_append/array_prepend tests clean up (commit by @geooo109)b3ea996 - array_append/array_prepend databricks tests (commit by @geooo109)7f6b9f2 - snowflake remove aead arg gen for DECRYPT (commit by @geooo109)1fdcd63 - Fix onboarding md paragraph (commit by @VaggelisD)5d76a45 - Follow up 6677 (commit by @VaggelisD)8d49255 - Remove incorrect test of PR6655 (commit by @VaggelisD)94e6fe0 - Follow up of 6693 (PR #6698 by @VaggelisD)dd4d55a - _annotate_by_args UNKNOWN (PR #6703 by @geooo109)2ecfc27 - Follow up 6648 (PR #6716 by @VaggelisD)bbaba5f - optimizer: annotate type for snowflake ARRAY_CAT (PR #6721 by @fivetran-MichaelLee)4968ccd - add deployment instructions in README (PR #6722 by @georgesittas)2893ac3 - optimizer: Remove duplicate INITCAP annotation from Snowflake (commit by @VaggelisD)33b8a5d - bump sqlglotrs to 0.11.0 (commit by @georgesittas)due to `4dfc810` - support transpilation of BOOLNOT from snowflake to duckdb *(PR #6577 by @fivetran-felixhuang)*:
due to 4dfc810 - support transpilation of BOOLNOT from snowflake to duckdb (PR #6577 by @fivetran-felixhuang):
support transpilation of BOOLNOT from snowflake to duckdb (#6577)
due to b857185 - remove Sysdate in favor of CurrentTimestamp with sysdate arg (PR #6584 by @georgesittas):
remove Sysdate in favor of CurrentTimestamp with sysdate arg (#6584)
due to bf217d6 - make JSONArrayAgg an AggFunc (PR #6585 by @AbhishekASLK):
make JSONArrayAgg an AggFunc (#6585)
due to 604efe5 - Type annotation fixes for TO_TIMESTAMP* (PR #6557 by @fivetran-kwoodbeck):
Type annotation fixes for TO_TIMESTAMP* (#6557)
4dfc810 - snowflake: support transpilation of BOOLNOT from snowflake to duckdb (PR #6577 by @fivetran-felixhuang)7077981 - snowflake: Transpilation of Snowflake MONTHS_BETWEEN to DuckDB (PR #6561 by @fivetran-kwoodbeck)604efe5 - snowflake: Type annotation fixes for TO_TIMESTAMP* (PR #6557 by @fivetran-kwoodbeck)3567880 - add tokens to functions (commit by @tobymao)b857185 - snowflake: remove Sysdate in favor of CurrentTimestamp with sysdate arg (PR #6584 by @georgesittas)bf217d6 - make JSONArrayAgg an AggFunc (PR #6585 by @AbhishekASLK)48f5e99 - duckdb: preserve l/r-trim syntax (PR #6588 by @georgesittas)
ea0263a - Skip integration tests GA for external contributors & fix git diff (PR #6582 by @VaggelisD)due to `cfc9346` - bump sqlglotrs to 0.10.0 *(commit by @tobymao)*:
One column per quarter.