sqlparser-rs/sqlparser-rs (sqlparser)
### [`v0.51.0`](https://redirect.github.com/sqlparser-rs/sqlparser-rs/blob/HEAD/CHANGELOG.md#0510-2024-09-11)
[Compare Source](https://redirect.github.com/sqlparser-rs/sqlparser-rs/compare/v0.50.0...v0.51.0)
As always, huge props to [@iffyio](https://redirect.github.com/iffyio) [@jmhain](https://redirect.github.com/jmhain) and [@lovasoa](https://redirect.github.com/lovasoa) for their help reviewing and merging PRs 🙏.
Without them this project would not be possible.
Reminder: we are in the final phases of moving sqlparser-rs into the Apache
DataFusion project: [https://github.com/sqlparser-rs/sqlparser-rs/issues/1294](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1294)
##### Fixed
- Fix Hive table comment should be after table column definitions ([#1413](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1413)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Fix stack overflow in `parse_subexpr` ([#1410](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1410)) - Thanks [@eejbyfeldt](https://redirect.github.com/eejbyfeldt)
- Fix `INTERVAL` parsing to support expressions and units via dialect ([#1398](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1398)) - Thanks [@samuelcolvin](https://redirect.github.com/samuelcolvin)
- Fix identifiers starting with `$` should be regarded as a placeholder in SQLite ([#1402](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1402)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
##### Added
- Support for MSSQL table options ([#1414](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1414)) - Thanks [@bombsimon](https://redirect.github.com/bombsimon)
- Test showing how negative constants are parsed ([#1421](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1421)) - Thanks [@alamb](https://redirect.github.com/alamb)
- Support databricks dialect to dialect_from_str ([#1416](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1416)) - Thanks [@milenkovicmalamb](https://redirect.github.com/milenkovicmalamb)
- Support `DROP|CLEAR|MATERIALIZE PROJECTION` syntax for ClickHouse ([#1417](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1417)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support postgres `TRUNCATE` syntax ([#1406](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1406)) - Thanks [@tobyhede](https://redirect.github.com/tobyhede)
- Support `CREATE INDEX` with clause ([#1389](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1389)) - Thanks [@lewiszlw](https://redirect.github.com/lewiszlw)
- Support parsing `CLUSTERED BY` clause for Hive ([#1397](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1397)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support different `USE` statement syntaxes ([#1387](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1387)) - Thanks [@kacpermuda](https://redirect.github.com/kacpermuda)
- Support `ADD PROJECTION` syntax for ClickHouse ([#1390](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1390)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
##### Changed
- Implement common traits for OneOrManyWithParens ([#1368](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1368)) - Thanks [@gstvg](https://redirect.github.com/gstvg)
- Cleanup parse_statement ([#1407](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1407)) - Thanks [@samuelcolvin](https://redirect.github.com/samuelcolvin)
- Allow `DateTimeField::Custom` with `EXTRACT` in Postgres ([#1394](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1394)) - Thanks [@samuelcolvin](https://redirect.github.com/samuelcolvin)
### [`v0.50.0`](https://redirect.github.com/sqlparser-rs/sqlparser-rs/blob/HEAD/CHANGELOG.md#0500-2024-08-15)
[Compare Source](https://redirect.github.com/sqlparser-rs/sqlparser-rs/compare/v0.49.0...v0.50.0)
Again, huge props to [@iffyio](https://redirect.github.com/iffyio) [@jmhain](https://redirect.github.com/jmhain) and [@lovasoa](https://redirect.github.com/lovasoa) for their help reviewing and merging PRs 🙏.
Without them this project would not be possible.
Reminder: are in the process of moving sqlparser to governed as part of the Apache
DataFusion project: [https://github.com/sqlparser-rs/sqlparser-rs/issues/1294](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1294)
##### Fixed
- Clippy 1.80 warnings ([#1357](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1357)) - Thanks [@lovasoa](https://redirect.github.com/lovasoa)
##### Added
- Support `STRUCT` and list of structs for DuckDB dialect ([#1372](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1372)) - Thanks [@jayzhan211](https://redirect.github.com/jayzhan211)
- Support custom lexical precedence in PostgreSQL dialect ([#1379](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1379)) - Thanks [@samuelcolvin](https://redirect.github.com/samuelcolvin)
- Support `FREEZE|UNFREEZE PARTITION` syntax for ClickHouse ([#1380](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1380)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support scale in `CEIL` and `FLOOR` functions ([#1377](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1377)) - Thanks [@seve-martinez](https://redirect.github.com/seve-martinez)
- Support `CREATE TRIGGER` and `DROP TRIGGER` statements ([#1352](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1352)) - Thanks [@LucaCappelletti94](https://redirect.github.com/LucaCappelletti94)
- Support `EXTRACT` syntax for snowflake ([#1374](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1374)) - Thanks [@seve-martinez](https://redirect.github.com/seve-martinez)
- Support `ATTACH` / `DETACH PARTITION` for ClickHouse ([#1362](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1362)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support Dialect level precedence, update Postgres Dialect to match Postgres ([#1360](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1360)) - Thanks [@samuelcolvin](https://redirect.github.com/samuelcolvin)
- Support parsing empty map literal syntax for DuckDB and Generic dialects ([#1361](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1361)) - Thanks [@goldmedal](https://redirect.github.com/goldmedal)
- Support `SETTINGS` clause for ClickHouse table-valued functions ([#1358](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1358)) - Thanks [@Jesse-Bakker](https://redirect.github.com/Jesse-Bakker)
- Support `OPTIMIZE TABLE` statement for ClickHouse ([#1359](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1359)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support `ON CLUSTER` in `ALTER TABLE` for ClickHouse ([#1342](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1342)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support `GLOBAL` keyword before the join operator ([#1353](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1353)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support postgres String Constants with Unicode Escapes ([#1355](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1355)) - Thanks [@lovasoa](https://redirect.github.com/lovasoa)
- Support position with normal function call syntax for Snowflake ([#1341](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1341)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Support `TABLE` keyword in `DESC|DESCRIBE|EXPLAIN TABLE` statement ([#1351](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1351)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
##### Changed
- Only require `DESCRIBE TABLE` for Snowflake and ClickHouse dialect ([#1386](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1386)) - Thanks @ alamb
- Rename (unreleased) `get_next_precedence_full` to `get_next_precedence_default` ([#1378](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1378)) - Thanks [@samuelcolvin](https://redirect.github.com/samuelcolvin)
- Use local GitHub Action to replace setup-rust-action ([#1371](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1371)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Simplify arrow_cast tests ([#1367](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1367)) - Thanks [@alamb](https://redirect.github.com/alamb)
- Update version of GitHub Actions ([#1363](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1363)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Make `Parser::maybe_parse` pub ([#1364](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1364)) - Thanks [@Jesse-Bakker](https://redirect.github.com/Jesse-Bakker)
- Improve comments on 1Dialect\` ([#1366](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1366)) - Thanks [@alamb](https://redirect.github.com/alamb)
### [`v0.49.0`](https://redirect.github.com/sqlparser-rs/sqlparser-rs/blob/HEAD/CHANGELOG.md#0490-2024-07-23)
[Compare Source](https://redirect.github.com/sqlparser-rs/sqlparser-rs/compare/v0.48.0...v0.49.0)
As always, huge props to [@iffyio](https://redirect.github.com/iffyio) [@jmhain](https://redirect.github.com/jmhain) and [@lovasoa](https://redirect.github.com/lovasoa) for their help reviewing and merging PRs!
We are in the process of moving sqlparser to governed as part of the Apache
DataFusion project: [https://github.com/sqlparser-rs/sqlparser-rs/issues/1294](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1294)
##### Fixed
- Fix quoted identifier regression edge-case with "from" in SELECT ([#1346](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1346)) - Thanks [@alexander-beedie](https://redirect.github.com/alexander-beedie)
- Fix `AS` query clause should be after the create table options ([#1339](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1339)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
##### Added
- Support `MATERIALIZED`/`ALIAS`/`EPHERMERAL` default column options for ClickHouse ([#1348](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1348)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support `()` as the `GROUP BY` nothing ([#1347](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1347)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support Map literal syntax for DuckDB and Generic ([#1344](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1344)) - Thanks [@goldmedal](https://redirect.github.com/goldmedal)
- Support subquery expression in `SET` expressions ([#1343](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1343)) - Thanks [@iffyio](https://redirect.github.com/iffyio)
- Support `WITH FILL` for ClickHouse ([#1330](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1330)) - Thanks [@nickpresta](https://redirect.github.com/nickpresta)
- Support `PARTITION BY` for PostgreSQL in `CREATE TABLE` statement ([#1338](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1338)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support of table function `WITH ORDINALITY` modifier for Postgres ([#1337](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1337)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
### [`v0.48.0`](https://redirect.github.com/sqlparser-rs/sqlparser-rs/blob/HEAD/CHANGELOG.md#0480-2024-07-09)
[Compare Source](https://redirect.github.com/sqlparser-rs/sqlparser-rs/compare/v0.47.0...v0.48.0)
Huge shout out to [@iffyio](https://redirect.github.com/iffyio) [@jmhain](https://redirect.github.com/jmhain) and [@lovasoa](https://redirect.github.com/lovasoa) for their help reviewing and merging PRs!
##### Fixed
- Fix CI error message in CI ([#1333](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1333)) - Thanks [@alamb](https://redirect.github.com/alamb)
- Fix typo in sqlparser-derive README ([#1310](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1310)) - Thanks [@leoyvens](https://redirect.github.com/leoyvens)
- Re-enable trailing commas in DCL ([#1318](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1318)) - Thanks [@MohamedAbdeen21](https://redirect.github.com/MohamedAbdeen21)
- Fix a few typos in comment lines ([#1316](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1316)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Fix Snowflake `SELECT * wildcard REPLACE ... RENAME` order ([#1321](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1321)) - Thanks [@alexander-beedie](https://redirect.github.com/alexander-beedie)
- Allow semi-colon at the end of UNCACHE statement ([#1320](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1320)) - Thanks [@LorrensP-2158466](https://redirect.github.com/LorrensP-2158466)
- Return errors, not panic, when integers fail to parse in `AUTO_INCREMENT` and `TOP` ([#1305](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1305)) - Thanks [@eejbyfeldt](https://redirect.github.com/eejbyfeldt)
##### Added
- Support `OWNER TO` clause in Postgres ([#1314](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1314)) - Thanks [@gainings](https://redirect.github.com/gainings)
- Support `FORMAT` clause for ClickHouse ([#1335](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1335)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support `DROP PROCEDURE` statement ([#1324](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1324)) - Thanks [@LorrensP-2158466](https://redirect.github.com/LorrensP-2158466)
- Support `PREWHERE` condition for ClickHouse dialect ([#1328](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1328)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support `SETTINGS` pairs for ClickHouse dialect ([#1327](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1327)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support `GROUP BY WITH MODIFIER` for ClickHouse dialect ([#1323](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1323)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support DuckDB Union datatype ([#1322](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1322)) - Thanks [@gstvg](https://redirect.github.com/gstvg)
- Support parametric arguments to `FUNCTION` for ClickHouse dialect ([#1315](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1315)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk)
- Support `TO` in `CREATE VIEW` clause for Clickhouse ([#1313](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1313)) - Thanks [@Bidaya0](https://redirect.github.com/Bidaya0)
- Support `UPDATE` statements that contain tuple assignments ([#1317](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1317)) - Thanks [@lovasoa](https://redirect.github.com/lovasoa)
- Support \`BY NAME quantifier across all set ops ([#1309](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1309)) - Thanks [@alexander-beedie](https://redirect.github.com/alexander-beedie)
- Support SnowFlake exclusive `CREATE TABLE` options ([#1233](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1233)) - Thanks [@balliegojr](https://redirect.github.com/balliegojr)
- Support ClickHouse `CREATE TABLE` with primary key and parametrised table engine ([#1289](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1289)) - Thanks [@7phs](https://redirect.github.com/7phs)
- Support custom operators in Postgres ([#1302](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1302)) - Thanks [@lovasoa](https://redirect.github.com/lovasoa)
- Support ClickHouse data types ([#1285](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1285)) - Thanks [@7phs](https://redirect.github.com/7phs)
##### Changed
- Add stale PR github workflow ([#1331](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1331)) - Thanks [@alamb](https://redirect.github.com/alamb)
- Refine docs ([#1326](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1326)) - Thanks [@emilsivervik](https://redirect.github.com/emilsivervik)
- Improve error messages with additional colons ([#1319](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1319)) - Thanks [@LorrensP-2158466](https://redirect.github.com/LorrensP-2158466)
- Move Display fmt to struct for `CreateIndex` ([#1307](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1307)) - Thanks [@philipcristiano](https://redirect.github.com/philipcristiano)
- Enhancing Trailing Comma Option ([#1212](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1212)) - Thanks [@MohamedAbdeen21](https://redirect.github.com/MohamedAbdeen21)
- Encapsulate `CreateTable`, `CreateIndex` into specific structs ([#1291](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1291)) - Thanks [@philipcristiano](https://redirect.github.com/philipcristiano)
### [`v0.47.0`](https://redirect.github.com/sqlparser-rs/sqlparser-rs/blob/HEAD/CHANGELOG.md#0470-2024-06-01)
[Compare Source](https://redirect.github.com/sqlparser-rs/sqlparser-rs/compare/v0.46.0...v0.47.0)
##### Fixed
- Re-support Postgres array slice syntax ([#1290](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1290)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Fix DoubleColon cast skipping AT TIME ZONE [#1266](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1266) ([#1267](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1267)) - Thanks [@dmitrybugakov](https://redirect.github.com/dmitrybugakov)
- Fix for values as table name in Databricks and generic ([#1278](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1278)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
##### Added
- Support `ASOF` joins in Snowflake ([#1288](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1288)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Support `CREATE VIEW` with fields and data types ClickHouse ([#1292](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1292)) - Thanks [@7phs](https://redirect.github.com/7phs)
- Support view comments for Snowflake ([#1287](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1287)) - Thanks [@bombsimon](https://redirect.github.com/bombsimon)
- Support dynamic pivot in Snowflake ([#1280](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1280)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Support `CREATE FUNCTION` for BigQuery, generalize AST ([#1253](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1253)) - Thanks [@iffyio](https://redirect.github.com/iffyio)
- Support expression in `AT TIME ZONE` and fix precedence ([#1272](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1272)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Support `IGNORE/RESPECT NULLS` inside function argument list for Databricks ([#1263](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1263)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Support `SELECT * EXCEPT` Databricks ([#1261](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1261)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Support triple quoted strings ([#1262](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1262)) - Thanks [@iffyio](https://redirect.github.com/iffyio)
- Support array indexing for duckdb ([#1265](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1265)) - Thanks [@JichaoS](https://redirect.github.com/JichaoS)
- Support multiple SET variables ([#1252](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1252)) - Thanks [@iffyio](https://redirect.github.com/iffyio)
- Support `ANY_VALUE` `HAVING` clause ([#1258](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1258)) in BigQuery - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Support keywords as field names in BigQuery struct syntax ([#1254](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1254)) - Thanks [@iffyio](https://redirect.github.com/iffyio)
- Support `GROUP_CONCAT()` in MySQL ([#1256](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1256)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Support lambda functions in Databricks ([#1257](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1257)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Add const generic peek_tokens method to parser ([#1255](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1255)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
### [`v0.46.0`](https://redirect.github.com/sqlparser-rs/sqlparser-rs/blob/HEAD/CHANGELOG.md#0460-2024-05-03)
[Compare Source](https://redirect.github.com/sqlparser-rs/sqlparser-rs/compare/v0.45.0...v0.46.0)
##### Changed
- Consolidate representation of function calls, remove `AggregateExpressionWithFilter`, `ArraySubquery`, `ListAgg` and `ArrayAgg` ([#1247](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1247)) - Thanks jmhain
- Extended dialect trait to support numeric prefixed identifiers ([#1188](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1188)) - Thanks [@groobyming](https://redirect.github.com/groobyming)
- Update simple_logger requirement from 4.0 to 5.0 ([#1246](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1246)) - Thanks [@dependabot](https://redirect.github.com/dependabot)
- Improve parsing of JSON accesses on Postgres and Snowflake ([#1215](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1215)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Encapsulate Insert and Delete into specific structs ([#1224](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1224)) - Thanks [@tisonkun](https://redirect.github.com/tisonkun)
- Preserve double colon casts (and simplify cast representations) ([#1221](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1221)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
##### Fixed
- Fix redundant brackets in Hive/Snowflake/Redshift ([#1229](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1229)) - Thanks [@yuval-illumex](https://redirect.github.com/yuval-illumex)
##### Added
- Support values without parens in Snowflake and DataBricks ([#1249](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1249)) - Thanks [@HiranmayaGundu](https://redirect.github.com/HiranmayaGundu)
- Support WINDOW clause after QUALIFY when parsing ([#1248](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1248)) - Thanks [@iffyio](https://redirect.github.com/iffyio)
- Support `DECLARE` parsing for mssql ([#1235](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1235)) - Thanks [@devanbenz](https://redirect.github.com/devanbenz)
- Support `?`-based jsonb operators in Postgres ([#1242](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1242)) - THanks [@ReppCodes](https://redirect.github.com/ReppCodes)
- Support Struct datatype parsing for GenericDialect ([#1241](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1241)) - Thanks [@duongcongtoai](https://redirect.github.com/duongcongtoai)
- Support BigQuery window function null treatment ([#1239](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1239)) - Thanks [@iffyio](https://redirect.github.com/iffyio)
- Support extend pivot operator - Thanks [@iffyio](https://redirect.github.com/iffyio)
- Support Databricks SQL dialect ([#1220](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1220)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Support for MSSQL CONVERT styles ([#1219](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1219)) - Thanks [@iffyio](https://redirect.github.com/iffyio)
- Support window clause using named window in BigQuery ([#1237](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1237)) - Thanks [@iffyio](https://redirect.github.com/iffyio)
- Support for CONNECT BY ([#1138](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1138)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Support object constants in Snowflake ([#1223](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1223)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Support BigQuery MERGE syntax ([#1217](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1217)) - Thanks [@iffyio](https://redirect.github.com/iffyio)
- Support for MAX for NVARCHAR ([#1232](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1232)) - Thanks @ bombsimon
- Support fixed size list types ([#1231](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1231)) - @[@universalmind303](https://redirect.github.com/universalmind303)
- Support Snowflake MATCH_RECOGNIZE syntax ([#1222](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1222)) - Thanks [@jmhain](https://redirect.github.com/jmhain)
- Support quoted string backslash escaping ([#1177](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1177)) - Thanks [@iffyio](https://redirect.github.com/iffyio)
- Support Modify Column for MySQL dialect ([#1216](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1216)) - Thanks [@KKould](https://redirect.github.com/KKould)
- Support `select * ilike` for snowflake ([#1228](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1228)) - Thanks [@HiranmayaGundu](https://redirect.github.com/HiranmayaGundu)
- Support wildcard replace in duckdb and snowflake syntax ([#1226](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1226)) - Thanks [@HiranmayaGundu](https://redirect.github.com/HiranmayaGundu)
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 contains the following updates:
0.45.0
->0.51.0
Release Notes
sqlparser-rs/sqlparser-rs (sqlparser)
### [`v0.51.0`](https://redirect.github.com/sqlparser-rs/sqlparser-rs/blob/HEAD/CHANGELOG.md#0510-2024-09-11) [Compare Source](https://redirect.github.com/sqlparser-rs/sqlparser-rs/compare/v0.50.0...v0.51.0) As always, huge props to [@iffyio](https://redirect.github.com/iffyio) [@jmhain](https://redirect.github.com/jmhain) and [@lovasoa](https://redirect.github.com/lovasoa) for their help reviewing and merging PRs 🙏. Without them this project would not be possible. Reminder: we are in the final phases of moving sqlparser-rs into the Apache DataFusion project: [https://github.com/sqlparser-rs/sqlparser-rs/issues/1294](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1294) ##### Fixed - Fix Hive table comment should be after table column definitions ([#1413](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1413)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Fix stack overflow in `parse_subexpr` ([#1410](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1410)) - Thanks [@eejbyfeldt](https://redirect.github.com/eejbyfeldt) - Fix `INTERVAL` parsing to support expressions and units via dialect ([#1398](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1398)) - Thanks [@samuelcolvin](https://redirect.github.com/samuelcolvin) - Fix identifiers starting with `$` should be regarded as a placeholder in SQLite ([#1402](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1402)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) ##### Added - Support for MSSQL table options ([#1414](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1414)) - Thanks [@bombsimon](https://redirect.github.com/bombsimon) - Test showing how negative constants are parsed ([#1421](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1421)) - Thanks [@alamb](https://redirect.github.com/alamb) - Support databricks dialect to dialect_from_str ([#1416](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1416)) - Thanks [@milenkovicmalamb](https://redirect.github.com/milenkovicmalamb) - Support `DROP|CLEAR|MATERIALIZE PROJECTION` syntax for ClickHouse ([#1417](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1417)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support postgres `TRUNCATE` syntax ([#1406](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1406)) - Thanks [@tobyhede](https://redirect.github.com/tobyhede) - Support `CREATE INDEX` with clause ([#1389](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1389)) - Thanks [@lewiszlw](https://redirect.github.com/lewiszlw) - Support parsing `CLUSTERED BY` clause for Hive ([#1397](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1397)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support different `USE` statement syntaxes ([#1387](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1387)) - Thanks [@kacpermuda](https://redirect.github.com/kacpermuda) - Support `ADD PROJECTION` syntax for ClickHouse ([#1390](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1390)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) ##### Changed - Implement common traits for OneOrManyWithParens ([#1368](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1368)) - Thanks [@gstvg](https://redirect.github.com/gstvg) - Cleanup parse_statement ([#1407](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1407)) - Thanks [@samuelcolvin](https://redirect.github.com/samuelcolvin) - Allow `DateTimeField::Custom` with `EXTRACT` in Postgres ([#1394](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1394)) - Thanks [@samuelcolvin](https://redirect.github.com/samuelcolvin) ### [`v0.50.0`](https://redirect.github.com/sqlparser-rs/sqlparser-rs/blob/HEAD/CHANGELOG.md#0500-2024-08-15) [Compare Source](https://redirect.github.com/sqlparser-rs/sqlparser-rs/compare/v0.49.0...v0.50.0) Again, huge props to [@iffyio](https://redirect.github.com/iffyio) [@jmhain](https://redirect.github.com/jmhain) and [@lovasoa](https://redirect.github.com/lovasoa) for their help reviewing and merging PRs 🙏. Without them this project would not be possible. Reminder: are in the process of moving sqlparser to governed as part of the Apache DataFusion project: [https://github.com/sqlparser-rs/sqlparser-rs/issues/1294](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1294) ##### Fixed - Clippy 1.80 warnings ([#1357](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1357)) - Thanks [@lovasoa](https://redirect.github.com/lovasoa) ##### Added - Support `STRUCT` and list of structs for DuckDB dialect ([#1372](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1372)) - Thanks [@jayzhan211](https://redirect.github.com/jayzhan211) - Support custom lexical precedence in PostgreSQL dialect ([#1379](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1379)) - Thanks [@samuelcolvin](https://redirect.github.com/samuelcolvin) - Support `FREEZE|UNFREEZE PARTITION` syntax for ClickHouse ([#1380](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1380)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support scale in `CEIL` and `FLOOR` functions ([#1377](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1377)) - Thanks [@seve-martinez](https://redirect.github.com/seve-martinez) - Support `CREATE TRIGGER` and `DROP TRIGGER` statements ([#1352](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1352)) - Thanks [@LucaCappelletti94](https://redirect.github.com/LucaCappelletti94) - Support `EXTRACT` syntax for snowflake ([#1374](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1374)) - Thanks [@seve-martinez](https://redirect.github.com/seve-martinez) - Support `ATTACH` / `DETACH PARTITION` for ClickHouse ([#1362](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1362)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support Dialect level precedence, update Postgres Dialect to match Postgres ([#1360](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1360)) - Thanks [@samuelcolvin](https://redirect.github.com/samuelcolvin) - Support parsing empty map literal syntax for DuckDB and Generic dialects ([#1361](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1361)) - Thanks [@goldmedal](https://redirect.github.com/goldmedal) - Support `SETTINGS` clause for ClickHouse table-valued functions ([#1358](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1358)) - Thanks [@Jesse-Bakker](https://redirect.github.com/Jesse-Bakker) - Support `OPTIMIZE TABLE` statement for ClickHouse ([#1359](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1359)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support `ON CLUSTER` in `ALTER TABLE` for ClickHouse ([#1342](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1342)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support `GLOBAL` keyword before the join operator ([#1353](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1353)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support postgres String Constants with Unicode Escapes ([#1355](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1355)) - Thanks [@lovasoa](https://redirect.github.com/lovasoa) - Support position with normal function call syntax for Snowflake ([#1341](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1341)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Support `TABLE` keyword in `DESC|DESCRIBE|EXPLAIN TABLE` statement ([#1351](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1351)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) ##### Changed - Only require `DESCRIBE TABLE` for Snowflake and ClickHouse dialect ([#1386](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1386)) - Thanks @ alamb - Rename (unreleased) `get_next_precedence_full` to `get_next_precedence_default` ([#1378](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1378)) - Thanks [@samuelcolvin](https://redirect.github.com/samuelcolvin) - Use local GitHub Action to replace setup-rust-action ([#1371](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1371)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Simplify arrow_cast tests ([#1367](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1367)) - Thanks [@alamb](https://redirect.github.com/alamb) - Update version of GitHub Actions ([#1363](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1363)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Make `Parser::maybe_parse` pub ([#1364](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1364)) - Thanks [@Jesse-Bakker](https://redirect.github.com/Jesse-Bakker) - Improve comments on 1Dialect\` ([#1366](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1366)) - Thanks [@alamb](https://redirect.github.com/alamb) ### [`v0.49.0`](https://redirect.github.com/sqlparser-rs/sqlparser-rs/blob/HEAD/CHANGELOG.md#0490-2024-07-23) [Compare Source](https://redirect.github.com/sqlparser-rs/sqlparser-rs/compare/v0.48.0...v0.49.0) As always, huge props to [@iffyio](https://redirect.github.com/iffyio) [@jmhain](https://redirect.github.com/jmhain) and [@lovasoa](https://redirect.github.com/lovasoa) for their help reviewing and merging PRs! We are in the process of moving sqlparser to governed as part of the Apache DataFusion project: [https://github.com/sqlparser-rs/sqlparser-rs/issues/1294](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1294) ##### Fixed - Fix quoted identifier regression edge-case with "from" in SELECT ([#1346](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1346)) - Thanks [@alexander-beedie](https://redirect.github.com/alexander-beedie) - Fix `AS` query clause should be after the create table options ([#1339](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1339)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) ##### Added - Support `MATERIALIZED`/`ALIAS`/`EPHERMERAL` default column options for ClickHouse ([#1348](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1348)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support `()` as the `GROUP BY` nothing ([#1347](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1347)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support Map literal syntax for DuckDB and Generic ([#1344](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1344)) - Thanks [@goldmedal](https://redirect.github.com/goldmedal) - Support subquery expression in `SET` expressions ([#1343](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1343)) - Thanks [@iffyio](https://redirect.github.com/iffyio) - Support `WITH FILL` for ClickHouse ([#1330](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1330)) - Thanks [@nickpresta](https://redirect.github.com/nickpresta) - Support `PARTITION BY` for PostgreSQL in `CREATE TABLE` statement ([#1338](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1338)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support of table function `WITH ORDINALITY` modifier for Postgres ([#1337](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1337)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) ### [`v0.48.0`](https://redirect.github.com/sqlparser-rs/sqlparser-rs/blob/HEAD/CHANGELOG.md#0480-2024-07-09) [Compare Source](https://redirect.github.com/sqlparser-rs/sqlparser-rs/compare/v0.47.0...v0.48.0) Huge shout out to [@iffyio](https://redirect.github.com/iffyio) [@jmhain](https://redirect.github.com/jmhain) and [@lovasoa](https://redirect.github.com/lovasoa) for their help reviewing and merging PRs! ##### Fixed - Fix CI error message in CI ([#1333](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1333)) - Thanks [@alamb](https://redirect.github.com/alamb) - Fix typo in sqlparser-derive README ([#1310](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1310)) - Thanks [@leoyvens](https://redirect.github.com/leoyvens) - Re-enable trailing commas in DCL ([#1318](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1318)) - Thanks [@MohamedAbdeen21](https://redirect.github.com/MohamedAbdeen21) - Fix a few typos in comment lines ([#1316](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1316)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Fix Snowflake `SELECT * wildcard REPLACE ... RENAME` order ([#1321](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1321)) - Thanks [@alexander-beedie](https://redirect.github.com/alexander-beedie) - Allow semi-colon at the end of UNCACHE statement ([#1320](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1320)) - Thanks [@LorrensP-2158466](https://redirect.github.com/LorrensP-2158466) - Return errors, not panic, when integers fail to parse in `AUTO_INCREMENT` and `TOP` ([#1305](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1305)) - Thanks [@eejbyfeldt](https://redirect.github.com/eejbyfeldt) ##### Added - Support `OWNER TO` clause in Postgres ([#1314](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1314)) - Thanks [@gainings](https://redirect.github.com/gainings) - Support `FORMAT` clause for ClickHouse ([#1335](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1335)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support `DROP PROCEDURE` statement ([#1324](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1324)) - Thanks [@LorrensP-2158466](https://redirect.github.com/LorrensP-2158466) - Support `PREWHERE` condition for ClickHouse dialect ([#1328](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1328)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support `SETTINGS` pairs for ClickHouse dialect ([#1327](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1327)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support `GROUP BY WITH MODIFIER` for ClickHouse dialect ([#1323](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1323)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support DuckDB Union datatype ([#1322](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1322)) - Thanks [@gstvg](https://redirect.github.com/gstvg) - Support parametric arguments to `FUNCTION` for ClickHouse dialect ([#1315](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1315)) - Thanks [@git-hulk](https://redirect.github.com/git-hulk) - Support `TO` in `CREATE VIEW` clause for Clickhouse ([#1313](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1313)) - Thanks [@Bidaya0](https://redirect.github.com/Bidaya0) - Support `UPDATE` statements that contain tuple assignments ([#1317](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1317)) - Thanks [@lovasoa](https://redirect.github.com/lovasoa) - Support \`BY NAME quantifier across all set ops ([#1309](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1309)) - Thanks [@alexander-beedie](https://redirect.github.com/alexander-beedie) - Support SnowFlake exclusive `CREATE TABLE` options ([#1233](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1233)) - Thanks [@balliegojr](https://redirect.github.com/balliegojr) - Support ClickHouse `CREATE TABLE` with primary key and parametrised table engine ([#1289](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1289)) - Thanks [@7phs](https://redirect.github.com/7phs) - Support custom operators in Postgres ([#1302](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1302)) - Thanks [@lovasoa](https://redirect.github.com/lovasoa) - Support ClickHouse data types ([#1285](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1285)) - Thanks [@7phs](https://redirect.github.com/7phs) ##### Changed - Add stale PR github workflow ([#1331](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1331)) - Thanks [@alamb](https://redirect.github.com/alamb) - Refine docs ([#1326](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1326)) - Thanks [@emilsivervik](https://redirect.github.com/emilsivervik) - Improve error messages with additional colons ([#1319](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1319)) - Thanks [@LorrensP-2158466](https://redirect.github.com/LorrensP-2158466) - Move Display fmt to struct for `CreateIndex` ([#1307](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1307)) - Thanks [@philipcristiano](https://redirect.github.com/philipcristiano) - Enhancing Trailing Comma Option ([#1212](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1212)) - Thanks [@MohamedAbdeen21](https://redirect.github.com/MohamedAbdeen21) - Encapsulate `CreateTable`, `CreateIndex` into specific structs ([#1291](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1291)) - Thanks [@philipcristiano](https://redirect.github.com/philipcristiano) ### [`v0.47.0`](https://redirect.github.com/sqlparser-rs/sqlparser-rs/blob/HEAD/CHANGELOG.md#0470-2024-06-01) [Compare Source](https://redirect.github.com/sqlparser-rs/sqlparser-rs/compare/v0.46.0...v0.47.0) ##### Fixed - Re-support Postgres array slice syntax ([#1290](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1290)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Fix DoubleColon cast skipping AT TIME ZONE [#1266](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1266) ([#1267](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1267)) - Thanks [@dmitrybugakov](https://redirect.github.com/dmitrybugakov) - Fix for values as table name in Databricks and generic ([#1278](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1278)) - Thanks [@jmhain](https://redirect.github.com/jmhain) ##### Added - Support `ASOF` joins in Snowflake ([#1288](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1288)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Support `CREATE VIEW` with fields and data types ClickHouse ([#1292](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1292)) - Thanks [@7phs](https://redirect.github.com/7phs) - Support view comments for Snowflake ([#1287](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1287)) - Thanks [@bombsimon](https://redirect.github.com/bombsimon) - Support dynamic pivot in Snowflake ([#1280](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1280)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Support `CREATE FUNCTION` for BigQuery, generalize AST ([#1253](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1253)) - Thanks [@iffyio](https://redirect.github.com/iffyio) - Support expression in `AT TIME ZONE` and fix precedence ([#1272](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1272)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Support `IGNORE/RESPECT NULLS` inside function argument list for Databricks ([#1263](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1263)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Support `SELECT * EXCEPT` Databricks ([#1261](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1261)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Support triple quoted strings ([#1262](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1262)) - Thanks [@iffyio](https://redirect.github.com/iffyio) - Support array indexing for duckdb ([#1265](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1265)) - Thanks [@JichaoS](https://redirect.github.com/JichaoS) - Support multiple SET variables ([#1252](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1252)) - Thanks [@iffyio](https://redirect.github.com/iffyio) - Support `ANY_VALUE` `HAVING` clause ([#1258](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1258)) in BigQuery - Thanks [@jmhain](https://redirect.github.com/jmhain) - Support keywords as field names in BigQuery struct syntax ([#1254](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1254)) - Thanks [@iffyio](https://redirect.github.com/iffyio) - Support `GROUP_CONCAT()` in MySQL ([#1256](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1256)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Support lambda functions in Databricks ([#1257](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1257)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Add const generic peek_tokens method to parser ([#1255](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1255)) - Thanks [@jmhain](https://redirect.github.com/jmhain) ### [`v0.46.0`](https://redirect.github.com/sqlparser-rs/sqlparser-rs/blob/HEAD/CHANGELOG.md#0460-2024-05-03) [Compare Source](https://redirect.github.com/sqlparser-rs/sqlparser-rs/compare/v0.45.0...v0.46.0) ##### Changed - Consolidate representation of function calls, remove `AggregateExpressionWithFilter`, `ArraySubquery`, `ListAgg` and `ArrayAgg` ([#1247](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1247)) - Thanks jmhain - Extended dialect trait to support numeric prefixed identifiers ([#1188](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1188)) - Thanks [@groobyming](https://redirect.github.com/groobyming) - Update simple_logger requirement from 4.0 to 5.0 ([#1246](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1246)) - Thanks [@dependabot](https://redirect.github.com/dependabot) - Improve parsing of JSON accesses on Postgres and Snowflake ([#1215](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1215)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Encapsulate Insert and Delete into specific structs ([#1224](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1224)) - Thanks [@tisonkun](https://redirect.github.com/tisonkun) - Preserve double colon casts (and simplify cast representations) ([#1221](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1221)) - Thanks [@jmhain](https://redirect.github.com/jmhain) ##### Fixed - Fix redundant brackets in Hive/Snowflake/Redshift ([#1229](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1229)) - Thanks [@yuval-illumex](https://redirect.github.com/yuval-illumex) ##### Added - Support values without parens in Snowflake and DataBricks ([#1249](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1249)) - Thanks [@HiranmayaGundu](https://redirect.github.com/HiranmayaGundu) - Support WINDOW clause after QUALIFY when parsing ([#1248](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1248)) - Thanks [@iffyio](https://redirect.github.com/iffyio) - Support `DECLARE` parsing for mssql ([#1235](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1235)) - Thanks [@devanbenz](https://redirect.github.com/devanbenz) - Support `?`-based jsonb operators in Postgres ([#1242](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1242)) - THanks [@ReppCodes](https://redirect.github.com/ReppCodes) - Support Struct datatype parsing for GenericDialect ([#1241](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1241)) - Thanks [@duongcongtoai](https://redirect.github.com/duongcongtoai) - Support BigQuery window function null treatment ([#1239](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1239)) - Thanks [@iffyio](https://redirect.github.com/iffyio) - Support extend pivot operator - Thanks [@iffyio](https://redirect.github.com/iffyio) - Support Databricks SQL dialect ([#1220](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1220)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Support for MSSQL CONVERT styles ([#1219](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1219)) - Thanks [@iffyio](https://redirect.github.com/iffyio) - Support window clause using named window in BigQuery ([#1237](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1237)) - Thanks [@iffyio](https://redirect.github.com/iffyio) - Support for CONNECT BY ([#1138](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1138)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Support object constants in Snowflake ([#1223](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1223)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Support BigQuery MERGE syntax ([#1217](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1217)) - Thanks [@iffyio](https://redirect.github.com/iffyio) - Support for MAX for NVARCHAR ([#1232](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1232)) - Thanks @ bombsimon - Support fixed size list types ([#1231](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1231)) - @[@universalmind303](https://redirect.github.com/universalmind303) - Support Snowflake MATCH_RECOGNIZE syntax ([#1222](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1222)) - Thanks [@jmhain](https://redirect.github.com/jmhain) - Support quoted string backslash escaping ([#1177](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1177)) - Thanks [@iffyio](https://redirect.github.com/iffyio) - Support Modify Column for MySQL dialect ([#1216](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1216)) - Thanks [@KKould](https://redirect.github.com/KKould) - Support `select * ilike` for snowflake ([#1228](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1228)) - Thanks [@HiranmayaGundu](https://redirect.github.com/HiranmayaGundu) - Support wildcard replace in duckdb and snowflake syntax ([#1226](https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1226)) - Thanks [@HiranmayaGundu](https://redirect.github.com/HiranmayaGundu)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.
This PR was generated by Mend Renovate. View the repository job log.