This release consists of 45 commits from 19 contributors. See credits at the end of this changelog for more information.
Other:
- Ignore escaped LIKE wildcards in MySQL #1735 (mvzink)
- Parse SET NAMES syntax in Postgres #1752 (mvzink)
- re-add support for nested comments in mssql #1754 (lovasoa)
- Extend support for INDEX parsing #1707 (LucaCappelletti94)
- Parse MySQL
ALTER TABLE DROP FOREIGN KEY
syntax #1762 (mvzink) - add support for
with
clauses (CTEs) indelete
statements #1764 (lovasoa) - SET with a list of comma separated assignments #1757 (MohamedAbdeen21)
- Preserve MySQL-style
LIMIT <offset>, <limit>
syntax #1765 (mvzink) - Add support for
DROP MATERIALIZED VIEW
#1743 (iffyio) - Add
CASE
andIF
statement support #1741 (iffyio) - BigQuery: Add support for
CREATE SCHEMA
options #1742 (iffyio) - Snowflake: Support dollar quoted comments #1755
- Add LOCK operation for ALTER TABLE #1768 (MohamedAbdeen21)
- Add support for
RAISE
statement #1766 (iffyio) - Add GLOBAL context/modifier to SET statements #1767 (MohamedAbdeen21)
- Parse
SUBSTR
as alias forSUBSTRING
#1769 (mvzink) - SET statements: scope modifier for multiple assignments #1772 (MohamedAbdeen21)
- Support qualified column names in
MATCH AGAINST
clause #1774 (tomershaniii) - Mysql: Add support for := operator #1779 (barsela1)
- Add cipherstash-proxy to list of users in README.md #1782 (coderdan)
- Fix typos #1785 (jayvdb)
- Add support for Databricks TIMESTAMP_NTZ. #1781 (romanb)
- Enable double-dot-notation for mssql. #1787 (romanb)
- Fix: Snowflake ALTER SESSION cannot be followed by other statements. #1786 (romanb)
- Add GreptimeDB to the "Users" in README #1788 (MichaelScofield)
- Extend snowflake grant options support #1794 (yoavcloud)
- Fix clippy lint on rust 1.86 #1796 (iffyio)
- Allow single quotes in EXTRACT() for Redshift. #1795 (romanb)
- MSSQL: Add support for functionality
MERGE
output clause #1790 (dilovancelik) - Support additional DuckDB integer types such as HUGEINT, UHUGEINT, etc #1797 (alexander-beedie)
- Add support for MSSQL IF/ELSE statements. #1791 (romanb)
- Allow literal backslash escapes for string literals in Redshift dialect. #1801 (romanb)
- Add support for MySQL's STRAIGHT_JOIN join operator. #1802 (romanb)
- Snowflake COPY INTO target columns, select items and optional alias #1805 (yoavcloud)
- Fix tokenization of qualified identifiers with numeric prefix. #1803 (romanb)
- Add support for
INHERITS
option inCREATE TABLE
statement #1806 (LucaCappelletti94) - Add
DROP TRIGGER
support for SQL Server #1813 (aharpervc) - Snowflake: support nested join without parentheses #1799 (barsela1)
- Add support for parenthesized subquery as
IN
predicate #1793 (adamchainz) - Fix
STRAIGHT_JOIN
constraint when table alias is absent #1812 (killertux) - Add support for
PRINT
statement for SQL Server #1811 (aharpervc) - enable
supports_filter_during_aggregation
for Generic dialect #1815 (goldmedal) - Add support for
XMLTABLE
#1817 (lovasoa) - Add
CREATE FUNCTION
support for SQL Server #1808 (aharpervc) - Add
OR ALTER
support forCREATE VIEW
#1818 (aharpervc) - Add
DECLARE ... CURSOR FOR
support for SQL Server #1821 (aharpervc)
Thank you to everyone who contributed to this release. Here is a breakdown of commits (PRs merged) per contributor.
8 Roman Borschel
5 Ifeanyi Ubah
5 Michael Victor Zink
4 Andrew Harper
4 Mohamed Abdeen
3 Ophir LOJKINE
2 Luca Cappelletti
2 Yoav Cohen
2 bar sela
1 Adam Johnson
1 Aleksei Piianin
1 Alexander Beedie
1 Bruno Clemente
1 Dan Draper
1 DilovanCelik
1 Jax Liu
1 John Vandenberg
1 LFC
1 tomershaniii
Thank you also to everyone who contributed in other ways such as filing issues, reviewing PRs, and providing feedback on this release.