Sourced from sqlparser's changelog.

[0.29.0] 2022-12-29

Highlights

• Partial source location tracking: see #710
• Recursion limit to prevent stack overflows: #764
• AST visitor: #765

Added

feat: dollar-quoted strings support (#772) - Thanks @​vasilev-alex

• Add derive based AST visitor (#765) - Thanks @​tustvold
• Support ALTER INDEX {INDEX_NAME} RENAME TO {NEW_INDEX_NAME} (#767) - Thanks @​devgony
• Support CREATE TABLE ON UPDATE <expr> Function (#685) - Thanks @​CEOJINSUNG
• Support CREATE FUNCTION definition with $$ (#755)- Thanks @​zidaye
• Add location tracking in the tokenizer and parser (#710) - Thanks @​ankrgyl
• Add configurable recursion limit to parser, to protect against stackoverflows (#764) - Thanks @​alamb
• Support parsing scientific notation (such as 10e5) (#768) - Thanks @​Jefffrey
• Support DROP FUNCTION syntax (#752) - Thanks @​zidaye
• Support json operators @> <@, @? and @@ - Thanks @​audunska
• Support the type key (#750)- Thanks @​yuval-illumex

Changed

• Improve docs and add examples for Visitor (#778) - Thanks @​alamb
• Add a backlink from sqlparse_derive to sqlparser and publishing instructions (#779) - Thanks @​alamb
• Document new features, update authors (#776) - Thanks @​alamb
• Improve Readme (#774) - Thanks @​alamb
• Standardize comments on parsing optional keywords (#773) - Thanks @​alamb
• Enable grouping sets parsing for GenericDialect (#771) - Thanks @​Jefffrey
• Generalize conflict target (#762) - Thanks @​audunska
• Generalize locking clause (#759) - Thanks @​audunska
• Add negative test for except clause on wildcards (#746)- Thanks @​alamb
• Add NANOSECOND keyword (#749)- Thanks @​waitingkuo

Fixed

• ParserError if nested explain (#781) - Thanks @​Jefffrey
• Fix cargo docs / warnings and add CI check (#777) - Thanks @​alamb
• unnest join constraint with alias parsing for BigQuery dialect (#732)- Thanks @​Ziinc

[0.28.0] 2022-12-05

Added

• Support for EXCEPT clause on wildcards (#745) - Thanks @​AugustoFKL
• Support CREATE FUNCTION Postgres options (#722) - Thanks @​wangrunji0408
• Support CREATE TABLE x AS TABLE y (#704) - Thanks @​sarahyurick
• Support MySQL ROWS syntax for VALUES (#737) - Thanks @​aljazerzen
• Support WHERE condition for UPDATE ON CONFLICT (#735) - Thanks @​zidaye
• Support CLUSTER BY when creating Materialized View (#736) - Thanks @​yuval-illumex
• Support nested comments (#726) - Thanks @​yang-han
• Support USING method when creating indexes. (#731) - Thanks @​step-baby and @​yangjiaxin01
• Support SEMI/ANTI JOIN syntax (#723) - Thanks @​mingmwang
• Support EXCLUDE support for snowflake and generic dialect (#721) - Thanks @​AugustoFKL

... (truncated)

• 86d71f2 (cargo-release) version 0.29.0
• 890062c Changelog for 29.0.0 (#780)
• 87df09b Improve docs and add examples for Visitor (#778)
• fc503e0 Add a backlink from sqlparse_derive to sqlparser and publishing instructi...
• cf3fe64 ParserError if nested explain (#781)
• b93d82d Fix cargo docs / warnings and add CI check (#777)
• 072ccc0 feat: dollar-quoted strings support (#772)
• 0c9ec40 Document new features, update authors (#776)
• 751046d Improve Readme (#774)
• dec3c2b Add derive based AST visitor (#765)
• Additional commits viewable in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Sourced from datafusion's changelog.

#!/bin/bash

Licensed to the Apache Software Foundation (ASF) under one

or more contributor license agreements. See the NOTICE file

distributed with this work for additional information

regarding copyright ownership. The ASF licenses this file

to you under the Apache License, Version 2.0 (the

"License"); you may not use this file except in compliance

with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing,

software distributed under the License is distributed on an

"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY

KIND, either express or implied. See the License for the

specific language governing permissions and limitations

under the License.

some issues are just documentation

add-sections={"documentation":{"prefix":"Documentation updates:","labels":["documentation"]},"performance":{"prefix":"Performance improvements:","labels":["performance"]}}

uncomment to not show PRs. TBD if we shown them or not.

#pull-requests=false

so that the component is shown associated with the issue

issue-line-labels=sql exclude-labels=development-process,invalid breaking-labels=api change

• 9bee14e Prepare for 15.0.0 Release (#4470)
• 5d69fa3 MINOR: Add note about sqllogictest to contributor guide (#4469)
• b229e0f Drive sqllogictest runner on directory contents rather than hard coded list (...
• 1aa645f Fix push down limit regression when meet SubqueryAlias (#4425)
• fb8eeb2 Expose remaining parquet config options into ConfigOptions (try 2) (#4427)
• 09aea09 Refactor Builtin Window Function Implementation (#4441)
• a0485e7 Add check for nested types in equivalent names and types (#4380)
• ebb475e repalce the compare kernel for decimal dyn op (#4453)
• bde3c91 Replace &Option\<T> with Option\<&T> (#4446)
• 38e9f30 Make datafusion-sql depend on arrow-schema instead of arrow (#4456)
• Additional commits viewable in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Sourced from sqlparser's changelog.

[0.28.0] 2022-12-05

Added

• Support for EXCEPT clause on wildcards (#745) - Thanks @​AugustoFKL
• Support CREATE FUNCTION Postgres options (#722) - Thanks @​wangrunji0408
• Support CREATE TABLE x AS TABLE y (#704) - Thanks @​sarahyurick
• Support MySQL ROWS syntax for VALUES (#737) - Thanks @​aljazerzen
• Support WHERE condition for UPDATE ON CONFLICT (#735) - Thanks @​zidaye
• Support CLUSTER BY when creating Materialized View (#736) - Thanks @​yuval-illumex
• Support nested comments (#726) - Thanks @​yang-han
• Support USING method when creating indexes. (#731) - Thanks @​step-baby and @​yangjiaxin01
• Support SEMI/ANTI JOIN syntax (#723) - Thanks @​mingmwang
• Support EXCLUDE support for snowflake and generic dialect (#721) - Thanks @​AugustoFKL
• Support MATCH AGAINST (#708) - Thanks @​AugustoFKL
• Support IF NOT EXISTS in ALTER TABLE ADD COLUMN (#707) - Thanks @​AugustoFKL
• Support SET TIME ZONE <value> (#727) - Thanks @​waitingkuo
• Support UPDATE ... FROM ( subquery ) (#694) - Thanks @​unvalley

Changed

• Add Parser::index() method to get current parsing index (#728) - Thanks @​neverchanje
• Add COMPRESSION as keyword (#720)- Thanks @​AugustoFKL
• Derive PartialOrd, Ord, and Copy whenever possible (#717) - Thanks @​AugustoFKL
• Fixed INTERVAL parsing logic and precedence (#705) - Thanks @​sarahyurick
• Support updating multiple column names whose names are the same as(#725) - Thanks @​step-baby

Fixed

• Clean up some redundant code in parser (#741) - Thanks @​alamb
• Fix logical conflict - Thanks @​alamb
• Cleanup to avoid is_ok() (#740) - Thanks @​alamb
• Cleanup to avoid using unreachable! when parsing semi/anti join (#738) - Thanks @​alamb
• Add an example to docs to clarify semantic analysis (#739) - Thanks @​alamb
• Add information about parting semantic logic to README.md (#724) - Thanks @​AugustoFKL
• Logical conflicts - Thanks @​alamb
• Tiny typo in docs (#709) - Thanks @​pmcgee69

[0.27.0] 2022-11-11

Added

• Support ON CONFLICT and RETURNING in UPDATE statement (#666) - Thanks @​main and @​gamife
• Support FULLTEXT option on create table for MySQL and Generic dialects (#702) - Thanks @​AugustoFKL
• Support ARRAY_AGG for Bigquery and Snowflake (#662) - Thanks @​SuperBo
• Support DISTINCT for SetOperator (#689) - Thanks @​unvalley
• Support the ARRAY type of Snowflake (#699) - Thanks @​yuval-illumex
• Support create sequence with options INCREMENT, MINVALUE, MAXVALUE, START etc. (#681) - Thanks @​sam-mmm
• Support : operator for semi-structured data in Snowflake(#693) - Thanks @​yuval-illumex
• Support ALTER TABLE DROP PRIMARY KEY (#682) - Thanks @​ding-young
• Support NUMERIC and DEC ANSI data types (#695) - Thanks @​AugustoFKL
• Support modifiers for Custom Datatype (#680) - Thanks @​sunng87

... (truncated)

• 512a159 (cargo-release) version 0.28.0
• 8429108 CHANGELOG.md for 0.28.0 (#747)
• b368851 feat: add support for except clause on wildcards (#745)
• 5b53df9 Support postgres CREATE FUNCTION (#722)
• f621142 Clean up some redundant code in parser (#741)
• 528b3f2 Support CREATE TABLE x AS TABLE y (#704)
• 8e1c90c Support MySQL ROWS syntax for VALUES (#737)
• faf75b7 fix logical conflict
• 042effd update on conflict method (#735)
• a422116 inital commit (#736)
• Additional commits viewable in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Sourced from sqlparser's changelog.

[0.26.0] 2022-10-19

Added

• Support MySQL table option {INDEX | KEY} in CREATE TABLE definiton (#665) - Thanks @​AugustoFKL
• Support CREATE [ { TEMPORARY | TEMP } ] SEQUENCE [ IF NOT EXISTS ] <sequence_name> (#678) - Thanks @​sam-mmm
• Support DROP SEQUENCE statement (#673) - Thanks @​sam-mmm
• Support for ANSI types CHARACTER LARGE OBJECT[(p)] and CHAR LARGE OBJECT[(p)] (#671) - Thanks @​AugustoFKL
• Support [CACHE|UNCACHE] TABLE (#670) - Thanks @​francis-du
• Support CEIL(expr TO DateTimeField) and FLOOR(expr TO DateTimeField) - Thanks @​sarahyurick
• Support all ansii character string types, (#648) - Thanks @​AugustoFKL

Changed

• Support expressions inside window frames (#655) - Thanks @​mustafasrepo and @​ozankabak
• Support unit on char length units for small character strings (#663) - Thanks @​AugustoFKL
• Replace booleans on SET ROLE with a single enum. (#664) - Thanks @​AugustoFKL
• Replace Options with enum for DECIMAL precision (#654) - Thanks @​AugustoFKL

[0.25.0] 2022-10-03

Added

• Support AUTHORIZATION clause in CREATE SCHEMA statements (#641) - Thanks @​AugustoFKL
• Support optional precision for CLOB and BLOB (#639) - Thanks @​AugustoFKL
• Support optional precision in VARBINARY and BINARY (#637) - Thanks @​AugustoFKL

Changed

• TIMESTAMP and TIME parsing preserve zone information (#646) - Thanks @​AugustoFKL

Fixed

• Correct order of arguments when parsing LIMIT x,y , restrict to MySql and Generic dialects - Thanks @​AugustoFKL

[0.24.0] 2022-09-29

Added

• Support MILLENNIUM (2 Ns) (#633) - Thanks @​sarahyurick
• Support MEDIUMINT (#630) - Thanks @​AugustoFKL
• Support DOUBLE PRECISION (#629) - Thanks @​AugustoFKL
• Support precision in CLOB, BINARY, VARBINARY, BLOB data type (#618) - Thanks @​ding-young
• Support CREATE ROLE and DROP ROLE (#598) - Thanks @​blx
• Support full range of sqlite prepared statement placeholders (#604) - Thanks @​lovasoa
• Support National string literal with lower case n (#612) - Thanks @​mskrzypkows
• Support SHOW FUNCTIONS (#620) - Thanks @​joocer
• Support set time zone to 'some-timezone' (#617) - Thanks @​waitingkuo

Changed

• Move Value::Interval to Expr::Interval (#609) - Thanks @​ding-young

... (truncated)

• 2c266a4 (cargo-release) version 0.26.0
• b525c9f Add changelog for 0.26.0 (#679)
• 2aba3f8 Adding MySQL table option {INDEX | KEY} to the CREATE TABLE definiton (partia...
• e3c936a mod, parser and test cases for CREATE [ { TEMPORARY | TEMP } ] SEQUENCE [ IF...
• b32cbbd Support drop sequence statement (#673)
• b42632f Support for ANSI CHARACTER LARGE OBJECT[(p)] and CHAR LARGE OBJECT[(p)]. ...
• a598741 Support cache/uncache table syntax (#670)
• 427bec4 Support for INTERVAL inside window frames (#655)
• cacdf33 Add support for unit on char length units for small character string types. (...
• 7776726 Replacing the two booleans from 'SET ROLE' to a single enum. (#664)
• Additional commits viewable in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Sourced from datafusion's changelog.

#!/bin/bash

Licensed to the Apache Software Foundation (ASF) under one

or more contributor license agreements. See the NOTICE file

distributed with this work for additional information

regarding copyright ownership. The ASF licenses this file

to you under the Apache License, Version 2.0 (the

"License"); you may not use this file except in compliance

with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing,

software distributed under the License is distributed on an

"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY

KIND, either express or implied. See the License for the

specific language governing permissions and limitations

under the License.

some issues are just documentation

add-sections={"documentation":{"prefix":"Documentation updates:","labels":["documentation"]},"performance":{"prefix":"Performance improvements:","labels":["performance"]}}

uncomment to not show PRs. TBD if we shown them or not.

#pull-requests=false

so that the component is shown associated with the issue

issue-line-labels=sql exclude-labels=development-process,invalid breaking-labels=api change

• 807a0c1 Prep for 13.0.0 release (#3746)
• 242b5c5 minor: error message parameter order incorrect (#3748)
• 38cf2eb Build aggregate schema in Aggregate::try_new (#3739)
• 8dcef91 Remove type coercions from ScalarValue and aggregation function code (#3705)
• 88eadc4 delete type coercion for scalar udf in the physical phase (#3735)
• 7c5c2e5 Consolidate coercion code in datafusion_expr::type_coercion and submodules ...
• 23682f6 Use column aliases specified by WITH statements (#3717)
• 64669e9 Fix aggregate type coercion bug (#3710)
• 965133c Skip filter push down on semi/anti joins (#3723)
• beeb631 Raise Unsupported SQL type for Time(WithTimeZone) and Time(Tz) (#3718)
• Additional commits viewable in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Sourced from sqlparser's changelog.

[0.25.0] 2022-10-03

Added

• Support AUTHORIZATION clause in CREATE SCHEMA statements (#646) - Thanks @​AugustoFKL
• Support optional precision for CLOB and BLOB (#639) - Thanks @​AugustoFKL
• Support optional precision in VARBINARY and BINARY (#637) - Thanks @​AugustoFKL

Changed

• TIMESTAMP and TIME parsing preserve zone information (#646) - Thanks @​AugustoFKL

Fixed

• Correct order of arguments when parsing LIMIT x,y , restrict to MySql and Generic dialects - Thanks @​AugustoFKL

[0.24.0] 2022-09-29

Added

• Support MILLENNIUM (2 Ns) (#633) - Thanks @​sarahyurick
• Support MEDIUMINT (#630) - Thanks @​AugustoFKL
• Support DOUBLE PRECISION (#629) - Thanks @​AugustoFKL
• Support precision in CLOB, BINARY, VARBINARY, BLOB data type (#618) - Thanks @​ding-young
• Support CREATE ROLE and DROP ROLE (#598) - Thanks @​blx
• Support full range of sqlite prepared statement placeholders (#604) - Thanks @​lovasoa
• Support National string literal with lower case n (#612) - Thanks @​mskrzypkows
• Support SHOW FUNCTIONS (#620) - Thanks @​joocer
• Support set time zone to 'some-timezone' (#617) - Thanks @​waitingkuo

Changed

• Move Value::Interval to Expr::Interval (#609) - Thanks @​ding-young
• Update criterion dev-requirement from 0.3 to 0.4 in /sqlparser_bench (#611) - Thanks @​dependabot
• Box Query in Cte (#572) - Thanks @​MazterQyou

Other

• Disambiguate CREATE ROLE ... USER and GROUP (#628) - Thanks @​alamb
• Add test for optional WITH in CREATE ROLE (#627) - Thanks @​alamb

[0.23.0] 2022-09-08

Added

• Add support for aggregate expressions with filters (#585) - Thanks @​andygrove
• Support LOCALTIME and LOCALTIMESTAMP time functions (#592) - Thanks @​MazterQyou

[0.22.0] 2022-08-26

Added

• Support OVERLAY expressions (#594) - Thanks @​ayushg

... (truncated)

• 977cdb2 (cargo-release) version 0.25.0
• 97a52cb Changelog for 0.25.0 release (#651)
• 1ced0f6 645 New schema name structure (#646)
• 95464ec Change TIMESTAMP and TIME parsing so that time zone information is preser...
• 3beecc0 Correct order of arguments in LIMIT x,y , restrict to MySql and generic di...
• fb5a974 Support optional precision for CLOB and BLOB (#639)
• 300e28b 636 Adjusting VARBINARY and BINARY with optional precision (#637)
• See full diff in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Sourced from sqlparser's changelog.

[0.23.0] 2022-09-08

Added

• Add support for aggregate expressions with filters (#585) - Thanks @​andygrove
• Support LOCALTIME and LOCALTIMESTAMP time functions (#592) - Thanks @​MazterQyou

[0.22.0] 2022-08-26

Added

• Support OVERLAY expressions (#594) - Thanks @​ayushg
• Support WITH TIMEZONE and WITHOUT TIMEZONE when parsing TIMESTAMP expressions (#589) - Thanks @​waitingkuo
• Add ability for dialects to override prefix, infix, and statement parsing (#581) - Thanks @​andygrove

[0.21.0] 2022-08-18

Added

• Support IS [NOT] TRUE, IS [NOT] FALSE, and IS [NOT] UNKNOWN - Thanks (#583) @​sarahyurick
• Support SIMILAR TO syntax (#569) - Thanks @​ayushdg
• Support SHOW COLLATION (#564) - Thanks @​MazterQyou
• Support SHOW TABLES (#563) - Thanks @​MazterQyou
• Support SET NAMES literal [COLLATE literal] (#558) - Thanks @​ovr
• Support trailing commas (#557) in BigQuery dialect - Thanks @​komukomo
• Support USE <DB> (#565) - Thanks @​MazterQyou
• Support SHOW COLUMNS FROM tbl FROM db (#562) - Thanks @​MazterQyou
• Support SHOW VARIABLES for MySQL dialect (#559) - Thanks @​ovr and @​vasilev-alex

Changed

• Support arbitrary expression in SET statement (#574) - Thanks @​ovr and @​vasilev-alex
• Parse LIKE patterns as Expr not Value (#579) - Thanks @​andygrove
• Update Ballista link in README (#576) - Thanks @​sanxiyn
• Parse TRIM from with optional expr and FROM expr (#573) - Thanks @​ayushdg
• Support PostgreSQL array subquery constructor (#566) - Thanks @​MazterQyou
• Clarify contribution licensing (#570) - Thanks @​alamb
• Update for new clippy ints (#571) - Thanks @​alamb
• Change Like and ILike to Expr variants, allow escape char (#569) - Thanks @​ayushdg
• Parse special keywords as functions (current_user, user, etc) (#561) - Thanks @​ovr
• Support expressions in LIMIT/OFFSET (#567) - Thanks @​MazterQyou

[0.20.0] 2022-08-05

Added

• Support custom OPERATOR postgres syntax (#548) - Thanks @​iskakaushik
• Support SAFE_CAST for BigQuery (#552) - Thanks @​togami2864

Changed

• Added SECURITY.md (#546) - Thanks @​JamieSlome
• Allow >> and << binary operators in Generic dialect (#553) - Thanks @​ovr
• Allow NestedJoin with an alias (#551) - Thanks @​waitingkuo

[0.19.0] 2022-07-28

... (truncated)

• fd07a17 (cargo-release) version 0.23.0
• 303f80f Add support for aggregate expressions with filters (#585)
• 0bb49ce feat: Support LOCALTIME and LOCALTIMESTAMP time functions (#592)
• bccd63e (cargo-release) version 0.22.0
• 0191839 update changelog for 0.22 (#595)
• 6f55dea Add overlay expr (#594)
• 95fbb55 add with/without time zone (#589)
• 72559e9 Add ability for dialects to override prefix, infix, and statement parsing (#581)
• 7c02477 (cargo-release) version 0.21.0
• dcb005e Update changelog (#584)
• Additional commits viewable in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Sourced from sqlparser's changelog.

[0.22.0] 2022-08-26

Added

• Support OVERLAY expressions - Thanks (#594) @​ayushg
• Support WITH TIMEZONE and WITHOUT TIMEZONE when parsing TIMESTAMP expressions - Thanks (#589) @​waitingkuo
• Add ability for dialects to override prefix, infix, and statement parsing - Thanks (#581) @​andygrove

[0.21.0] 2022-08-18

Added

• Support IS [NOT] TRUE, IS [NOT] FALSE, and IS [NOT] UNKNOWN - Thanks (#583) @​sarahyurick
• Support SIMILAR TO syntax (#569) - Thanks @​ayushdg
• Support SHOW COLLATION (#564) - Thanks @​MazterQyou
• Support SHOW TABLES (#563) - Thanks @​MazterQyou
• Support SET NAMES literal [COLLATE literal] (#558) - Thanks @​ovr
• Support trailing commas (#557) in BigQuery dialect - Thanks @​komukomo
• Support USE <DB> (#565) - Thanks @​MazterQyou
• Support SHOW COLUMNS FROM tbl FROM db (#562) - Thanks @​MazterQyou
• Support SHOW VARIABLES for MySQL dialect (#559) - Thanks @​ovr and @​vasilev-alex

Changed

• Support arbitrary expression in SET statement (#574) - Thanks @​ovr and @​vasilev-alex
• Parse LIKE patterns as Expr not Value (#579) - Thanks @​andygrove
• Update Ballista link in README (#576) - Thanks @​sanxiyn
• Parse TRIM from with optional expr and FROM expr (#573) - Thanks @​ayushdg
• Support PostgreSQL array subquery constructor (#566) - Thanks @​MazterQyou
• Clarify contribution licensing (#570) - Thanks @​alamb
• Update for new clippy ints (#571) - Thanks @​alamb
• Change Like and ILike to Expr variants, allow escape char (#569) - Thanks @​ayushdg
• Parse special keywords as functions (current_user, user, etc) (#561) - Thanks @​ovr
• Support expressions in LIMIT/OFFSET (#567) - Thanks @​MazterQyou

[0.20.0] 2022-08-05

Added

• Support custom OPERATOR postgres syntax (#548) - Thanks @​iskakaushik
• Support SAFE_CAST for BigQuery (#552) - Thanks @​togami2864

Changed

• Added SECURITY.md (#546) - Thanks @​JamieSlome
• Allow >> and << binary operators in Generic dialect (#553) - Thanks @​ovr
• Allow NestedJoin with an alias (#551) - Thanks @​waitingkuo

[0.19.0] 2022-07-28

Added

• Support ON CLUSTER for CREATE TABLE statement (ClickHouse DDL) (#527) - Thanks @​andyrichardson
• Support empty ARRAY literals (#532) - Thanks @​bitemyapp
• Support AT TIME ZONE clause (#539) - Thanks @​bitemyapp

... (truncated)

• bccd63e (cargo-release) version 0.22.0
• 0191839 update changelog for 0.22 (#595)
• 6f55dea Add overlay expr (#594)
• 95fbb55 add with/without time zone (#589)
• 72559e9 Add ability for dialects to override prefix, infix, and statement parsing (#581)
• 7c02477 (cargo-release) version 0.21.0
• dcb005e Update changelog (#584)
• 6d8aacd feat: Support expression in SET statement (#574)
• eb7f1b0 Parse LIKE patterns as Expr not Value (#579)
• fc71719 add unknown, is not true/false/unknown (#583)
• Additional commits viewable in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Sourced from datafusion's changelog.

#!/bin/bash

Licensed to the Apache Software Foundation (ASF) under one

or more contributor license agreements. See the NOTICE file

distributed with this work for additional information

regarding copyright ownership. The ASF licenses this file

to you under the Apache License, Version 2.0 (the

"License"); you may not use this file except in compliance

with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing,

software distributed under the License is distributed on an

"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY

KIND, either express or implied. See the License for the

specific language governing permissions and limitations

under the License.

some issues are just documentation

add-sections={"documentation":{"prefix":"Documentation updates:","labels":["documentation"]},"performance":{"prefix":"Performance improvements:","labels":["performance"]}}

uncomment to not show PRs. TBD if we shown them or not.

#pull-requests=false

so that the component is shown associated with the issue

issue-line-labels=sql exclude-labels=development-process,invalid breaking-labels=api change

• 8ee31cc Prepare for 11.0.0 release (#3171)
• 85f7fc9 Rename do_data_time_math() to do_date_time_math() (#3173)
• f677e50 Return proper error message for ill formed variable reference (#3162)
• 89bcfc4 Support INTEGER again in addition to INT in CREATE TABLE and CAST sta...
• 8e9a8d5 [Minor] Remove some redundant code (#3169)
• ccd9406 MINOR: Fix broken links in contrib guide (#3135)
• e57dead add test case for cast_timestamp_before_1970 (#3163)
• 9543d38 fix regression in sql parser related to resolution of aliased expressions (#3...
• 36def8f update cargo lock (#3164)
• fb70057 Rename DateIntervalExpr to DateTimeIntervalExpr (#3150)
• Additional commits viewable in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Sourced from sqlparser's changelog.

[0.21.0] 2022-08-18

Added

• Support IS [NOT] TRUE, IS [NOT] FALSE, and IS [NOT] UNKNOWN - Thanks (#583) @​sarahyurick
• Support SIMILAR TO syntax (#569) - Thanks @​ayushdg
• Support SHOW COLLATION (#564) - Thanks @​MazterQyou
• Support SHOW TABLES (#563) - Thanks @​MazterQyou
• Support SET NAMES literal [COLLATE literal] (#558) - Thanks @​ovr
• Support trailing commas (#557) in BigQuery dialect - Thanks @​komukomo
• Support USE <DB> (#565) - Thanks @​MazterQyou
• Support SHOW COLUMNS FROM tbl FROM db (#562) - Thanks @​MazterQyou
• Support SHOW VARIABLES for MySQL dialect (#559) - Thanks @​ovr and @​vasilev-alex

Changed

• Support arbitrary expression in SET statement (#574) - Thanks @​ovr and @​vasilev-alex
• Parse LIKE patterns as Expr not Value (#579) - Thanks @​andygrove
• Update Ballista link in README (#576) - Thanks @​sanxiyn
• Parse TRIM from with optional expr and FROM expr (#573) - Thanks @​ayushdg
• Support PostgreSQL array subquery constructor (#566) - Thanks @​MazterQyou
• Clarify contribution licensing (#570) - Thanks @​alamb
• Update for new clippy ints (#571) - Thanks @​alamb
• Change Like and ILike to Expr variants, allow escape char (#569) - Thanks @​ayushdg
• Parse special keywords as functions (current_user, user, etc) (#561) - Thanks @​ovr
• Support expressions in LIMIT/OFFSET (#567) - Thanks @​MazterQyou

[0.20.0] 2022-08-05

Added

• Support custom OPERATOR postgres syntax (#548) - Thanks @​iskakaushik
• Support SAFE_CAST for BigQuery (#552) - Thanks @​togami2864

Changed

• Added SECURITY.md (#546) - Thanks @​JamieSlome
• Allow >> and << binary operators in Generic dialect (#553) - Thanks @​ovr
• Allow NestedJoin with an alias (#551) - Thanks @​waitingkuo

[0.19.0] 2022-07-28

Added

• Support ON CLUSTER for CREATE TABLE statement (ClickHouse DDL) (#527) - Thanks @​andyrichardson
• Support empty ARRAY literals (#532) - Thanks @​bitemyapp
• Support AT TIME ZONE clause (#539) - Thanks @​bitemyapp
• Support USING clause and table aliases in DELETE (#541) - Thanks @​mobuchowski
• Support SHOW CREATE VIEW statement (#536) - Thanks @​mrob95
• Support CLONE clause in CREATE TABLE statements (#542) - Thanks @​mobuchowski
• Support WITH OFFSET Alias in table references (#528) - Thanks @​sivchari
• Support double quoted (") literal strings: (#530) - Thanks @​komukomo
• Support ON UPDATE clause on column definitions in CREATE TABLE statements (#522) - Thanks @​frolovdev

... (truncated)

• 7c02477 (cargo-release) version 0.21.0
• dcb005e Update changelog (#584)
• 6d8aacd feat: Support expression in SET statement (#574)
• eb7f1b0 Parse LIKE patterns as Expr not Value (#579)
• fc71719 add unknown, is not true/false/unknown (#583)
• 50aafa8 Update Ballista link in README (#576)
• 42c5d43 Support TRIM from with optional FROM clause (#573)
• 31ba001 Support PostgreSQL array subquery constructor (#566)
• 61dc3e9 Clarify contribution licensing (#570)
• 36de9a6 Update for new clippy ints (#571)
• Additional commits viewable in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Sourced from sqlparser's changelog.

[0.20.0] 2022-08-05

Added

• Support custom OPERATOR postgres syntax (#548) - Thanks @​iskakaushik
• Support SAFE_CAST for BigQuery (#552) - Thanks @​togami2864

Changed

• Added SECURITY.md (#546) - Thanks @​JamieSlome
• Allow >> and << binary operators in Generic dialect (#553) - Thanks @​ovr
• Allow NestedJoin with an alias (#551) - Thanks @​waitingkuo

[0.19.0] 2022-07-28

Added

• Support ON CLUSTER for CREATE TABLE statement (ClickHouse DDL) (#527) - Thanks @​andyrichardson
• Support empty ARRAY literals (#532) - Thanks @​bitemyapp
• Support AT TIME ZONE clause (#539) - Thanks @​bitemyapp
• Support USING clause and table aliases in DELETE (#541) - Thanks @​mobuchowski
• Support SHOW CREATE VIEW statement (#536) - Thanks @​mrob95
• Support CLONE clause in CREATE TABLE statements (#542) - Thanks @​mobuchowski
• Support WITH OFFSET Alias in table references (#528) - Thanks @​sivchari
• Support double quoted (") literal strings: (#530) - Thanks @​komukomo
• Support ON UPDATE clause on column definitions in CREATE TABLE statements (#522) - Thanks @​frolovdev

Changed:

• Boxed Query body to save stack space (#540) - Thanks @​5tan
• Distinguish between INT and INTEGER types (#525) - Thanks @​frolovdev
• Parse WHERE NOT EXISTS as Expr::Exists rather than Expr::UnaryOp for consistency (#523) - Thanks @​frolovdev
• Support Expr instead of String for argument to INTERVAL (#517) - Thanks @​togami2864

Fixed:

• Report characters instead of bytes in error messages (#529) - Thanks @​michael-2956

[0.18.0] 2022-06-06

Added

• Support CLOSE (cursors) (#515) - Thanks @​ovr
• Support DECLARE (cursors) (#509) - Thanks @​ovr
• Support FETCH (cursors) (#510) - Thanks @​ovr
• Support DATETIME keyword (#512) - Thanks @​komukomo
• Support UNNEST as a table factor (#493) - Thanks @​sivchari
• Support CREATE FUNCTION (hive flavor) (#496) - Thanks @​mobuchowski
• Support placeholders ($ or ?) in LIMIT clause (#494) - Thanks @​step-baby
• Support escaped string literals (PostgreSQL) (#502) - Thanks @​ovr

... (truncated)

• 231370a (cargo-release) version 0.20.0
• bb5e278 Make 0.20.0 release notes (#555)
• 9648a52 Create SECURITY.md (#546)
• 1c64129 [postgres] Add support for custom binary operators (#548)
• 6c98228 feat: Allow to use >> and << binary operators in Generic dialect (#553)
• 076b587 Support NestedJoin with an alias (#551)
• e24951e feat: support SAFE_CAST for bigquery (#552)
• 2a04212 (cargo-release) version 0.19.0
• ec22e00 Update CHANGELOG.md for 0.19.0 (#545)
• 16af309 Add support for ClickHouse DDL query syntax (on cluster) (#527)
• Additional commits viewable in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Sourced from sqlparser's changelog.

[0.30.0] 2023-01-02

Added

• Support RENAME for wildcard SELECTs (#784) - Thanks @​Jefffrey
• Add a mutable visitor (#782) - Thanks @​lovasoa

Changed

• Allow parsing of mysql empty row inserts (#783) - Thanks @​Jefffrey

Fixed

• Fix logical conflict (#785) - Thanks @​alamb

[0.29.0] 2022-12-29

Highlights

• Partial source location tracking: see #710
• Recursion limit to prevent stack overflows: #764
• AST visitor: #765

Added

feat: dollar-quoted strings support (#772) - Thanks @​vasilev-alex

• Add derive based AST visitor (#765) - Thanks @​tustvold
• Support ALTER INDEX {INDEX_NAME} RENAME TO {NEW_INDEX_NAME} (#767) - Thanks @​devgony
• Support CREATE TABLE ON UPDATE <expr> Function (#685) - Thanks @​CEOJINSUNG
• Support CREATE FUNCTION definition with $$ (#755)- Thanks @​zidaye
• Add location tracking in the tokenizer and parser (#710) - Thanks @​ankrgyl
• Add configurable recursion limit to parser, to protect against stackoverflows (#764) - Thanks @​alamb
• Support parsing scientific notation (such as 10e5) (#768) - Thanks @​Jefffrey
• Support DROP FUNCTION syntax (#752) - Thanks @​zidaye
• Support json operators @> <@, @? and @@ - Thanks @​audunska
• Support the type key (#750)- Thanks @​yuval-illumex

Changed

• Improve docs and add examples for Visitor (#778) - Thanks @​alamb
• Add a backlink from sqlparse_derive to sqlparser and publishing instructions (#779) - Thanks @​alamb
• Document new features, update authors (#776) - Thanks @​alamb
• Improve Readme (#774) - Thanks @​alamb
• Standardize comments on parsing optional keywords (#773) - Thanks @​alamb
• Enable grouping sets parsing for GenericDialect (#771) - Thanks @​Jefffrey
• Generalize conflict target (#762) - Thanks @​audunska
• Generalize locking clause (#759) - Thanks @​audunska
• Add negative test for except clause on wildcards (#746)- Thanks @​alamb
• Add NANOSECOND keyword (#749)- Thanks @​waitingkuo

Fixed

• ParserError if nested explain (#781) - Thanks @​Jefffrey
• Fix cargo docs / warnings and add CI check (#777) - Thanks @​alamb
• unnest join constraint with alias parsing for BigQuery dialect (#732)- Thanks @​Ziinc

[0.28.0] 2022-12-05

... (truncated)

• 260a012 (cargo-release) version 0.30.0
• d0ef564 Changelog for 0.30.0 (#786)
• 204bdc5 Fix logical conflict (#785)
• 17f604f Support RENAME for wildcard SELECTs (#784)
• 98403c0 Allow parsing of mysql empty row inserts (#783)
• 524b8a7 Add a mutable visitor (#782)
• See full diff in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

Sourced from actions/checkout's releases.

v3.2.0

What's Changed

• Add GitHub Action to perform release by @​rentziass in actions/checkout#942
• Fix status badge by @​ScottBrenner in actions/checkout#967
• Replace datadog/squid with ubuntu/squid Docker image by @​cory-miller in actions/checkout#1002
• Wrap pipeline commands for submoduleForeach in quotes by @​jokreliable in actions/checkout#964
• Update @​actions/io to 1.1.2 by @​cory-miller in actions/checkout#1029
• Upgrading version to 3.2.0 by @​vmjoseph in actions/checkout#1039

New Contributors

• @​ScottBrenner made their first contribution in actions/checkout#967
• @​cory-miller made their first contribution in actions/checkout#1002
• @​jokreliable made their first contribution in actions/checkout#964
• @​vmjoseph made their first contribution in actions/checkout#1039

Full Changelog: https://github.com/actions/checkout/compare/v3...v3.2.0

Sourced from actions/checkout's changelog.

Changelog

• 755da8c 3.2.0 (#1039)
• 26d48e8 Update @​actions/io to 1.1.2 (#1029)
• bf08527 wrap pipeline commands for submoduleForeach in quotes (#964)
• 5c3ccc2 Replace datadog/squid with ubuntu/squid Docker image (#1002)
• 1f9a0c2 README - fix status badge (#967)
• 8230315 Add workflow to update a main version (#942)
• See full diff in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)