sqlparser-rs 0.60.0 Changelog

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

Implemented enhancements:

  • feat: Add RESET to the base dialect #2078 #2079 (watford-ep)
  • feat: Add support for SET SESSION AUTHORIZATION #2086 #2087 (watford-ep)

Fixed bugs:

  • fix: parse error on unnamed arg with default syntax #2091 (r1b)

Other:

  • Add support for INVISIBLE columns in MySQL #2033 (altmannmarcelo)
  • Link to actual change logs in CHANGELOG.md #2040 (lovasoa)
  • Snowflake: ALTER USER and KeyValueOptions Refactoring #2035 (yoavcloud)
  • Correctly tokenize nested comments in Databricks, ClickHouse, and ANSI #2044 (jmhain)
  • MySQL: CREATE INDEX: allow USING clause before ON #2029 (MohamedAbdeen21)
  • [databricks] update dialect to support grouping by with modifier #2047 (n-young)
  • Moved constraint variant outside of TableConstraint enum #2054 (LucaCappelletti94)
  • Add support for procedure parameter default values #2041 (aharpervc)
  • Support updating PRs using github UI #2052 (blaginin)
  • Increase version of sqlparser_derive from 0.3.0 to 0.4.0 #2060 (jjbayer)
  • Moving several struct variants out of Statement enum to allow for trait impls for specific sub-variants #2057 (LucaCappelletti94)
  • Added support for SQLite triggers #2037 (LucaCappelletti94)
  • Added support for MATCH syntax and unified column option ForeignKey #2062 (LucaCappelletti94)
  • chore: add stack overflow warning for Visitor and VisitorMut #2068 (niebayes)
  • Reused CheckConstraint in ColumnOption #2063 (LucaCappelletti94)
  • Refactored ColumnOption::Unique to reuse UniqueConstraint and PrimaryKeyConstraint #2064 (LucaCappelletti94)
  • Redshift: more copy options #2072 (yoavcloud)
  • SQLite: make period optional for CREATE TRIGGER #2071 (takluyver)
  • Added TIMESTAMP_NTZ type support with precision to Snowflake dialect #2080 (romanoff)
  • Make BitwiseNot (“~”) available for all dialects, not just PostgreSQL #2081 (alexander-beedie)
  • Add snowflake dynamic table parsing #2083 (romanoff)
  • Add support for INSERT INTO VALUE #2085 (etgarperets)
  • Complete PostgreSQL CREATE TYPE Support #2094 (LucaCappelletti94)
  • Include DML keyword in statement span #2090 (xitep)
  • Add PostgreSQL Operator DDL Support #2096 (LucaCappelletti94)
  • impl Spanned for MERGE statements #2100 (xitep)
  • Preserve optional AS keyword in aliases #2103 (xitep)
  • Added support for DROP OPERATOR syntax #2102 (LucaCappelletti94)
  • Only set hive_formats on CreateTable if formats are present #2105 (mvzink)
  • Support PostgreSQL C Functions with Multiple AS Parameters #2095 (LucaCappelletti94)
  • Added support for DROP OPERATOR FAMILY #2106 (LucaCappelletti94)
  • Update criterion requirement from 0.7 to 0.8 in /sqlparser_bench #2111 (dependabot[bot])
  • Added support for DROP OPERATOR CLASS syntax #2109 (LucaCappelletti94)
  • Introduce Oracle dialect #2113 (xitep)

Credits

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

    12	Luca Cappelletti
     4	xitep
     2	Andriy Romanov
     2	Christopher Watford
     2	Yoav Cohen
     1	Alexander Beedie
     1	Andrew Harper
     1	Dmitrii Blaginin
     1	Joey Hain
     1	Joris Bayer
     1	Marcelo Altmann
     1	Michael Victor Zink
     1	Mohamed Abdeen
     1	Ophir LOJKINE
     1	Thomas Kluyver
     1	dependabot[bot]
     1	etgarperets
     1	nick young
     1	niebayes
     1	r1b

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