sqlparser-rs 0.57.0 Changelog

This release consists of 39 commits from 19 contributors. See credits at the end of this changelog for more information.

Implemented enhancements:

  • feat: Hive: support SORT BY direction #1873 (chenkovsky)

Other:

  • Support some of pipe operators #1759 (simonvandel)
  • Added support for DROP DOMAIN #1828 (LucaCappelletti94)
  • Improve support for cursors for SQL Server #1831 (aharpervc)
  • Add all missing table options to be handled in any order #1747 (benrsatori)
  • Add CREATE TRIGGER support for SQL Server #1810 (aharpervc)
  • Added support for CREATE DOMAIN #1830 (LucaCappelletti94)
  • Allow stored procedures to be defined without BEGIN/END #1834 (aharpervc)
  • Add support for the MATCH and REGEXP binary operators #1840 (lovasoa)
  • Fix: parsing ident starting with underscore in certain dialects #1835 (MohamedAbdeen21)
  • implement pretty-printing with {:#} #1847 (lovasoa)
  • Fix big performance issue in string serialization #1848 (lovasoa)
  • Add support for DENY statements #1836 (aharpervc)
  • Postgresql: Add REPLICA IDENTITY operation for ALTER TABLE #1844 (MohamedAbdeen21)
  • Add support for INCLUDE/EXCLUDE NULLS for UNPIVOT #1849 (Vedin)
  • pretty print improvements #1851 (lovasoa)
  • fix new rust 1.87 cargo clippy warnings #1856 (lovasoa)
  • Update criterion requirement from 0.5 to 0.6 in /sqlparser_bench #1857 (dependabot[bot])
  • pretty-print CREATE TABLE statements #1854 (lovasoa)
  • pretty-print CREATE VIEW statements #1855 (lovasoa)
  • Handle optional datatypes properly in CREATE FUNCTION statements #1826 (LucaCappelletti94)
  • Mysql: Add SRID column option #1852 (MohamedAbdeen21)
  • Add support for table valued functions for SQL Server #1839 (aharpervc)
  • Keep the COLUMN keyword only if it exists when dropping the column #1862 (git-hulk)
  • Add support for parameter default values in SQL Server #1866 (aharpervc)
  • Add support for TABLESAMPLE pipe operator #1860 (hendrikmakait)
  • Adds support for mysql's drop index #1864 (dmzmk)
  • Fix: GROUPING SETS accept values without parenthesis #1867 (Vedin)
  • Add ICEBERG keyword support to ALTER TABLE statement #1869 (osipovartem)
  • MySQL: Support index_name in FK constraints #1871 (MohamedAbdeen21)
  • Postgres: Apply ONLY keyword per table in TRUNCATE stmt #1872 (MohamedAbdeen21)
  • Fix CASE expression spans #1874 (eliaperantoni)
  • MySQL: [[NOT] ENFORCED] in CHECK constraint #1870 (MohamedAbdeen21)
  • Add support for CREATE SCHEMA WITH ( <properties> ) #1877 (utay)
  • Add support for ALTER TABLE DROP INDEX #1865 (vimko)
  • chore: Replace archived actions-rs/install action #1876 (assignUser)
  • Allow IF NOT EXISTS after table name for Snowflake #1881 (bombsimon)
  • Support DISTINCT AS { STRUCT | VALUE } for BigQuery #1880 (bombsimon)

Credits

Thank you to everyone who contributed to this release. Here is a breakdown of commits (PRs merged) per contributor.

     7	Ophir LOJKINE
     6	Andrew Harper
     6	Mohamed Abdeen
     3	Luca Cappelletti
     2	Denys Tsomenko
     2	Simon Sawert
     1	Andrew Lamb
     1	Artem Osipov
     1	Chen Chongchen
     1	Dmitriy Mazurin
     1	Elia Perantoni
     1	Hendrik Makait
     1	Jacob Wujciak-Jens
     1	Simon Vandel Sillesen
     1	Yannick Utard
     1	benrsatori
     1	dependabot[bot]
     1	hulk
     1	vimko

Thank you also to everyone who contributed in other ways such as filing issues, reviewing PRs, and providing feedback on this release.