This release consists of 45 commits from 20 contributors. See credits at the end of this changelog for more information.
Implemented enhancements:
- feat: support explain options #1426 (kysshsy)
- feat: adding Display implementation to DELETE and INSERT #1427 (seve-martinez)
Fixed bugs:
- fix:
maybe_parse
preventing parser from erroring on recursion limit #1464 (tomershaniii)
Other:
- Fix parsing of negative values #1419 (agscpp)
- Allow to use ON CLUSTER cluster_name in TRUNCATE syntax #1428 (git-hulk)
- chore: remove redundant punctuation #1434 (Fischer0522)
- MS SQL Server: add support for IDENTITY column option #1432 (7phs)
- Update to ASF header / add when missing #1437 (alamb)
- Some small optimizations #1424 (exrok)
- Fix
codestyle
CI check #1438 (alamb) - Implements CREATE POLICY syntax for PostgreSQL #1440 (git-hulk)
- make
parse_expr_with_alias
public #1444 (Eason0729) - Implements DROP POLICY syntax for PostgreSQL #1445 (git-hulk)
- Support
DROP DATABASE
#1443 (linhr) - Implements ALTER POLICY syntax for PostgreSQL #1446 (git-hulk)
- Add a note discouraging new use of
dialect_of
macro #1448 (alamb) - Expand handling of
LIMIT 1, 2
handling to include sqlite #1447 (joshuawarner32) - Fix always uses CommentDef::WithoutEq while parsing the inline comment #1453 (git-hulk)
- Add support for the LIKE ANY and ILIKE ANY pattern-matching condition #1456 (yoavcloud)
- added ability to parse extension to parse_comment inside postgres dialect #1451 (MaxwellKnight)
- Snowflake: support of views column comment #1441 (7phs)
- Add SQLite "ON CONFLICT" column option in CREATE TABLE statements #1442 (nucccc)
- Add support for ASC and DESC in CREATE TABLE column constraints for SQLite. #1462 (caldwell)
- Add support of
EXPLAIN QUERY PLAN
syntax for SQLite dialect #1458 (git-hulk) - Add "DROP TYPE" support. #1461 (caldwell)
- chore: Add asf.yaml #1463 (Xuanwo)
- Add support for quantified comparison predicates (ALL/ANY/SOME) #1459 (yoavcloud)
- MySQL dialect: Add support for hash comments #1466 (hansott)
- Fix #1469 (SET ROLE regression) #1474 (lovasoa)
- Add support for parsing MsSql alias with equals #1467 (yoavcloud)
- Snowflake: support for extended column options in
CREATE TABLE
#1454 (7phs) - MsSQL TRY_CONVERT #1477 (yoavcloud)
- Add PostgreSQL specfic "CREATE TYPE t AS ENUM (...)" support. #1460 (caldwell)
- Fix build #1483 (yoavcloud)
- Fix complex blocks warning when running clippy #1488 (git-hulk)
- Add support for SHOW DATABASES/SCHEMAS/TABLES/VIEWS in Hive #1487 (yoavcloud)
- Fix typo in
Dialect::supports_eq_alias_assigment
#1478 (alamb) - Add support for PostgreSQL
LISTEN/NOTIFY
syntax #1485 (wugeer) - Add support for TOP before ALL/DISTINCT #1495 (yoavcloud)
- add support for
FOR ORDINALITY
andNESTED
in JSON_TABLE #1493 (lovasoa) - Add Apache License to additional files #1502 (alamb)
- Move CHANGELOG content #1503 (alamb)
- improve support for T-SQL EXECUTE statements #1490 (lovasoa)
Thank you to everyone who contributed to this release. Here is a breakdown of commits (PRs merged) per contributor.
8 Andrew Lamb
7 Yoav Cohen
7 hulk
3 Aleksei Piianin
3 David Caldwell
3 Ophir LOJKINE
1 Agaev Guseyn
1 Eason
1 Fischer
1 Hans Ott
1 Heran Lin
1 Joshua Warner
1 Maxwell Knight
1 Seve Martinez
1 Siyuan Huang
1 Thomas Dagenais
1 Xuanwo
1 nucccc
1 tomershaniii
1 wugeer
Thank you also to everyone who contributed in other ways such as filing issues, reviewing PRs, and providing feedback on this release.