sqlglot

:boom: BREAKING CHANGES

• 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)

:sparkles: New Features

• 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)

:bug: Bug Fixes

• 12c7cf4 - dremio: Generate exp.TryCast as CAST (PR #6928 by @VaggelisD)
  • :arrow_lower_right: fixes issue #6927 opened by @AyushPatel101
• 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)

:boom: BREAKING CHANGES

• 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)

:sparkles: New Features

• 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)

:wrench: Chores

• dfb2d3b - generate API docs before checking out api-docs branch (PR #6921 by @georgesittas)

:boom: BREAKING CHANGES

• 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)

:sparkles: New Features

• 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)

:bug: Bug Fixes

• 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)
  • :arrow_lower_right: fixes issue #6908 opened by @Matt711
• 0a065be - postgres: Allow reserved tokens too in EXCLUDE WITH constraint (PR #6917 by @VaggelisD)
  • :arrow_lower_right: fixes issue #6914 opened by @Badg

:wrench: Chores

• a65c870 - add CLAUDE.md to document guidelines for SQLGlot coding (PR #6899 by @fivetran-kwoodbeck)

:boom: BREAKING CHANGES

• 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

:sparkles: New Features

• ed4ba08 - postgres: add support for Bitwise NOT (PR #6740 by @AbhishekASLK)
  • :arrow_lower_right: addresses issue #6730 opened by @Xynonners
• 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)
  • :arrow_lower_right: addresses issue #6770 opened by @baruchoxman
• 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)
  • :arrow_lower_right: addresses issue #6803 opened 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)
  • :arrow_lower_right: addresses issue #6860 opened by @Badg
• b49a656 - optimizer: Annotate FACTORIAL(expr) for DuckDB (PR #6891 by @AbhishekASLK)
• 6ce073b - snowflake: transpilation support for IS_ARRAY (PR #6877 by @fivetran-ashashankar)

:bug: Bug Fixes

• aeaa43d - duckdb: Preserve key name in STRUCT for all identifiers (PR #6744 by @VaggelisD)
  • :arrow_lower_right: fixes issue #6729 opened by @nikchha
• 7b5279c - optimizer: Fix optimizer for generate series (PR #6679 by @chrisqu777)
  • :arrow_lower_right: fixes issue #6657 opened by @metahexane
• 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)
  • :arrow_lower_right: fixes issue #6787 opened by @AbhishekASLK
• d6ecc73 - parser: add support for grouping_id() (PR #6793 by @AbhishekASLK)
  • :arrow_lower_right: fixes issue #6784 opened by @AbhishekASLK
• 7e3df62 - hive, spark, databriicks: parse DISTINCT as separate arg from quantile for PERCENTILE func (PR #6799 by @geooo109)
  • :arrow_lower_right: fixes issue #6786 opened by @AbhishekASLK
• 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)
  • :arrow_lower_right: fixes issue #6813 opened by @trouver
• d8f266b - merge_subqueries: Do not replace literals in GROUP BY (PR #6828 by @VaggelisD)
  • :arrow_lower_right: fixes issue #6823 opened by @karta0807913
• 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)
  • :arrow_lower_right: fixes issue #6831 opened by @kyle-cheung
• 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)
  • :arrow_lower_right: fixes issue #6836 opened by @nickhand
• f1c4fa0 - snowflake: input rounding issue when transpiling boolean logic functions to DuckDB *(PR [#6849](http

:boom: BREAKING CHANGES

• 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

:sparkles: New Features

• 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)
  • :arrow_lower_right: addresses issue #6626 opened 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)
  • :arrow_lower_right: addresses issue #6673 opened by @GaryLiuGTA
• 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)
  • :arrow_lower_right: addresses issue #6686 opened by @Hfuegl
• 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)

:bug: Bug Fixes

• 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)
  • :arrow_lower_right: fixes issue #6596 opened by @osmith42
• 62c0ef0 - duckdb: Fix BQ's exp.Date transpilation (PR #6595 by @VaggelisD)
  • :arrow_lower_right: fixes issue #6581 opened by @nikchha
• d8f0bbd - tokenizer: conditionally consume +/- in scientific literal notation (PR #6610 by @georgesittas)
  • :arrow_lower_right: fixes issue #6608 opened by @pjpjean
• 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)
  • :arrow_lower_right: fixes issue #6620 opened by @codetalker-ai
• 302fda0 - clickhouse: support and, or (PR #6625 by @AbhishekASLK)
• 00c80b1 - Parse joins with derived tables in UPDATE (PR #6632 by @VaggelisD)
  • :arrow_lower_right: fixes issue #6628 opened by @marktdodds
• 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)
  • :arrow_lower_right: fixes issue #6683 opened by @Hfuegl
• dcdee68 - spark: Allow non aggregation functions in PIVOT (PR #6687 by @VaggelisD)
  • :arrow_lower_right: fixes issue #6684 opened by @gauravdawar-e6
• 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)
  • :arrow_lower_right: fixes issue #6696 opened by @avinmathew
• 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)
  • :arrow_lower_right: fixes issue #6713 opened by @harshsinh

:recycle: Refactors

• 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)

:wrench: Chores

• 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)

