renovate[bot]
commented
2 weeks ago Edited/Blocked Notification
Renovate will not automatically rebase this PR, because it does not recognize the last commit author and assumes somebody else may have edited the PR.
You can manually request rebase by checking the rebase/retry box above.
⚠ Warning: custom changes will be lost.
This PR contains the following updates:
>=23.4,<23.13->>=23.4,<23.14Release Notes
tobymao/sqlglot (sqlglot)
### [`v23.13.1`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v23131---2024-05-04) [Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.13.0...v23.13.1) ##### :bug: Bug Fixes - [`2c2a788`](https://togithub.com/tobymao/sqlglot/commit/2c2a788bb3a5a46e7729a117a6e6b62d33beb020) - **snowflake**: COPY postfix *(PR [#3398](https://togithub.com/tobymao/sqlglot/pull/3398) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#3388](https://togithub.com/tobymao/sqlglot/issues/3388) opened by [@dangoldin](https://togithub.com/dangoldin)* ### [`v23.13.0`](https://togithub.com/tobymao/sqlglot/blob/HEAD/CHANGELOG.md#v23130---2024-05-03) [Compare Source](https://togithub.com/tobymao/sqlglot/compare/v23.12.2...v23.13.0) ##### :boom: BREAKING CHANGES - due to [`cc6259d`](https://togithub.com/tobymao/sqlglot/commit/cc6259de3d68831ded31bfb7fafe1ce654aa89dd) - Mark UDTF child scopes as ScopeType.SUBQUERY *(PR [#3390](https://togithub.com/tobymao/sqlglot/pull/3390) by [@VaggelisD](https://togithub.com/VaggelisD))*: Mark UDTF child scopes as ScopeType.SUBQUERY ([#3390](https://togithub.com/tobymao/sqlglot/issues/3390)) - due to [`33bae9b`](https://togithub.com/tobymao/sqlglot/commit/33bae9b527b27f02dfafff3f45534f85aa9e0d9d) - get rid of superfluous "parameters" arg in RegexpReplace *(PR [#3394](https://togithub.com/tobymao/sqlglot/pull/3394) by [@georgesittas](https://togithub.com/georgesittas))*: get rid of superfluous "parameters" arg in RegexpReplace ([#3394](https://togithub.com/tobymao/sqlglot/issues/3394)) - due to [`3768514`](https://togithub.com/tobymao/sqlglot/commit/3768514e3b2f256b69553e173b40f17180744ab0) - snowflake optional merge insert *(commit by [@tobymao](https://togithub.com/tobymao))*: snowflake optional merge insert - due to [`d1b4f1f`](https://togithub.com/tobymao/sqlglot/commit/d1b4f1f256cd772bec366d6bf13d9589e1fdfc4b) - Introducing TIMESTAMP_NTZ token and data type *(PR [#3386](https://togithub.com/tobymao/sqlglot/pull/3386) by [@VaggelisD](https://togithub.com/VaggelisD))*: Introducing TIMESTAMP_NTZ token and data type ([#3386](https://togithub.com/tobymao/sqlglot/issues/3386)) ##### :sparkles: New Features - [`d1b4f1f`](https://togithub.com/tobymao/sqlglot/commit/d1b4f1f256cd772bec366d6bf13d9589e1fdfc4b) - Introducing TIMESTAMP_NTZ token and data type *(PR [#3386](https://togithub.com/tobymao/sqlglot/pull/3386) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *addresses issue [#3379](https://togithub.com/tobymao/sqlglot/issues/3379) opened by [@aersam](https://togithub.com/aersam)* - [`16691f9`](https://togithub.com/tobymao/sqlglot/commit/16691f962822a132e233d61c2b67ec0fc3da51eb) - **prql**: add support for AGGREGATE *(PR [#3395](https://togithub.com/tobymao/sqlglot/pull/3395) by [@fool1280](https://togithub.com/fool1280))* - [`534fb80`](https://togithub.com/tobymao/sqlglot/commit/534fb80462370b5236061472496c35a16e9bab4a) - **postgres**: add support for anonymos index DDL syntax *(PR [#3403](https://togithub.com/tobymao/sqlglot/pull/3403) by [@georgesittas](https://togithub.com/georgesittas))* ##### :bug: Bug Fixes - [`a2afcca`](https://togithub.com/tobymao/sqlglot/commit/a2afccafd300939eaa5a3b075820f3bf8e8dcaac) - **mysql**: don't cast into invalid numeric/text types *(PR [#3375](https://togithub.com/tobymao/sqlglot/pull/3375) by [@georgesittas](https://togithub.com/georgesittas))* - [`60b5c3b`](https://togithub.com/tobymao/sqlglot/commit/60b5c3b1b5dfb4aa00754f4b2473ad054b8dd14a) - **spark**: transpile presto TRY, fix JSON casting issue *(PR [#3376](https://togithub.com/tobymao/sqlglot/pull/3376) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3374](https://togithub.com/tobymao/sqlglot/issues/3374) opened by [@cploonker](https://togithub.com/cploonker)* - [`3e8de71`](https://togithub.com/tobymao/sqlglot/commit/3e8de7124b735a6ab52971a3e51702c4e7b74be5) - **postgres**: allow FOR clause without FROM in SUBSTRING closes [#3377](https://togithub.com/tobymao/sqlglot/pull/3377) *(commit by [@georgesittas](https://togithub.com/georgesittas))* - [`b2a7e55`](https://togithub.com/tobymao/sqlglot/commit/b2a7e550b25fd95eb0abba63228c9e285be168e0) - **optimizer**: Remove XOR from connector simplifications *(PR [#3380](https://togithub.com/tobymao/sqlglot/pull/3380) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#3372](https://togithub.com/tobymao/sqlglot/issues/3372) opened by [@colincointe](https://togithub.com/colincointe)* - [`477754c`](https://togithub.com/tobymao/sqlglot/commit/477754c72c47b6dc9dd01463b8f6fae6686cb1ac) - **trino**: bring back TRIM parsing *(PR [#3385](https://togithub.com/tobymao/sqlglot/pull/3385) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3384](https://togithub.com/tobymao/sqlglot/issues/3384) opened by [@dmelchor-stripe](https://togithub.com/dmelchor-stripe)* - [`cc6259d`](https://togithub.com/tobymao/sqlglot/commit/cc6259de3d68831ded31bfb7fafe1ce654aa89dd) - **optimizer**: Mark UDTF child scopes as ScopeType.SUBQUERY *(PR [#3390](https://togithub.com/tobymao/sqlglot/pull/3390) by [@VaggelisD](https://togithub.com/VaggelisD))* - [`0d23b20`](https://togithub.com/tobymao/sqlglot/commit/0d23b20352a8931adf8224d322da324b18e8282d) - allow joins in FROM expression parser *(PR [#3389](https://togithub.com/tobymao/sqlglot/pull/3389) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3387](https://togithub.com/tobymao/sqlglot/issues/3387) opened by [@MikeWallis42](https://togithub.com/MikeWallis42)* - [`e7021df`](https://togithub.com/tobymao/sqlglot/commit/e7021df397a1dc5e726d1e391ef6428a3190856d) - **duckdb**: Preserve DATE_SUB roundtrip *(PR [#3382](https://togithub.com/tobymao/sqlglot/pull/3382) by [@VaggelisD](https://togithub.com/VaggelisD))* - :arrow_lower_right: *fixes issue [#3373](https://togithub.com/tobymao/sqlglot/issues/3373) opened by [@zergar](https://togithub.com/zergar)* - [`641b296`](https://togithub.com/tobymao/sqlglot/commit/641b296017591b65ffc223d28b37e51886789ca7) - **postgres**: tokenize INT8 as BIGINT *(PR [#3392](https://togithub.com/tobymao/sqlglot/pull/3392) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3391](https://togithub.com/tobymao/sqlglot/issues/3391) opened by [@fuzi1996](https://togithub.com/fuzi1996)* - [`33bae9b`](https://togithub.com/tobymao/sqlglot/commit/33bae9b527b27f02dfafff3f45534f85aa9e0d9d) - get rid of superfluous "parameters" arg in RegexpReplace *(PR [#3394](https://togithub.com/tobymao/sqlglot/pull/3394) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3393](https://togithub.com/tobymao/sqlglot/issues/3393) opened by [@rzykov](https://togithub.com/rzykov)* - [`3768514`](https://togithub.com/tobymao/sqlglot/commit/3768514e3b2f256b69553e173b40f17180744ab0) - snowflake optional merge insert *(commit by [@tobymao](https://togithub.com/tobymao))* - [`f44cd24`](https://togithub.com/tobymao/sqlglot/commit/f44cd248a82f5519afd0edba5112a499b804fe8f) - make generated constraint parsing more lenient fixes [#3397](https://togithub.com/tobymao/sqlglot/pull/3397) *(commit by [@georgesittas](https://togithub.com/georgesittas))* - [`00ff877`](https://togithub.com/tobymao/sqlglot/commit/00ff87719ab4d6e3a407334c8d811366d0c7ead5) - **tsql**: quote hash sign as well for quoted temporary tables *(PR [#3401](https://togithub.com/tobymao/sqlglot/pull/3401) by [@georgesittas](https://togithub.com/georgesittas))* - :arrow_lower_right: *fixes issue [#3399](https://togithub.com/tobymao/sqlglot/issues/3399) opened by [@gforsyth](https://togithub.com/gforsyth)* - [`84b7026`](https://togithub.com/tobymao/sqlglot/commit/84b7026e2fbc4e73c3b4c0c86cb764b95541841e) - **trino**: support for data type 'tdigest' *(PR [#3402](https://togithub.com/tobymao/sqlglot/pull/3402) by [@suryaiyer95](https://togithub.com/suryaiyer95))* - [`24e1115`](https://togithub.com/tobymao/sqlglot/commit/24e1115c957d42a5511c1c428516e3ce5426cd88) - **trino|presto**: adding cast support for "hyperloglog" column type *(PR [#3405](https://togithub.com/tobymao/sqlglot/pull/3405) by [@uncledata](https://togithub.com/uncledata))*Configuration
📅 Schedule: Branch creation - "after 10pm every weekday,every weekend,before 5am every weekday" (UTC), 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.