tobymao/sqlglot (sqlglot)
### [`v23.16.0`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v23160---2024-05-18)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.10...v23.16.0)
##### :boom: BREAKING CHANGES
- due to [`e281db8`](https://togithub.com/tobymao/sqlglot/commit/e281db8784682649be305e9a05c45211402f107c) - Add ALTER TABLE SET *(PR [#3485](https://togithub.com/tobymao/sqlglot/pull/3485) by [@VaggelisD](https://togithub.com/VaggelisD))*:
Add ALTER TABLE SET ([#3485](https://togithub.com/tobymao/sqlglot/issues/3485))
##### :sparkles: New Features
- [`e281db8`](https://togithub.com/tobymao/sqlglot/commit/e281db8784682649be305e9a05c45211402f107c) - Add ALTER TABLE SET *(PR [#3485](https://togithub.com/tobymao/sqlglot/pull/3485) by [@VaggelisD](https://togithub.com/VaggelisD))*
- [`9aee21b`](https://togithub.com/tobymao/sqlglot/commit/9aee21b88e73809e2cdc4e48f04e16edcf1141d7) - add RETURNS NULL ON NULL and STRICT properties *(PR [#3504](https://togithub.com/tobymao/sqlglot/pull/3504) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *addresses issue [#3503](https://togithub.com/tobymao/sqlglot/issues/3503) opened by [@krzysztof-kwitt](https://togithub.com/krzysztof-kwitt)*
##### :wrench: Chores
- [`0896d11`](https://togithub.com/tobymao/sqlglot/commit/0896d113b94aaea82e90dd04cdf917dfa546d08e) - lint *(commit by [@tobymao](https://togithub.com/tobymao))*
### [`v23.15.10`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v231510---2024-05-17)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.9...v23.15.10)
##### :sparkles: New Features
- [`89c1d3a`](https://togithub.com/tobymao/sqlglot/commit/89c1d3a4dd3387576c384413b3a8991a2dd030de) - **clickhouse**: support generate TimestampTrunc, Variance, Stddev *(PR [#3489](https://togithub.com/tobymao/sqlglot/pull/3489) by [@longxiaofei](https://togithub.com/longxiaofei))*
##### :bug: Bug Fixes
- [`03879bb`](https://togithub.com/tobymao/sqlglot/commit/03879bb3249ee83cce34d629f1016575d3b932e3) - **postgres**: date_trunc supports time zone *(commit by [@georgesittas](https://togithub.com/georgesittas))*
- [`6e7f37a`](https://togithub.com/tobymao/sqlglot/commit/6e7f37af86a4f36ec47ea4ef3519e5c97376e090) - copy into pretty printing and default dialect *(PR [#3496](https://togithub.com/tobymao/sqlglot/pull/3496) by [@tobymao](https://togithub.com/tobymao))*
- [`e8600e2`](https://togithub.com/tobymao/sqlglot/commit/e8600e24370a131a0b375a1a9943fdf590968198) - property eq needs highest precedence *(commit by [@tobymao](https://togithub.com/tobymao))*
### [`v23.15.9`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v23159---2024-05-17)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.8...v23.15.9)
##### :boom: BREAKING CHANGES
- due to [`846d5cd`](https://togithub.com/tobymao/sqlglot/commit/846d5cd2fe85f836f5ad888e783fedfa2108d579) - set default precision / width for DECIMAL type *(PR [#3472](https://togithub.com/tobymao/sqlglot/pull/3472) by [@georgesittas](https://togithub.com/georgesittas))*:
set default precision / width for DECIMAL type ([#3472](https://togithub.com/tobymao/sqlglot/issues/3472))
- due to [`e3ff67b`](https://togithub.com/tobymao/sqlglot/commit/e3ff67b0327a217a0523f82e6a11940feab1a8ac) - preserve star clauses (EXCLUDE, RENAME, REPLACE) *(PR [#3477](https://togithub.com/tobymao/sqlglot/pull/3477) by [@georgesittas](https://togithub.com/georgesittas))*:
preserve star clauses (EXCLUDE, RENAME, REPLACE) ([#3477](https://togithub.com/tobymao/sqlglot/issues/3477))
- due to [`b417c80`](https://togithub.com/tobymao/sqlglot/commit/b417c80b4208df1b97363db53af42158aa97bbd6) - parse TININT into UTINYINT to improve transpilation *(PR [#3486](https://togithub.com/tobymao/sqlglot/pull/3486) by [@georgesittas](https://togithub.com/georgesittas))*:
parse TININT into UTINYINT to improve transpilation ([#3486](https://togithub.com/tobymao/sqlglot/issues/3486))
- due to [`54e31af`](https://togithub.com/tobymao/sqlglot/commit/54e31af7d86138662c9619d50b4ae2e68e04942b) - add DECLARE statement parsing *(PR [#3462](https://togithub.com/tobymao/sqlglot/pull/3462) by [@jlucas-fsp](https://togithub.com/jlucas-fsp))*:
add DECLARE statement parsing ([#3462](https://togithub.com/tobymao/sqlglot/issues/3462))
- due to [`7287bb9`](https://togithub.com/tobymao/sqlglot/commit/7287bb9bf578b2b3afaf25647f505b9d73040dc7) - nested cte ordering closes [#3488](https://togithub.com/tobymao/sqlglot/pull/3488) *(commit by [@tobymao](https://togithub.com/tobymao))*:
nested cte ordering closes [#3488](https://togithub.com/tobymao/sqlglot/issues/3488)
##### :sparkles: New Features
- [`2c29bf3`](https://togithub.com/tobymao/sqlglot/commit/2c29bf3b7a163b88754c4593996bbba9b3c791b6) - **snowflake**: add support for CREATE TAG DDL statement *(PR [#3473](https://togithub.com/tobymao/sqlglot/pull/3473) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *addresses issue [#3468](https://togithub.com/tobymao/sqlglot/issues/3468) opened by [@tekumara](https://togithub.com/tekumara)*
- [`2433993`](https://togithub.com/tobymao/sqlglot/commit/24339934167e651f2afd6966024e4d96ef55c677) - **transpiler**: handle different hex behavior for dialects *(PR [#3463](https://togithub.com/tobymao/sqlglot/pull/3463) by [@viplazylmht](https://togithub.com/viplazylmht))*
- :arrow_lower_right: *addresses issue [#3460](https://togithub.com/tobymao/sqlglot/issues/3460) opened by [@viplazylmht](https://togithub.com/viplazylmht)*
- [`0009e09`](https://togithub.com/tobymao/sqlglot/commit/0009e09b1a7f94f85985670a09bb0be92c673b46) - add epoch_ms of duckdb to other dialects *(PR [#3471](https://togithub.com/tobymao/sqlglot/pull/3471) by [@longxiaofei](https://togithub.com/longxiaofei))*
- [`461215b`](https://togithub.com/tobymao/sqlglot/commit/461215b259de98125ea6b09d7bd875edb3ccce75) - **clickhouse**: add support for PROJECTION in CREATE TABLE statement *(PR [#3465](https://togithub.com/tobymao/sqlglot/pull/3465) by [@GaliFFun](https://togithub.com/GaliFFun))*
- [`54e31af`](https://togithub.com/tobymao/sqlglot/commit/54e31af7d86138662c9619d50b4ae2e68e04942b) - **tsql**: add DECLARE statement parsing *(PR [#3462](https://togithub.com/tobymao/sqlglot/pull/3462) by [@jlucas-fsp](https://togithub.com/jlucas-fsp))*
- [`c811adb`](https://togithub.com/tobymao/sqlglot/commit/c811adb73e6f83265fedc26274c7d4b40f8a1c85) - snowflake array_construct_compact to spark *(commit by [@tobymao](https://togithub.com/tobymao))*
##### :bug: Bug Fixes
- [`58d5f2b`](https://togithub.com/tobymao/sqlglot/commit/58d5f2bece42acdda5f8c08d30e6f61a5e538d4c) - **presto**: fix parsing and generating hash functions presto/trino *(PR [#3459](https://togithub.com/tobymao/sqlglot/pull/3459) by [@viplazylmht](https://togithub.com/viplazylmht))*
- :arrow_lower_right: *fixes issue [#3458](https://togithub.com/tobymao/sqlglot/issues/3458) opened by [@viplazylmht](https://togithub.com/viplazylmht)*
- [`065281e`](https://togithub.com/tobymao/sqlglot/commit/065281e28be75597f3f97cee22995423ed483660) - **optimizer**: fix multiple bugs in unnest_subqueries, clean up test suite *(PR [#3464](https://togithub.com/tobymao/sqlglot/pull/3464) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *fixes issue [#3448](https://togithub.com/tobymao/sqlglot/issues/3448) opened by [@yesemsanthoshkumar](https://togithub.com/yesemsanthoshkumar)*
- [`80ba1e8`](https://togithub.com/tobymao/sqlglot/commit/80ba1e8786a6347b8f20f340c185a0b41d017c73) - preserve quotes for projections produced by the eliminate_qualify rule *(PR [#3470](https://togithub.com/tobymao/sqlglot/pull/3470) by [@aersam](https://togithub.com/aersam))*
- :arrow_lower_right: *fixes issue [#3467](https://togithub.com/tobymao/sqlglot/issues/3467) opened by [@aersam](https://togithub.com/aersam)*
- [`3bc1fbe`](https://togithub.com/tobymao/sqlglot/commit/3bc1fbed40d9d0d05f189ca60fdc7af19b815e8b) - make quoting of alias_or_name in eliminate_qualify more robust *(commit by [@georgesittas](https://togithub.com/georgesittas))*
- [`1843e9b`](https://togithub.com/tobymao/sqlglot/commit/1843e9b825da6e97bda8c7b4fffce40baf199af1) - allow parameters in user-defined types *(PR [#3474](https://togithub.com/tobymao/sqlglot/pull/3474) by [@georgesittas](https://togithub.com/georgesittas))*
- [`e004d2a`](https://togithub.com/tobymao/sqlglot/commit/e004d2a3d88ea77d34ecdb8290df1e73511e6b6c) - **duckdb**: preserve precedence of json extraction when converting to arrow syntax *(PR [#3478](https://togithub.com/tobymao/sqlglot/pull/3478) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *fixes issue [#3476](https://togithub.com/tobymao/sqlglot/issues/3476) opened by [@asiunov](https://togithub.com/asiunov)*
- [`e3ff67b`](https://togithub.com/tobymao/sqlglot/commit/e3ff67b0327a217a0523f82e6a11940feab1a8ac) - **snowflake**: preserve star clauses (EXCLUDE, RENAME, REPLACE) *(PR [#3477](https://togithub.com/tobymao/sqlglot/pull/3477) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *fixes issue [#3475](https://togithub.com/tobymao/sqlglot/issues/3475) opened by [@asiunov](https://togithub.com/asiunov)*
- [`428fd61`](https://togithub.com/tobymao/sqlglot/commit/428fd61574e10be9afab23ac711758b229cc174f) - **mysql**: generate CONCAT for DPipe *(PR [#3482](https://togithub.com/tobymao/sqlglot/pull/3482) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *fixes issue [#3481](https://togithub.com/tobymao/sqlglot/issues/3481) opened by [@Toms1999](https://togithub.com/Toms1999)*
- [`b417c80`](https://togithub.com/tobymao/sqlglot/commit/b417c80b4208df1b97363db53af42158aa97bbd6) - **tsql**: parse TININT into UTINYINT to improve transpilation *(PR [#3486](https://togithub.com/tobymao/sqlglot/pull/3486) by [@georgesittas](https://togithub.com/georgesittas))*
- [`a3ff49e`](https://togithub.com/tobymao/sqlglot/commit/a3ff49e93f2c6752f512192ca8b6b6ad18fc925a) - **presto**: fix DELETE DML statement for presto/trino *(PR [#3466](https://togithub.com/tobymao/sqlglot/pull/3466) by [@viplazylmht](https://togithub.com/viplazylmht))*
- [`7287bb9`](https://togithub.com/tobymao/sqlglot/commit/7287bb9bf578b2b3afaf25647f505b9d73040dc7) - nested cte ordering closes [#3488](https://togithub.com/tobymao/sqlglot/pull/3488) *(commit by [@tobymao](https://togithub.com/tobymao))*
- [`5b64475`](https://togithub.com/tobymao/sqlglot/commit/5b64475bfd2d6a0ddcb3d0adb60d06dca62421a0) - allow rollup to be used as an identifier *(PR [#3495](https://togithub.com/tobymao/sqlglot/pull/3495) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *fixes issue [#3494](https://togithub.com/tobymao/sqlglot/issues/3494) opened by [@dangoldin](https://togithub.com/dangoldin)*
##### :recycle: Refactors
- [`846d5cd`](https://togithub.com/tobymao/sqlglot/commit/846d5cd2fe85f836f5ad888e783fedfa2108d579) - **snowflake**: set default precision / width for DECIMAL type *(PR [#3472](https://togithub.com/tobymao/sqlglot/pull/3472) by [@georgesittas](https://togithub.com/georgesittas))*
- [`930f923`](https://togithub.com/tobymao/sqlglot/commit/930f923c6da182be33ad4c912b64ec052a63af30) - clean up Hex / LowerHex implementation *(PR [#3483](https://togithub.com/tobymao/sqlglot/pull/3483) by [@georgesittas](https://togithub.com/georgesittas))*
- [`883fcd7`](https://togithub.com/tobymao/sqlglot/commit/883fcd78645539a275b66472f0bd1dfe1d3d4401) - **presto**: make DELETE transpilation more robust *(PR [#3487](https://togithub.com/tobymao/sqlglot/pull/3487) by [@georgesittas](https://togithub.com/georgesittas))*
- [`49f7f85`](https://togithub.com/tobymao/sqlglot/commit/49f7f857634ae85547c805ac53911895407dd7cb) - **tsql**: handle TABLE more gracefully for DeclareItem *(commit by [@georgesittas](https://togithub.com/georgesittas))*
### [`v23.15.8`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v23158---2024-05-11)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.7...v23.15.8)
##### :boom: BREAKING CHANGES
- due to [`510f8b5`](https://togithub.com/tobymao/sqlglot/commit/510f8b5726c59a13284e9482dc47d488559e6c9e) - improve transpilation of TABLESAMPLE clause *(PR [#3457](https://togithub.com/tobymao/sqlglot/pull/3457) by [@georgesittas](https://togithub.com/georgesittas))*:
improve transpilation of TABLESAMPLE clause ([#3457](https://togithub.com/tobymao/sqlglot/issues/3457))
##### :sparkles: New Features
- [`510f8b5`](https://togithub.com/tobymao/sqlglot/commit/510f8b5726c59a13284e9482dc47d488559e6c9e) - improve transpilation of TABLESAMPLE clause *(PR [#3457](https://togithub.com/tobymao/sqlglot/pull/3457) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *addresses issue [#3456](https://togithub.com/tobymao/sqlglot/issues/3456) opened by [@whummer](https://togithub.com/whummer)*
- [`e28c959`](https://togithub.com/tobymao/sqlglot/commit/e28c959bf44208bdb3821b38c13fde59f1944fbb) - make create table cmd parsing less aggressive so that they can be used in sqlmesh [@if](https://togithub.com/if) macros *(commit by [@tobymao](https://togithub.com/tobymao))*
### [`v23.15.7`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v23157---2024-05-11)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.6...v23.15.7)
##### :wrench: Chores
- [`c3bb3da`](https://togithub.com/tobymao/sqlglot/commit/c3bb3da670d06cb2eef545a909635224b6e7c205) - change python-version to 3.11 for build-rs *(commit by [@georgesittas](https://togithub.com/georgesittas))*
### [`v23.15.6`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v23156---2024-05-11)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.5...v23.15.6)
##### :wrench: Chores
- [`cd8f568`](https://togithub.com/tobymao/sqlglot/commit/cd8f568dba53efe6b9883035c48a67134016e612) - fix rust deployment workflow bug *(commit by [@georgesittas](https://togithub.com/georgesittas))*
### [`v23.15.5`](https://togithub.com/tobymao/sqlglot/compare/v23.15.4...v23.15.5)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.4...v23.15.5)
### [`v23.15.4`](https://togithub.com/tobymao/sqlglot/compare/v23.15.3...v23.15.4)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.3...v23.15.4)
### [`v23.15.3`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v23153---2024-05-10)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.2...v23.15.3)
##### :wrench: Chores
- [`130255e`](https://togithub.com/tobymao/sqlglot/commit/130255ebc927c48b3d3e479e17c38269bd7d8056) - update rust *(commit by [@tobymao](https://togithub.com/tobymao))*
### [`v23.15.2`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v23152---2024-05-10)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.1...v23.15.2)
##### :sparkles: New Features
- [`116172a`](https://togithub.com/tobymao/sqlglot/commit/116172a41119e72aaf618a83761f73d52f0440d2) - add support for ON property in ALTER and DROP statements *(PR [#3450](https://togithub.com/tobymao/sqlglot/pull/3450) by [@GaliFFun](https://togithub.com/GaliFFun))*
- [`aa104fd`](https://togithub.com/tobymao/sqlglot/commit/aa104fd2ccd73a13ca60fa3de3296ed4c007e8da) - add semi colon comments *(commit by [@tobymao](https://togithub.com/tobymao))*
##### :bug: Bug Fixes
- [`2c62267`](https://togithub.com/tobymao/sqlglot/commit/2c62267e2ae908d10d8164f080bc66a133596bf6) - **bigquery**: fix SHA1 generator *(PR [#3453](https://togithub.com/tobymao/sqlglot/pull/3453) by [@viplazylmht](https://togithub.com/viplazylmht))*
- :arrow_lower_right: *fixes issue [#3451](https://togithub.com/tobymao/sqlglot/issues/3451) opened by [@viplazylmht](https://togithub.com/viplazylmht)*
- [`fb3dea9`](https://togithub.com/tobymao/sqlglot/commit/fb3dea9a803157b4684cd62e2ef0b6a6b612f7e1) - **clickhouse**: fix parsing and generating hash functions *(PR [#3454](https://togithub.com/tobymao/sqlglot/pull/3454) by [@viplazylmht](https://togithub.com/viplazylmht))*
- :arrow_lower_right: *fixes issue [#3452](https://togithub.com/tobymao/sqlglot/issues/3452) opened by [@viplazylmht](https://togithub.com/viplazylmht)*
- [`b76dfda`](https://togithub.com/tobymao/sqlglot/commit/b76dfda7b4122a59c52bcbb445cffc6617e68b8c) - **snowflake**: COPY Subquery postfix *(PR [#3449](https://togithub.com/tobymao/sqlglot/pull/3449) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *fixes issue [#3434](https://togithub.com/tobymao/sqlglot/issues/3434) opened by [@whummer](https://togithub.com/whummer)*
##### :wrench: Chores
- [`684df5f`](https://togithub.com/tobymao/sqlglot/commit/684df5f7e11bb89def9ff71da0913de222bdaf3c) - remove unnecessary set_op *(commit by [@tobymao](https://togithub.com/tobymao))*
### [`v23.15.1`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v231510---2024-05-17)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.0...v23.15.1)
##### :sparkles: New Features
- [`89c1d3a`](https://togithub.com/tobymao/sqlglot/commit/89c1d3a4dd3387576c384413b3a8991a2dd030de) - **clickhouse**: support generate TimestampTrunc, Variance, Stddev *(PR [#3489](https://togithub.com/tobymao/sqlglot/pull/3489) by [@longxiaofei](https://togithub.com/longxiaofei))*
##### :bug: Bug Fixes
- [`03879bb`](https://togithub.com/tobymao/sqlglot/commit/03879bb3249ee83cce34d629f1016575d3b932e3) - **postgres**: date_trunc supports time zone *(commit by [@georgesittas](https://togithub.com/georgesittas))*
- [`6e7f37a`](https://togithub.com/tobymao/sqlglot/commit/6e7f37af86a4f36ec47ea4ef3519e5c97376e090) - copy into pretty printing and default dialect *(PR [#3496](https://togithub.com/tobymao/sqlglot/pull/3496) by [@tobymao](https://togithub.com/tobymao))*
- [`e8600e2`](https://togithub.com/tobymao/sqlglot/commit/e8600e24370a131a0b375a1a9943fdf590968198) - property eq needs highest precedence *(commit by [@tobymao](https://togithub.com/tobymao))*
### [`v23.15.0`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v23150---2024-05-09)
[Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.14.0...v23.15.0)
##### :boom: BREAKING CHANGES
- due to [`9338ebc`](https://togithub.com/tobymao/sqlglot/commit/9338ebc6dc9635f12639b562ee2af140cf708b6b) - tsql drop view no catalog *(commit by [@tobymao](https://togithub.com/tobymao))*:
tsql drop view no catalog
##### :sparkles: New Features
- [`80670bb`](https://togithub.com/tobymao/sqlglot/commit/80670bbd1e062cc476dcee17d0b9972ff7dc0424) - **snowflake**: Support for APPROX_PERCENTILE *(PR [#3426](https://togithub.com/tobymao/sqlglot/pull/3426) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *addresses issue [#3424](https://togithub.com/tobymao/sqlglot/issues/3424) opened by [@baruchoxman](https://togithub.com/baruchoxman)*
- [`b46c5b3`](https://togithub.com/tobymao/sqlglot/commit/b46c5b3ddaed359fb59264f00d7033c7b36bd9a4) - **clickhouse**: add support for partition expression *(PR [#3428](https://togithub.com/tobymao/sqlglot/pull/3428) by [@GaliFFun](https://togithub.com/GaliFFun))*
- [`07badc9`](https://togithub.com/tobymao/sqlglot/commit/07badc9d155cfd6d0c70e4419ed763b8c52b4973) - **clickhouse**: add support for ALTER TABLE REPLACE PARTITION statement *(PR [#3441](https://togithub.com/tobymao/sqlglot/pull/3441) by [@GaliFFun](https://togithub.com/GaliFFun))*
- [`baf39e7`](https://togithub.com/tobymao/sqlglot/commit/baf39e78cdebf5478b59f83120c43b39b27d1a31) - **redshift**: improve ALTER TABLE .. ALTER .. support *(PR [#3444](https://togithub.com/tobymao/sqlglot/pull/3444) by [@georgesittas](https://togithub.com/georgesittas))*
##### :bug: Bug Fixes
- [`e8014e2`](https://togithub.com/tobymao/sqlglot/commit/e8014e2a479c37ef75510e7d5ca90ed30522ce60) - **mysql**: Parse REPLACE statement as Command *(PR [#3425](https://togithub.com/tobymao/sqlglot/pull/3425) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *fixes issue [#3423](https://togithub.com/tobymao/sqlglot/issues/3423) opened by [@DyCheer](https://togithub.com/DyCheer)*
- [`273731f`](https://togithub.com/tobymao/sqlglot/commit/273731fd8cba4d6bda0d7ce109f25c49de0ec95c) - **snowflake**: parse CREATE SEQUENCE with commas *(PR [#3436](https://togithub.com/tobymao/sqlglot/pull/3436) by [@georgesittas](https://togithub.com/georgesittas))*
- :arrow_lower_right: *fixes issue [#3435](https://togithub.com/tobymao/sqlglot/issues/3435) opened by [@whummer](https://togithub.com/whummer)*
- [`761ba6f`](https://togithub.com/tobymao/sqlglot/commit/761ba6fb507158d4e5ea51ca396809be91c11ebf) - don't generate connector comments when comments=False closes [#3439](https://togithub.com/tobymao/sqlglot/pull/3439) *(commit by [@georgesittas](https://togithub.com/georgesittas))*
- [`a2a6eaa`](https://togithub.com/tobymao/sqlglot/commit/a2a6eaa5d7ace2879ded7c3a4cf4192b75c07f26) - handle empty string in connector comment padding *(PR [#3437](https://togithub.com/tobymao/sqlglot/pull/3437) by [@uncledata](https://togithub.com/uncledata))*
- [`1bc0ce5`](https://togithub.com/tobymao/sqlglot/commit/1bc0ce57eca5e401a4c39237b52ee722bdfb46af) - func to binary MOD generation *(PR [#3440](https://togithub.com/tobymao/sqlglot/pull/3440) by [@VaggelisD](https://togithub.com/VaggelisD))*
- :arrow_lower_right: *fixes issue [#3431](https://togithub.com/tobymao/sqlglot/issues/3431) opened by [@daniel769](https://togithub.com/daniel769)*
- [`5cfb29c`](https://togithub.com/tobymao/sqlglot/commit/5cfb29c7ff6015e39d7fd5b94ed2aa66436e33ae) - **bigquery**: MOD edge case *(commit by [@georgesittas](https://togithub.com/georgesittas))*
- [`9825c4c`](https://togithub.com/tobymao/sqlglot/commit/9825c4cb616af07a048109c499666081bc6e4eba) - improve error handling for nested schema levels *(PR [#3445](https://togithub.com/tobymao/sqlglot/pull/3445) by [@tobymao](https://togithub.com/tobymao))*
- [`c309def`](https://togithub.com/tobymao/sqlglot/commit/c309defa450f755dbed1d1b6f276b4b1765166e2) - **duckdb**: use name sequence instead of single \_t for unnest alias *(PR [#3446](https://togithub.com/tobymao/sqlglot/pull/3446) by [@georgesittas](https://togithub.com/georgesittas))*
- [`0927ae3`](https://togithub.com/tobymao/sqlglot/commit/0927ae3c448ebf068b89bfa5e46b8f135121b470) - **executor**: use timezone-aware object to represent datetime in UTC *(PR [#3447](https://togithub.com/tobymao/sqlglot/pull/3447) by [@georgesittas](https://togithub.com/georgesittas))*
- [`9338ebc`](https://togithub.com/tobymao/sqlglot/commit/9338ebc6dc9635f12639b562ee2af140cf708b6b) - tsql drop view no catalog *(commit by [@tobymao](https://togithub.com/tobymao))*
##### :wrench: Chores
- [`30f9d30`](https://togithub.com/tobymao/sqlglot/commit/30f9d30d8ab3727a43b1e6f363f28631cbfa7f92) - bump ruff to 0.4.3 *(PR [#3430](https://togithub.com/tobymao/sqlglot/pull/3430) by [@georgesittas](https://togithub.com/georgesittas))*
- [`91bed56`](https://togithub.com/tobymao/sqlglot/commit/91bed5607e442d416021a1f93e4a457fb47b6a1f) - test 3.12 *(commit by [@tobymao](https://togithub.com/tobymao))*
Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
[ ] If you want to rebase/retry this PR, check this box
This PR has been generated by Mend Renovate. View repository job log here.
This PR contains the following updates:
>=23.14.0,<23.15
->>=23.14.0,<23.17
Release Notes
tobymao/sqlglot (sqlglot)
### [`v23.16.0`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v23160---2024-05-18) [Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.10...v23.16.0) ##### :boom: BREAKING CHANGES - due to [`e281db8`](https://togithub.com/tobymao/sqlglot/commit/e281db8784682649be305e9a05c45211402f107c) - Add ALTER TABLE SET *(PR [#3485](https://togithub.com/tobymao/sqlglot/pull/3485) by [@VaggelisD](https://togithub.com/VaggelisD))*: Add ALTER TABLE SET ([#3485](https://togithub.com/tobymao/sqlglot/issues/3485)) ##### :sparkles: New Features - [`e281db8`](https://togithub.com/tobymao/sqlglot/commit/e281db8784682649be305e9a05c45211402f107c) - Add ALTER TABLE SET *(PR [#3485](https://togithub.com/tobymao/sqlglot/pull/3485) by [@VaggelisD](https://togithub.com/VaggelisD))* - [`9aee21b`](https://togithub.com/tobymao/sqlglot/commit/9aee21b88e73809e2cdc4e48f04e16edcf1141d7) - add RETURNS NULL ON NULL and STRICT properties *(PR [#3504](https://togithub.com/tobymao/sqlglot/pull/3504) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *addresses issue [#3503](https://togithub.com/tobymao/sqlglot/issues/3503) opened by [@krzysztof-kwitt](https://togithub.com/krzysztof-kwitt)* ##### :wrench: Chores - [`0896d11`](https://togithub.com/tobymao/sqlglot/commit/0896d113b94aaea82e90dd04cdf917dfa546d08e) - lint *(commit by [@tobymao](https://togithub.com/tobymao))* ### [`v23.15.10`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v231510---2024-05-17) [Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.9...v23.15.10) ##### :sparkles: New Features - [`89c1d3a`](https://togithub.com/tobymao/sqlglot/commit/89c1d3a4dd3387576c384413b3a8991a2dd030de) - **clickhouse**: support generate TimestampTrunc, Variance, Stddev *(PR [#3489](https://togithub.com/tobymao/sqlglot/pull/3489) by [@longxiaofei](https://togithub.com/longxiaofei))* ##### :bug: Bug Fixes - [`03879bb`](https://togithub.com/tobymao/sqlglot/commit/03879bb3249ee83cce34d629f1016575d3b932e3) - **postgres**: date_trunc supports time zone *(commit by [@georgesittas](https://togithub.com/georgesittas))* - [`6e7f37a`](https://togithub.com/tobymao/sqlglot/commit/6e7f37af86a4f36ec47ea4ef3519e5c97376e090) - copy into pretty printing and default dialect *(PR [#3496](https://togithub.com/tobymao/sqlglot/pull/3496) by [@tobymao](https://togithub.com/tobymao))* - [`e8600e2`](https://togithub.com/tobymao/sqlglot/commit/e8600e24370a131a0b375a1a9943fdf590968198) - property eq needs highest precedence *(commit by [@tobymao](https://togithub.com/tobymao))* ### [`v23.15.9`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v23159---2024-05-17) [Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.15.8...v23.15.9) ##### :boom: BREAKING CHANGES - due to [`846d5cd`](https://togithub.com/tobymao/sqlglot/commit/846d5cd2fe85f836f5ad888e783fedfa2108d579) - set default precision / width for DECIMAL type *(PR [#3472](https://togithub.com/tobymao/sqlglot/pull/3472) by [@georgesittas](https://togithub.com/georgesittas))*: set default precision / width for DECIMAL type ([#3472](https://togithub.com/tobymao/sqlglot/issues/3472)) - due to [`e3ff67b`](https://togithub.com/tobymao/sqlglot/commit/e3ff67b0327a217a0523f82e6a11940feab1a8ac) - preserve star clauses (EXCLUDE, RENAME, REPLACE) *(PR [#3477](https://togithub.com/tobymao/sqlglot/pull/3477) by [@georgesittas](https://togithub.com/georgesittas))*: preserve star clauses (EXCLUDE, RENAME, REPLACE) ([#3477](https://togithub.com/tobymao/sqlglot/issues/3477)) - due to [`b417c80`](https://togithub.com/tobymao/sqlglot/commit/b417c80b4208df1b97363db53af42158aa97bbd6) - parse TININT into UTINYINT to improve transpilation *(PR [#3486](https://togithub.com/tobymao/sqlglot/pull/3486) by [@georgesittas](https://togithub.com/georgesittas))*: parse TININT into UTINYINT to improve transpilation ([#3486](https://togithub.com/tobymao/sqlglot/issues/3486)) - due to [`54e31af`](https://togithub.com/tobymao/sqlglot/commit/54e31af7d86138662c9619d50b4ae2e68e04942b) - add DECLARE statement parsing *(PR [#3462](https://togithub.com/tobymao/sqlglot/pull/3462) by [@jlucas-fsp](https://togithub.com/jlucas-fsp))*: add DECLARE statement parsing ([#3462](https://togithub.com/tobymao/sqlglot/issues/3462)) - due to [`7287bb9`](https://togithub.com/tobymao/sqlglot/commit/7287bb9bf578b2b3afaf25647f505b9d73040dc7) - nested cte ordering closes [#3488](https://togithub.com/tobymao/sqlglot/pull/3488) *(commit by [@tobymao](https://togithub.com/tobymao))*: nested cte ordering closes [#3488](https://togithub.com/tobymao/sqlglot/issues/3488) ##### :sparkles: New Features - [`2c29bf3`](https://togithub.com/tobymao/sqlglot/commit/2c29bf3b7a163b88754c4593996bbba9b3c791b6) - **snowflake**: add support for CREATE TAG DDL statement *(PR [#3473](https://togithub.com/tobymao/sqlglot/pull/3473) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *addresses issue [#3468](https://togithub.com/tobymao/sqlglot/issues/3468) opened by [@tekumara](https://togithub.com/tekumara)* - [`2433993`](https://togithub.com/tobymao/sqlglot/commit/24339934167e651f2afd6966024e4d96ef55c677) - **transpiler**: handle different hex behavior for dialects *(PR [#3463](https://togithub.com/tobymao/sqlglot/pull/3463) by [@viplazylmht](https://togithub.com/viplazylmht))* - :arrow_lower_right: *addresses issue [#3460](https://togithub.com/tobymao/sqlglot/issues/3460) opened by [@viplazylmht](https://togithub.com/viplazylmht)* - [`0009e09`](https://togithub.com/tobymao/sqlglot/commit/0009e09b1a7f94f85985670a09bb0be92c673b46) - add epoch_ms of duckdb to other dialects *(PR [#3471](https://togithub.com/tobymao/sqlglot/pull/3471) by [@longxiaofei](https://togithub.com/longxiaofei))* - [`461215b`](https://togithub.com/tobymao/sqlglot/commit/461215b259de98125ea6b09d7bd875edb3ccce75) - **clickhouse**: add support for PROJECTION in CREATE TABLE statement *(PR [#3465](https://togithub.com/tobymao/sqlglot/pull/3465) by [@GaliFFun](https://togithub.com/GaliFFun))* - [`54e31af`](https://togithub.com/tobymao/sqlglot/commit/54e31af7d86138662c9619d50b4ae2e68e04942b) - **tsql**: add DECLARE statement parsing *(PR [#3462](https://togithub.com/tobymao/sqlglot/pull/3462) by [@jlucas-fsp](https://togithub.com/jlucas-fsp))* - [`c811adb`](https://togithub.com/tobymao/sqlglot/commit/c811adb73e6f83265fedc26274c7d4b40f8a1c85) - snowflake array_construct_compact to spark *(commit by [@tobymao](https://togithub.com/tobymao))* ##### :bug: Bug Fixes - [`58d5f2b`](https://togithub.com/tobymao/sqlglot/commit/58d5f2bece42acdda5f8c08d30e6f61a5e538d4c) - **presto**: fix parsing and generating hash functions presto/trino *(PR [#3459](https://togithub.com/tobymao/sqlglot/pull/3459) by [@viplazylmht](https://togithub.com/viplazylmht))* - :arrow_lower_right: *fixes issue [#3458](https://togithub.com/tobymao/sqlglot/issues/3458) opened by [@viplazylmht](https://togithub.com/viplazylmht)* - [`065281e`](https://togithub.com/tobymao/sqlglot/commit/065281e28be75597f3f97cee22995423ed483660) - **optimizer**: fix multiple bugs in unnest_subqueries, clean up test suite *(PR [#3464](https://togithub.com/tobymao/sqlglot/pull/3464) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3448](https://togithub.com/tobymao/sqlglot/issues/3448) opened by [@yesemsanthoshkumar](https://togithub.com/yesemsanthoshkumar)* - [`80ba1e8`](https://togithub.com/tobymao/sqlglot/commit/80ba1e8786a6347b8f20f340c185a0b41d017c73) - preserve quotes for projections produced by the eliminate_qualify rule *(PR [#3470](https://togithub.com/tobymao/sqlglot/pull/3470) by [@aersam](https://togithub.com/aersam))* - :arrow_lower_right: *fixes issue [#3467](https://togithub.com/tobymao/sqlglot/issues/3467) opened by [@aersam](https://togithub.com/aersam)* - [`3bc1fbe`](https://togithub.com/tobymao/sqlglot/commit/3bc1fbed40d9d0d05f189ca60fdc7af19b815e8b) - make quoting of alias_or_name in eliminate_qualify more robust *(commit by [@georgesittas](https://togithub.com/georgesittas))* - [`1843e9b`](https://togithub.com/tobymao/sqlglot/commit/1843e9b825da6e97bda8c7b4fffce40baf199af1) - allow parameters in user-defined types *(PR [#3474](https://togithub.com/tobymao/sqlglot/pull/3474) by [@georgesittas](https://togithub.com/georgesittas))* - [`e004d2a`](https://togithub.com/tobymao/sqlglot/commit/e004d2a3d88ea77d34ecdb8290df1e73511e6b6c) - **duckdb**: preserve precedence of json extraction when converting to arrow syntax *(PR [#3478](https://togithub.com/tobymao/sqlglot/pull/3478) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3476](https://togithub.com/tobymao/sqlglot/issues/3476) opened by [@asiunov](https://togithub.com/asiunov)* - [`e3ff67b`](https://togithub.com/tobymao/sqlglot/commit/e3ff67b0327a217a0523f82e6a11940feab1a8ac) - **snowflake**: preserve star clauses (EXCLUDE, RENAME, REPLACE) *(PR [#3477](https://togithub.com/tobymao/sqlglot/pull/3477) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3475](https://togithub.com/tobymao/sqlglot/issues/3475) opened by [@asiunov](https://togithub.com/asiunov)* - [`428fd61`](https://togithub.com/tobymao/sqlglot/commit/428fd61574e10be9afab23ac711758b229cc174f) - **mysql**: generate CONCAT for DPipe *(PR [#3482](https://togithub.com/tobymao/sqlglot/pull/3482) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3481](https://togithub.com/tobymao/sqlglot/issues/3481) opened by [@Toms1999](https://togithub.com/Toms1999)* - [`b417c80`](https://togithub.com/tobymao/sqlglot/commit/b417c80b4208df1b97363db53af42158aa97bbd6) - **tsql**: parse TININT into UTINYINT to improve transpilation *(PR [#3486](https://togithub.com/tobymao/sqlglot/pull/3486) by [@georgesittas](https://togithub.com/georgesittas))* - [`a3ff49e`](https://togithub.com/tobymao/sqlglot/commit/a3ff49e93f2c6752f512192ca8b6b6ad18fc925a) - **presto**: fix DELETE DML statement for presto/trino *(PR [#3466](https://togithub.com/tobymao/sqlglot/pull/3466) by [@viplazylmht](https://togithub.com/viplazylmht))* - [`7287bb9`](https://togithub.com/tobymao/sqlglot/commit/7287bb9bf578b2b3afaf25647f505b9d73040dc7) - nested cte ordering closes [#3488](https://togithub.com/tobymao/sqlglot/pull/3488) *(commit by [@tobymao](https://togithub.com/tobymao))* - [`5b64475`](https://togithub.com/tobymao/sqlglot/commit/5b64475bfd2d6a0ddcb3d0adb60d06dca62421a0) - allow rollup to be used as an identifier *(PR [#3495](https://togithub.com/tobymao/sqlglot/pull/3495) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3494](https://togithub.com/tobymao/sqlglot/issues/3494) opened by [@dangoldin](https://togithub.com/dangoldin)* ##### :recycle: Refactors - [`846d5cd`](https://togithub.com/tobymao/sqlglot/commit/846d5cd2fe85f836f5ad888e783fedfa2108d579) - **snowflake**: set default precision / width for DECIMAL type *(PR [#3472](https://togithub.com/tobymao/sqlglot/pull/3472) by [@georgesittas](https://togithub.com/georgesittas))* - [`930f923`](https://togithub.com/tobymao/sqlglot/commit/930f923c6da182be33ad4c912b64ec052a63af30) - clean up Hex / LowerHex implementation *(PR [#3483](https://togithub.com/tobymao/sqlglot/pull/3483) by [@georgesittas](https://togithub.com/georgesittas))* - [`883fcd7`](https://togithub.com/tobymao/sqlglot/commit/883fcd78645539a275b66472f0bd1dfe1d3d4401) - **presto**: make DELETE transpilation more robust *(PR [#3487](https://togithub.com/tobymao/sqlglot/pull/3487) by [@georgesittas](https://togithub.com/georgesittas))* - [`49f7f85`](https://togithub.com/tobymao/sqlglot/commit/49f7f857634ae85547c805ac53911895407dd7cb) - **tsql**: handle TABLEConfiguration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR has been generated by Mend Renovate. View repository job log here.