:boom: BREAKING CHANGES

• 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)

:sparkles: New Features

• 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)

:bug: Bug Fixes

• 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)
  • :arrow_lower_right: fixes issue #6587 opened by @baruchoxman

:wrench: Chores

• ea0263a - Skip integration tests GA for external contributors & fix git diff (PR #6582 by @VaggelisD)

:boom: BREAKING CHANGES

• due to cfc9346 - bump sqlglotrs to 0.10.0 (commit by @tobymao):

  bump sqlglotrs to 0.10.0

:wrench: Chores

• cfc9346 - bump sqlglotrs to 0.10.0 (commit by @tobymao)

:boom: BREAKING CHANGES

• due to 938f4b6 - annotate type for LAST_DAY (PR #5528 by @geooo109):

  annotate type for LAST_DAY (#5528)

• due to 7d12dac - annotate type for bigquery GENERATE_TIMESTAMP_ARRAY (PR #5529 by @geooo109):

  annotate type for bigquery GENERATE_TIMESTAMP_ARRAY (#5529)

• due to d50ebe2 - annotate type for bigquery TIME_TRUNC (PR #5530 by @geooo109):

  annotate type for bigquery TIME_TRUNC (#5530)

• due to 29748be - annotate type for bigquery TIME (PR #5531 by @geooo109):

  annotate type for bigquery TIME (#5531)

• due to 7003b3f - parse and annotate type for bigquery DATE_FROM_UNIX_DATE (PR #5532 by @geooo109):

  parse and annotate type for bigquery DATE_FROM_UNIX_DATE (#5532)

• due to a276ca6 - parse and annotate type for bigquery JUSTIFY funcs (PR #5534 by @geooo109):

  parse and annotate type for bigquery JUSTIFY funcs (#5534)

• due to 374178e - parse and annotate type for bigquery UNIX_MICROS and UNIX_MILLIS (PR #5535 by @geooo109):

  parse and annotate type for bigquery UNIX_MICROS and UNIX_MILLIS (#5535)

• due to 1d8d1ab - annotate type for bigquery DATE_TRUNC (PR #5540 by @geooo109):

  annotate type for bigquery DATE_TRUNC (#5540)

• due to 306ba65 - annotate type for bigquery TIMESTAMP_TRUNC (PR #5541 by @geooo109):

  annotate type for bigquery TIMESTAMP_TRUNC (#5541)

• due to d799c5a - preserve projection names when merging subqueries (commit by @snovik75):

  preserve projection names when merging subqueries

• due to 8130bd4 - WEEKDAY of WEEK as VAR (PR #5552 by @geooo109):

  WEEKDAY of WEEK as VAR (#5552)

• due to f3ffe19 - annotate type for bigquery format_time (PR #5559 by @geooo109):

  annotate type for bigquery format_time (#5559)

• due to 6872b43 - use dialect in DataType.build fixes #5560 (commit by @georgesittas):

  use dialect in DataType.build fixes #5560

• due to 3ab3690 - parse and annotate type for bigquery PARSE_DATETIME (PR #5558 by @geooo109):

  parse and annotate type for bigquery PARSE_DATETIME (#5558)

• due to e5da951 - parse and annotate type for bigquery PARSE_TIME (PR #5561 by @geooo109):

  parse and annotate type for bigquery PARSE_TIME (#5561)

• due to 798e213 - improve transpilability of ANY_VALUE closes #5563 (commit by @georgesittas):

  improve transpilability of ANY_VALUE closes #5563

• due to 8c0cb76 - more robust CREATE SEQUENCE (PR #5566 by @geooo109):

  more robust CREATE SEQUENCE (#5566)

• due to c7041c7 - parse and annotate type for bigquery BYTE_LENGHT (PR #5568 by @geooo109):

  parse and annotate type for bigquery BYTE_LENGHT (#5568)

• due to a6c61c3 - parse and annotate type for bigquery CODE_POINTS_TO_STRING (PR #5569 by @geooo109):

  parse and annotate type for bigquery CODE_POINTS_TO_STRING (#5569)

• due to 51e0335 - parse and annotate type for bigquery REVERSE (PR #5571 by @geooo109):

  parse and annotate type for bigquery REVERSE (#5571)

• due to 2a33339 - annotate type for bigquery REPLACE (PR #5572 by @geooo109):

  annotate type for bigquery REPLACE (#5572)

• due to 1e6f813 - annotate type for bigquery REGEXP_EXTRACT_ALL (PR #5573 by @geooo109):

  annotate type for bigquery REGEXP_EXTRACT_ALL (#5573)

• due to d0d62ed - support TO_CHAR with numeric inputs (PR #5570 by @jasonthomassql):

  support TO_CHAR with numeric inputs (#5570)

• due to 7928985 - allow dashes in JSONPath keys (PR #5574 by @georgesittas):

  allow dashes in JSONPath keys (#5574)

• due to eb09e6e - parse and annotate type for bigquery TRANSLATE (PR #5575 by @geooo109):

  parse and annotate type for bigquery TRANSLATE (#5575)

• due to f9a522b - parse and annotate type for bigquery SOUNDEX (PR #5576 by @geooo109):

  parse and annotate type for bigquery SOUNDEX (#5576)

• due to 51da41b - annotate type for bigquery MD5 (PR #5577 by @geooo109):

  annotate type for bigquery MD5 (#5577)

• due to bcf302f - annotate type for bigquery MIN/MAX BY (PR #5579 by @geooo109):

  annotate type for bigquery MIN/MAX BY (#5579)

• due to c501d9e - parse and annotate type for bigquery GROUPING (PR #5581 by @geooo109):

  parse and annotate type for bigquery GROUPING (#5581)

• due to 7b180bd - raise if query modifier is specified multiple times (PR #5608 by @georgesittas):

  raise if query modifier is specified multiple times (#5608)

• due to 36602a2 - parse LIST_FILTER into ArrayFilter closes #5633 (commit by @georgesittas):

  parse LIST_FILTER into ArrayFilter closes #5633

• due to 0188d21 - parse LIST_TRANSFORM into Transform closes #5634 (commit by @georgesittas):

  parse LIST_TRANSFORM into Transform closes #5634

• due to 3ab1d44 - Wrap CONCAT items with COALESCE less aggressively (PR #5641 by @VaggelisD):

  Wrap CONCAT items with COALESCE less aggressively (#5641)

• due to af0b299 - Qualify columns generated by exp.Aliases (PR #5647 by @VaggelisD):

  Qualify columns generated by exp.Aliases (#5647)

• due to 53aa8fe - support alter table with check closes #5649 (commit by @georgesittas):

  support alter table with check closes #5649

• due to 1a60a5a - Added parsing/generation of JSON_ARRAY_CONTAINS function (PR #5661 by @AdalbertMemSQL):

  Added parsing/generation of JSON_ARRAY_CONTAINS function (#5661)

• due to e0db0a9 - add parse and annotate type for bigquery FARM_FINGERPRINT (PR #5667 by @geooo109):

  add parse and annotate type for bigquery FARM_FINGERPRINT (#5667)

• due to 56588c7 - Add support for vector_search function. Move predict to BigQuery dialect. (PR #5660 by @rloredo):

  Add support for vector_search function. Move predict to BigQuery dialect. (#5660)

• due to a688a0f - parse and annotate type for bigquery APPROX_TOP_COUNT (PR #5670 by @geooo109):

  parse and annotate type for bigquery APPROX_TOP_COUNT (#5670)

• due to 3c93fcc - parse and annotate type for bigquery APPROX_TOP_SUM (PR #5675 by @geooo109):

  parse and annotate type for bigquery APPROX_TOP_SUM (#5675)

• due to 741d45a - parse and annotate type for bigquery FROM/TO_BASE32 (PR #5676 by @geooo109):

  parse and annotate type for bigquery FROM/TO_BASE32 (#5676)

• due to 9ae045c - parse and annotate type for bigquery FROM_HEX (PR #5679 by @geooo109):

  parse and annotate type for bigquery FROM_HEX (#5679)

• due to 5a22a25 - annotate type for bigquery TO_HEX (PR #5680 by @geooo109):

  annotate type for bigquery TO_HEX (#5680)

• due to 5c1eb2d - parse and annotate type for bq PARSE_BIG/NUMERIC (PR #5690 by @geooo109):

  parse and annotate type for bq PARSE_BIG/NUMERIC (#5690)

• due to 311373d - parse and annotate type for bq CODE_POINTS_TO_BYTES (PR #5686 by @geooo109):

  parse and annotate type for bq CODE_POINTS_TO_BYTES (#5686)

• due to 79d9de1 - parse and annotate type for bq TO_CODE_POINTS (PR #5685 by @geooo109):

  parse and annotate type for bq TO_CODE_POINTS (#5685)

• due to 5df3ea9 - parse and annotate type for bq SAFE_CONVERT_BYTES_TO_STRING (PR #5681 by @geooo109):

  parse and annotate type for bq SAFE_CONVERT_BYTES_TO_STRING (#5681)

• due to c832746 - parse and annotate type for bigquery APPROX_QUANTILES (PR #5678 by @geooo109):

  parse and annotate type for bigquery APPROX_QUANTILES (#5678)

• due to 99e169e - parse and annotate type for bq BOOL (PR #5697 by @geooo109):

  parse and annotate type for bq BOOL (#5697)

• due to 3f31770 - parse and annotate type for bq FLOAT64 (PR #5700 by @geooo109):

  parse and annotate type for bq FLOAT64 (#5700)

• due to de2fe15 - annotate type for bq CONTAINS_SUBSTR (PR #5705 by @geooo109):

  annotate type for bq CONTAINS_SUBSTR (#5705)

• due to 770888f - annotate type for bq NORMALIZE (PR #5711 by @geooo109):

  annotate type for bq NORMALIZE (#5711)

• due to 506033f - parse and annotate type for bq NORMALIZE_AND_CASEFOLD (PR #5712 by @geooo109):

  parse and annotate type for bq NORMALIZE_AND_CASEFOLD (#5712)

• due to 848aea1 - parse and annotate type for bq OCTET_LENGTH (PR #5713 by @geooo109):

  parse and annotate type for bq OCTET_LENGTH (#5713)

• due to 727bf83 - add support for REVOKE DDL (PR #5703 by @newtonapple):

  add support for REVOKE DDL (#5703)

• due to baffd2c - parse and annotate type for bq REGEXP_INSTR (PR #5710 by @geooo109):

  parse and annotate type for bq REGEXP_INSTR (#5710)

• due to b79eb19 - annotate type for bq ROW_NUMBER (PR #5716 by @geooo109):

  annotate type for bq ROW_NUMBER (#5716)

• due to f709bef - annotate type for bq FIRST_VALUE (PR #5718 by @geooo109):

  annotate type for bq FIRST_VALUE (#5718)

• due to 15a9061 - annotate type for bq PERCENTILE_DISC (PR #5722 by @geooo109):

  annotate type for bq PERCENTILE_DISC (#5722)

• due to 7d49609 - annotate type for bq NTH_VALUE (PR #5720 by @geooo109):

  annotate type for bq NTH_VALUE (#5720)

• due to d41acf1 - annotate type for bq LEAD (PR #5719 by @geooo109):

  annotate type for bq LEAD (#5719)

• due to ff12130 - annotate type for bq PERNCENTILE_CONT (PR #5729 by @geooo109):

  annotate type for bq PERNCENTILE_CONT (#5729)

• due to fdb8a0a - parse and annotate type for bq FORMAT (PR #5715 by @geooo109):

  parse and annotate type for bq FORMAT (#5715)

• due to 012bdd3 - parse and annotate type for bq CUME_DIST (PR #5735 by @geooo109):

  parse and annotate type for bq CUME_DIST (#5735)

• due to b99eaeb - parse and annotate type for bq DENSE_RANK (PR #5736 by @geooo109):

  parse and annotate type for bq DENSE_RANK (#5736)

• due to bb95c73 - parse and annotate type for bq RANK (PR #5738 by @geooo109):

  parse and annotate type for bq RANK (#5738)

• due to 8713c08 - parse and annotate type for bq PERCENT_RANK (PR #5739 by @geooo109):

  parse and annotate type for bq PERCENT_RANK (#5739)

• due to 9ce4e31 - annotate type for bq JSON_OBJECT (PR #5740 by @geooo109):

  annotate type for bq JSON_OBJECT (#5740)

• due to d35ec6e - annotate type for bq JSON_QUERY/JSON_QUERY_ARRAY (PR #5741 by @geooo109):

  annotate type for bq JSON_QUERY/JSON_QUERY_ARRAY (#5741)

• due to 4753642 - annotate type for bq JSON_EXTRACT_SCALAR (commit by @geooo109):

  annotate type for bq JSON_EXTRACT_SCALAR

• due to 113a530 - parse and annotate type for bq JSON_ARRAY_APPEND (PR #5747 by @geooo109):

  parse and annotate type for bq JSON_ARRAY_APPEND (#5747)

• due to 268e2c6 - parse and annotate type for bq JSON_ARRAY_INSERT (PR #5748 by @geooo109):

  parse and annotate type for bq JSON_ARRAY_INSERT (#5748)

• due to 455ec1f - parse and annotate type for bq JSON_KEYS (PR #5749 by @geooo109):

  parse and annotate type for bq JSON_KEYS (#5749)

• due to 59895fa - parse and annotate type for bq JSON_REMOVE (PR #5750 by @geooo109):

  parse and annotate type for bq JSON_REMOVE (#5750)

• due to 06d7df7 - parse and annotate type for bq JSON_SET (PR #5751 by @geooo109):

  parse and annotate type for bq JSON_SET (#5751)

• due to e72b341 - parse and annotate type for bq JSON_STRIP_NULLS (PR #5753 by @geooo109):

  parse and annotate type for bq JSON_STRIP_NULLS (#5753)

• due to 5de61a7 - parse and annotate type for bq JSON_EXTRACT_STRING_ARRAY (PR #5758 by @geooo109):

  parse and annotate type for bq JSON_EXTRACT_STRING_ARRAY (#5758)

• due to 36c9393 - parse and annotate type for bq JSON LAX funcs (PR #5760 by @geooo109):

  parse and annotate type for bq JSON LAX funcs (#5760)

• due to 88862b5 - annotate type for bq TO_JSON_STRING (PR #5762 by @geooo109):

  annotate type for bq TO_JSON_STRING (#5762)

• due to 1c551d5 - parse and annotate type for bq TO_JSON (PR #5768 by @geooo109):

  parse and annotate type for bq TO_JSON (#5768)

• due to 1707f2d - annotate type for ABS (PR #5770 by @geooo109):

  annotate type for ABS (#5770)

• due to 69acc51 - annotate type for bq IS_INF, IS_NAN (PR #5771 by @geooo109):

  annotate type for bq IS_INF, IS_NAN (#5771)

• due to 0da2076 - annotate type for bq CBRT (PR #5772 by @geooo109):

  annotate type for bq CBRT (#5772)

• due to a4968cb - annotate type for bq RAND (PR #5774 by @geooo109):

  annotate type for bq RAND (#5774)

• due to 3e63350 - parse and annotate type for bq ACOS (PR #5776 by @geooo109):

  parse and annotate type for bq ACOS (#5776)

• due to 2be9d01 - parse and annotate type for bq ACOSH (PR #5779 by @geooo109):

  parse and annotate type for bq ACOSH (#5779)

• due to b77d3da - remove "EXCLUDE" -> TokenType.EXCEPT in DuckDB, Snowflake (PR #5766 by @treysp):

  remove "EXCLUDE" -> TokenType.EXCEPT in DuckDB, Snowflake (#5766)

• due to 7da2f31 - parse and annotate type for bq ASIN/H (PR #5783 by @geooo109):

  parse and annotate type for bq ASIN/H (#5783)

• due to 341ea83 - parse and annotate type for bq ATAN/H/2 (PR #5784 by @geooo109):

  parse and annotate type for bq ATAN/H/2 (#5784)

• due to aa360cb - use regexp_like as it exists (PR #5781 by @jasonthomassql):

  use regexp_like as it exists (#5781)

• due to c2a1ad4 - parse and annotate type for bq COT/H (PR #5786 by @geooo109):

  parse and annotate type for bq COT/H (#5786)

• due to 316ae91 - Added handling of UTC_DATE and exp.CurrentDate (PR #5785 by @AdalbertMemSQL):

  Added handling of UTC_DATE and exp.CurrentDate (#5785)

• due to 2c6d237 - parse and annotate type for bq CSC/H (PR #5787 by @geooo109):

  parse and annotate type for bq CSC/H (#5787)

• due to 8a35076 - parse and annotate type for bq SEC/H (PR #5788 by @geooo109):

  parse and annotate type for bq SEC/H (#5788)

• due to 79901cb - parse and annotate type for bq SIN\H (PR #5790 by @geooo109):

  parse and annotate type for bq SIN\H (#5790)

• due to 74fb547 - parse and annotate type for bq RANGE_BUCKET (PR #5793 by @geooo109):

  parse and annotate type for bq RANGE_BUCKET (#5793)

• due to eca65e8 - parse and annotate type for bq COSINE/EUCLIDEAN_DISTANCE (PR #5792 by @geooo109):

  parse and annotate type for bq COSINE/EUCLIDEAN_DISTANCE (#5792)

• due to a180d3f - parse and annotate type for bq SAFE math funcs (PR #5797 by @geooo109):

  parse and annotate type for bq SAFE math funcs (#5797)

• due to fc7ad7a - parse ALTER SESSION (PR #5734 by @tekumara):

  parse ALTER SESSION (#5734)

• due to 8ec1a6c - annotate type for bq STRING_AGG (PR #5798 by @geooo109):

  annotate type for bq STRING_AGG (#5798)

• due to dd97bfa - annotate type for bq DATETIME_TRUNC (PR #5799 by @geooo109):

  annotate type for bq DATETIME_TRUNC (#5799)

• due to d3e9dda - annotate type for bq GENERATE_UUID (commit by @geooo109):

  annotate type for bq GENERATE_UUID

• due to 3726b33 - support nulls_first arg for array_sort (PR #5802 by @treysp):

  support nulls_first arg for array_sort (#5802)

• due to cf1d1e3 - annotate type for snowflake's REVERSE function (PR #5803 by @fivetran-BradfordPaskewitz):

  annotate type for snowflake's REVERSE function (#5803)

• due to ad0b407 - Mark 'BEGIN' as TokenType.BEGIN for transactions (PR #5826 by @VaggelisD):

  Mark 'BEGIN' as TokenType.BEGIN for transactions (#5826)

• due to 0198282 - : Update tests for concat string function (PR #5809 by @fivetran-amrutabhimsenayachit):

  : Update tests for concat string function (#5809)

• due to db2c430 - annoate the "contains" function (PR #5829 by @fivetran-amrutabhimsenayachit):

  annoate the "contains" function (#5829)

• due to 9c8a600 - correct parsing of TO_VARCHAR (PR #5840 by @geooo109):

  correct parsing of TO_VARCHAR (#5840)

• due to 1e9aef1 - convert NULL annotations to UNKNOWN (PR #5842 by @georgesittas):

  convert NULL annotations to UNKNOWN (#5842)

• due to 44c9e70 - add tests for snowflake STARTSWITH function (PR #5847 by @fivetran-amrutabhimsenayachit):

  add tests for snowflake STARTSWITH function (#5847)

• due to 0779c2d - support BIT_X aggregates again for duckdb, postgres (PR #5851 by @georgesittas):

  support BIT_X aggregates again for duckdb, postgres (#5851)

• due to c50d6e3 - annotate type for snowflake LEFT, RIGHT and SUBSTRING functions (PR #5849 by @fivetran-amrutabhimsenayachit):

  annotate type for snowflake LEFT, RIGHT and SUBSTRING functions (#5849)

• due to e441e16 - make dump/pickling non-recursive to avoid hitting stack limits (PR #5850 by @tobymao):

  make dump/pickling non-recursive to avoid hitting stack limits (#5850)

• due to b128339 - annotate and add tests for snowflake LENGTH and LOWER functions (PR #5856 by @fivetran-amrutabhimsenayachit):

  annotate and add tests for snowflake LENGTH and LOWER functions (#5856)

• due to 134957a - annotate types for Snowflake TRIM function (PR #5811 by @fivetran-BradfordPaskewitz):

  annotate types for Snowflake TRIM function (#5811)

• due to d3cd6bf - Annotate and add tests for snowflake REPLACE and SPACE functions (PR #5871 by @fivetran-amrutabhimsenayachit):

  Annotate and add tests for snowflake REPLACE and SPACE functions (#5871)

• due to 96ae7a3 - Annotate and add tests for snowflake REPEAT and SPLIT functions (PR #5875 by @fivetran-amrutabhimsenayachit):

  Annotate and add tests for snowflake REPEAT and SPLIT functions (#5875)

• due to f2d3bf7 - annotate types for Snowflake UUID_STRING function (PR #5881 by @fivetran-BradfordPaskewitz):

  annotate types for Snowflake UUID_STRING function (#5881)

• due to ec80ff3 - make dump a list instead of a nested dict to avoid all recursion errors (PR #5885 by @tobymao):

  make dump a list instead of a nested dict to avoid all recursion errors (#5885)

• due to 2fdaccd - annotate types for Snowflake SHA1, SHA2 functions (PR #5884 by @fivetran-BradfordPaskewitz):

  annotate types for Snowflake SHA1, SHA2 functions (#5884)

• due to faba309 - annotate types for Snowflake AI_AGG function (PR #5894 by @fivetran-BradfordPaskewitz):

  annotate types for Snowflake AI_AGG function (#5894)

• due to 304bec5 - Annotate snowflake MD5 functions (PR #5883 by @fivetran-amrutabhimsenayachit):

  Annotate snowflake MD5 functions (#5883)

• due to c0180ec - annotate types for Snowflake AI_SUMMARIZE_AGG function (PR #5902 by @fivetran-BradfordPaskewitz):

  annotate types for Snowflake AI_SUMMARIZE_AGG function (#5902)

• due to f5409df - use column name in struct type annotation (PR #5903 by @georgesittas):

  use column name in struct type annotation (#5903)

• due to 5a973e9 - annotate types for Snowflake AI_CLASSIFY function (PR #5909 by @fivetran-BradfordPaskewitz):

  annotate types for Snowflake AI_CLASSIFY function (#5909)

• due to 2d0d908 - produce TableAlias instead of Alias for USING in merge builder (PR #5911 by @georgesittas):

  produce TableAlias instead of Alias for USING in merge builder (#5911)

• due to f4ad258 - Annotate types for Snowflake BASE64_DECODE_BINARY function (PR #5917 by @fivetran-amrutabhimsenayachit):

  Annotate types for Snowflake BASE64_DECODE_BINARY function (#5917)

• due to 6d0e3f8 - Add parser support to ilike like function versions. (PR #5915 by @fivetran-amrutabhimsenayachit):

  Add parser support to ilike like function versions. (#5915)

• due to 22c7ed7 - parse tuple (PR #5920 by @geooo109):

  parse tuple (#5920)

• due to fc5624e - annotate types for Snowflake ASCII function (PR #5926 by @fivetran-BradfordPaskewitz):

  annotate types for Snowflake ASCII function (#5926)

• due to 4e81690 - annotate type for Snowflake COLLATE function (PR #5931 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake COLLATE function (#5931)

• due to f07d35d - annotate type for Snowflake CHR function (PR #5929 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake CHR function (#5929)

• due to f8c0ee4 - Add function and annotate snowflake hex decode string and binary functions (PR #5928 by @fivetran-amrutabhimsenayachit):

  Add function and annotate snowflake hex decode string and binary functions (#5928)

• due to 66f9501 - annotate types for Snowflake BIT_LENGTH function (PR #5927 by @fivetran-BradfordPaskewitz):

  annotate types for Snowflake BIT_LENGTH function (#5927)

• due to 7878437 - annotate snowflake's BASE64_DECODE_STRING, BASE64_ENCODE (PR #5922 by @fivetran-amrutabhimsenayachit):

  annotate snowflake's BASE64_DECODE_STRING, BASE64_ENCODE (#5922)

• due to 9bcad04 - Annotate type for HEX ENCODE function. (PR #5936 by @fivetran-amrutabhimsenayachit):

  Annotate type for HEX ENCODE function. (#5936)

• due to 590928f - annotate type for Snowflake INITCAP function (PR #5941 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake INITCAP function (#5941)

• due to ac04de1 - annotate type for Snowflake EDITDISTANCE function (PR #5940 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake EDITDISTANCE function (#5940)

• due to 9e28af8 - Annotate type for snowflake COMPRESS function (PR #5938 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake COMPRESS function (#5938)

• due to 7f13eaf - Annotate type for snowflake DECOMPRESS_BINARY function (PR #5945 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake DECOMPRESS_BINARY function (#5945)

• due to be12b29 - Annotate type for snowflake DECOMPRESS_STRING function (PR #5947 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake DECOMPRESS_STRING function (#5947)

• due to 1573fef - annotate types for Snowflake JAROWINKLER_SIMILARITY function (PR #5950 by @fivetran-BradfordPaskewitz):

  annotate types for Snowflake JAROWINKLER_SIMILARITY function (#5950)

• due to 883c6ab - annotate type for Snowflake COLLATION function (PR #5939 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake COLLATION function (#5939)

• due to 68473ac - Annotate type for snowflake PARSE_URL function (PR #5962 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake PARSE_URL function (#5962)

• due to b015a9d - annotate type for Snowflake REGEXP_INSTR function (commit by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake REGEXP_INSTR function

• due to 1f29ba7 - annotate type for Snowflake PARSE_IP function (PR #5961 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake PARSE_IP function (#5961)

• due to bf45d5d - annotate types for Snowflake RTRIMMED_LENGTH function (PR #5968 by @fivetran-BradfordPaskewitz):

  annotate types for Snowflake RTRIMMED_LENGTH function (#5968)

• due to 13caa69 - Annotate type for snowflake POSITION function (PR #5964 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake POSITION function (#5964)

• due to 13a30df - Annotate type for snowflake TRY_BASE64_DECODE_BINARY function (PR #5972 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake TRY_BASE64_DECODE_BINARY function (#5972)

• due to 1f5fdd7 - Annotate type for snowflake TRY_BASE64_DECODE_STRING function (PR #5974 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake TRY_BASE64_DECODE_STRING function (#5974)

• due to 324e82f - Annotate type for snowflake TRY_HEX_DECODE_BINARY function (PR #5975 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake TRY_HEX_DECODE_BINARY function (#5975)

• due to 6caf99d - Annotate type for snowflake TRY_HEX_DECODE_STRING function (PR #5976 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake TRY_HEX_DECODE_STRING function (#5976)

• due to 73186a8 - annotate type for Snowflake REGEXP_COUNT function (PR #5963 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake REGEXP_COUNT function (#5963)

• due to c3bdb3c - array start index is 1, support array_flatten, fixes #5983 (commit by @georgesittas):

  array start index is 1, support array_flatten, fixes #5983

• due to 244fb48 - annotate type for Snowflake SPLIT_PART function (PR #5988 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake SPLIT_PART function (#5988)

• due to 0d772e0 - add ast node for DIRECTORY source (PR #5990 by @georgesittas):

  add ast node for DIRECTORY source (#5990)

• due to 3c7b5c0 - Annotate type for snowflake SOUNDEX_P123 function (PR #5987 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake SOUNDEX_P123 function (#5987)

• due to f25e42e - annotate type for Snowflake REGEXP_INSTR function (PR #5978 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake REGEXP_INSTR function (#5978)

• due to 13cb26e - annotate type for Snowflake REGEXP_SUBSTR_ALL function (PR #5979 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake REGEXP_SUBSTR_ALL function (#5979)

• due to 4ce683e - Annotate type for snowflake UNICODE function (PR #5993 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake UNICODE function (#5993)

• due to c7657fb - remove unalias_group_by transformation since it is unsafe (PR #5997 by @georgesittas):

  remove unalias_group_by transformation since it is unsafe (#5997)

• due to 587196c - Annotate type for snowflake STRTOK_TO_ARRAY function (PR #5994 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake STRTOK_TO_ARRAY function (#5994)

• due to bced710 - Annotate type for snowflake STRTOK function. (PR #5991 by @georgesittas):

  Annotate type for snowflake STRTOK function. (#5991)

• due to be1cdc8 - Fix roundtrip of ~ operator (PR #6017 by @VaggelisD):

  Fix roundtrip of ~ operator (#6017)

• due to 74a13f2 - Annotate type for snowflake DIV0 and DIVNULL functions (PR #6008 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake DIV0 and DIVNULL functions (#6008)

• due to fec2b31 - Annotate type for snowflake SEARCH function (PR #5985 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake SEARCH function (#5985)

• due to 27a76cd - Annotate type for snowflake COT, SIN and TAN functions (PR #6022 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake COT, SIN and TAN functions (#6022)

• due to 0911276 - annotate type for Snowflake EXP function (PR #6007 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake EXP function (#6007)

• due to a96d50e - annotate type for Snowflake COSH function (PR #6006 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake COSH function (#6006)

• due to 4df58e0 - annotate type for Snowflake DEGREES function (PR #6027 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake DEGREES function (#6027)

• due to db71a20 - annotate type for Snowflake COS function (PR #6028 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake COS function (#6028)

• due to 5dd2ed3 - bump sqlglotrs to 0.7.0 (commit by @georgesittas):

  bump sqlglotrs to 0.7.0

• due to 6beb917 - Annotate type for snowflake ROUND function (PR #6032 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake ROUND function (#6032)

• due to 0939d69 - move odbc date literal handling in t-sql closes #6037 (PR #6044 by @georgesittas):

  move odbc date literal handling in t-sql closes #6037 (#6044)

• due to 56c8b3b - Support CHANGE COLUMN statements in Hive and CHANGE/ALTER COLUMN statements in Spark (PR #6004 by @tsamaras):

  Support CHANGE COLUMN statements in Hive and CHANGE/ALTER COLUMN statements in Spark (#6004)

• due to 7ac01c2 - bump sqlglotrs to 0.7.1 (commit by @georgesittas):

  bump sqlglotrs to 0.7.1

• due to 6f31b86 - Annotate type for snowflake FLOOR function (PR #6030 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake FLOOR function (#6030)

• due to cecab2f - annotate type for Snowflake ATANH function (PR #6054 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake ATANH function (#6054)

• due to 08339a9 - annotate type for Snowflake FACTORIAL function (PR #6053 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake FACTORIAL function (#6053)

• due to 9060f60 - Annotate type for snowflake ATAN2 function. (PR #6060 by @fivetran-amrutabhimsenayachit):

  Annotate type for snowflake ATAN2 function. (#6060)

• due to b3eb2e4 - annotate type for Snowflake SINH function (PR #6052 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake SINH function (#6052)

• due to 157d2fa - annotate type for Snowflake CEIL function (PR #6051 by @fivetran-BradfordPaskewitz):

  annotate type for Snowflake CEIL function (#6051)

• due to e7833de - support DELETE with USING and multiple VALUES (PR #6072 by @geooo109):

  support DELETE with USING and multiple VALUES (#6072)

• due to [354140d](https://github.com/tobymao

:boom: BREAKING CHANGES

• due to 62b348c - add support for noop string escapes (PR #6526 by @nian0114):

  add support for noop string escapes (#6526)

• due to 1876c5a - consolidate can_quote logic and fix an issue with identify=False (PR #6534 by @tobymao):

  consolidate can_quote logic and fix an issue with identify=False (#6534)

• due to edb8964 - bump sqlglotrs to 0.9.0 (commit by @georgesittas):

  bump sqlglotrs to 0.9.0

:bug: Bug Fixes

• 62b348c - tokenizer: add support for noop string escapes (PR #6526 by @nian0114)

:recycle: Refactors

• 1876c5a - consolidate can_quote logic and fix an issue with identify=False (PR #6534 by @tobymao)

:wrench: Chores

• edb8964 - bump sqlglotrs to 0.9.0 (commit by @georgesittas)