This release consists of 57 commits from 24 contributors. See credits at the end of this changelog for more information.
Implemented enhancements:
- feat: support
INSERT INTO [TABLE] FUNCTION
of Clickhouse #1633 (byte-sourcerer)
Other:
- Run cargo fmt on
derive
crate #1595 (alamb) - Add Apache license header to spans.rs #1594 (alamb)
- Add support for BigQuery
ANY TYPE
data type #1602 (MartinSahlen) - Add support for TABLESAMPLE #1580 (yoavcloud)
- Redshift: Fix parsing for quoted numbered columns #1576 (7phs)
- Add the alter table ON COMMIT option to Snowflake #1606 (yoavcloud)
- Support parsing
EXPLAIN ESTIMATE
of Clickhouse #1605 (byte-sourcerer) - Fix BigQuery hyphenated ObjectName with numbers #1598 (ayman-sigma)
- Fix test compilation issue #1609 (iffyio)
- Allow foreign table constraint without columns #1608 (ramnivas)
- Support optional table for
ANALYZE
statement #1599 (yuyang-ok) - Support DOUBLE data types with precision for Mysql #1611 (artorias1024)
- Add
#[recursive]
#1522 (blaginin) - Support arbitrary composite access expressions #1600 (ayman-sigma)
- Consolidate
MapAccess
, andSubscript
intoCompoundExpr
to handle the complex field access chain #1551 (goldmedal) - Handle empty projection in Postgres SELECT statements #1613 (tobyhede)
- Merge composite and compound expr test cases #1615 (iffyio)
- Support Snowflake Update-From-Select #1604 (yuval-illumex)
- Improve parsing performance by reducing token cloning #1587 (davisp)
- Improve Parser documentation #1617 (alamb)
- Add support for DROP EXTENSION #1610 (ramnivas)
- Refactor advancing token to avoid duplication, avoid borrow checker issues #1618 (alamb)
- Fix the parsing result for the special double number #1621 (goldmedal)
- SQLite: Allow dollar signs in placeholder names #1620 (hansott)
- Improve error for an unexpected token after DROP #1623 (ramnivas)
- Fix
sqlparser_bench
benchmark compilation #1625 (alamb) - Improve parsing speed by avoiding some clones in parse_identifier #1624 (alamb)
- Simplify
parse_keyword_apis
more #1626 (alamb) - Test benchmarks and Improve benchmark README.md #1627 (alamb)
- Add support for MYSQL's
RENAME TABLE
#1616 (wugeer) - Correctly tokenize nested comments #1629 (hansott)
- Add support for USE SECONDARY ROLE (vs. ROLES) #1637 (yoavcloud)
- Add support for various Snowflake grantees #1640 (yoavcloud)
- Add support for the SQL OVERLAPS predicate #1638 (yoavcloud)
- Add support for Snowflake LIST and REMOVE #1639 (yoavcloud)
- Add support for MySQL's INSERT INTO ... SET syntax #1641 (yoavcloud)
- Start new line if \r in Postgres dialect #1647 (hansott)
- Support pluralized time units #1630 (wugeer)
- Replace
ReferentialAction
enum inDROP
statements #1648 (stepancheg) - Add support for MS-SQL BEGIN/END TRY/CATCH #1649 (yoavcloud)
- Fix MySQL parsing of GRANT, REVOKE, and CREATE VIEW #1538 (mvzink)
- Add support for the Snowflake MINUS set operator #1652 (yoavcloud)
- ALTER TABLE DROP {COLUMN|CONSTRAINT} RESTRICT #1651 (stepancheg)
- Add support for ClickHouse
FORMAT
onINSERT
#1628 (bombsimon) - MsSQL SET for session params #1646 (yoavcloud)
- Correctly look for end delimiter dollar quoted string #1650 (hansott)
- Support single line comments starting with '#' for Hive #1654 (wugeer)
- Support trailing commas in
FROM
clause #1645 (barsela1) - Allow empty options for BigQuery #1657 (MartinSahlen)
- Add support for parsing RAISERROR #1656 (AvivDavid-Satori)
- Add support for Snowflake column aliases that use SQL keywords #1632 (yoavcloud)
- fix parsing of
INSERT INTO ... SELECT ... RETURNING
#1661 (lovasoa) - Add support for
IS [NOT] [form] NORMALIZED
#1655 (alexander-beedie) - Add support for qualified column names in JOIN ... USING #1663 (yoavcloud)
- Add support for Snowflake AT/BEFORE #1667 (yoavcloud)
Thank you to everyone who contributed to this release. Here is a breakdown of commits (PRs merged) per contributor.
13 Yoav Cohen
9 Andrew Lamb
4 Hans Ott
3 Ramnivas Laddad
3 wugeer
2 Ayman Elkfrawy
2 Ifeanyi Ubah
2 Jax Liu
2 Martin Abelson Sahlen
2 Stepan Koltsov
2 cjw
1 Aleksei Piianin
1 Alexander Beedie
1 AvivDavid-Satori
1 Dmitrii Blaginin
1 Michael Victor Zink
1 Ophir LOJKINE
1 Paul J. Davis
1 Simon Sawert
1 Toby Hede
1 Yuval Shkolar
1 artorias1024
1 bar sela
1 yuyang
Thank you also to everyone who contributed in other ways such as filing issues, reviewing PRs, and providing feedback on this release.