dependabot[bot] opened a new pull request, #8647: URL: https://github.com/apache/arrow-datafusion/pull/8647
Updates the requirements on [sqlparser](https://github.com/sqlparser-rs/sqlparser-rs) to permit the latest version. <details> <summary>Changelog</summary> <p><em>Sourced from <a href="https://github.com/sqlparser-rs/sqlparser-rs/blob/main/CHANGELOG.md";>sqlparser's changelog</a>.</em></p> <blockquote> <h2>[0.40.0] 2023-11-27</h2> <h3>Added</h3> <ul> <li>Add <code>{pre,post}_visit_query</code> to <code>Visitor</code> (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1044";>#1044</a>) - Thanks <a href="https://github.com/jmhain";><code>@jmhain</code></a></li> <li>Support generated virtual columns with expression (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1051";>#1051</a>) - Thanks <a href="https://github.com/takluyver";><code>@takluyver</code></a></li> <li>Support PostgreSQL <code>END</code> (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1035";>#1035</a>) - Thanks <a href="https://github.com/tobyhede";><code>@tobyhede</code></a></li> <li>Support <code>INSERT INTO ... DEFAULT VALUES ...</code> (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1036";>#1036</a>) - Thanks <a href="https://github.com/CDThomas";><code>@CDThomas</code></a></li> <li>Support <code>RELEASE</code> and <code>ROLLBACK TO SAVEPOINT</code> (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1045";>#1045</a>) - Thanks <a href="https://github.com/CDThomas";><code>@CDThomas</code></a></li> <li>Support <code>CONVERT</code> expressions (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1048";>#1048</a>) - Thanks <a href="https://github.com/lovasoa";><code>@lovasoa</code></a></li> <li>Support <code>GLOBAL</code> and <code>SESSION</code> parts in <code>SHOW VARIABLES</code> for mysql and generic - Thanks <a href="https://github.com/emin100";><code>@emin100</code></a></li> <li>Support snowflake <code>PIVOT</code> on derived table factors (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1027";>#1027</a>) - Thanks <a href="https://github.com/lustefaniak";><code>@lustefaniak</code></a></li> <li>Support mssql json and xml extensions (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1043";>#1043</a>) - Thanks <a href="https://github.com/lovasoa";><code>@lovasoa</code></a></li> <li>Support for <code>MAX</code> as a character length (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1038";>#1038</a>) - Thanks <a href="https://github.com/lovasoa";><code>@lovasoa</code></a></li> <li>Support <code>IN ()</code> syntax of SQLite (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1028";>#1028</a>) - Thanks <a href="https://github.com/alamb";><code>@alamb</code></a></li> </ul> <h3>Fixed</h3> <ul> <li>Fix extra whitespace printed before <code>ON CONFLICT</code> (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1037";>#1037</a>) - Thanks <a href="https://github.com/CDThomas";><code>@CDThomas</code></a></li> </ul> <h3>Changed</h3> <ul> <li>Document round trip ability (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1052";>#1052</a>) - Thanks <a href="https://github.com/alamb";><code>@alamb</code></a></li> <li>Add PRQL to list of users (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1031";>#1031</a>) - Thanks <a href="https://github.com/vanillajonathan";><code>@vanillajonathan</code></a></li> </ul> <h2>[0.39.0] 2023-10-27</h2> <h3>Added</h3> <ul> <li>Support for <code>LATERAL FLATTEN</code> and similar (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1026";>#1026</a>) - Thanks <a href="https://github.com/lustefaniak";><code>@lustefaniak</code></a></li> <li>Support BigQuery struct, array and bytes , int64, <code>float64</code> datatypes (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1003";>#1003</a>) - Thanks <a href="https://github.com/iffyio";><code>@iffyio</code></a></li> <li>Support numbers as placeholders in Snowflake (e.g. <code>:1)</code> (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1001";>#1001</a>) - Thanks <a href="https://github.com/yuval-illumex";><code>@yuval-illumex</code></a></li> <li>Support date 'key' when using semi structured data (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1023";>#1023</a>) <a href="https://github.com/yuval-illumex";><code>@yuval-illumex</code></a></li> <li>Support IGNORE|RESPECT NULLs clause in window functions (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/998";>#998</a>) - Thanks <a href="https://github.com/yuval-illumex";><code>@yuval-illumex</code></a></li> <li>Support for single-quoted identifiers (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1021";>#1021</a>) - Thanks <a href="https://github.com/lovasoa";><code>@lovasoa</code></a></li> <li>Support multiple PARTITION statements in ALTER TABLE ADD statement (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1011";>#1011</a>) - Thanks <a href="https://github.com/bitemyapp";><code>@bitemyapp</code></a></li> <li>Support "with" identifiers surrounded by backticks in GenericDialect (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1010";>#1010</a>) - Thanks <a href="https://github.com/bitemyapp";><code>@bitemyapp</code></a></li> <li>Support INSERT IGNORE in MySql and GenericDialect (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1004";>#1004</a>) - Thanks <a href="https://github.com/emin100";><code>@emin100</code></a></li> <li>Support SQLite <code>pragma</code> statement (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/969";>#969</a>) - Thanks <a href="https://github.com/marhoily";><code>@marhoily</code></a></li> <li>Support <code>position</code> as a column name (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1022";>#1022</a>) - Thanks <a href="https://github.com/lustefaniak";><code>@lustefaniak</code></a></li> <li>Support <code>FILTER</code> in Functions (for <code>OVER</code>) clause (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1007";>#1007</a>) - Thanks <a href="https://github.com/lovasoa";><code>@lovasoa</code></a></li> <li>Support <code>SELECT * EXCEPT/REPLACE</code> syntax from ClickHouse (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1013";>#1013</a>) - Thanks <a href="https://github.com/lustefaniak";><code>@lustefaniak</code></a></li> <li>Support subquery as function arg w/o parens in Snowflake dialect (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/996";>#996</a>) - Thanks <a href="https://github.com/jmhain";><code>@jmhain</code></a></li> <li>Support <code>UNION DISTINCT BY NAME</code> syntax (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/997";>#997</a>) - Thanks <a href="https://github.com/alexander-beedie";><code>@alexander-beedie</code></a></li> <li>Support mysql <code>RLIKE</code> and <code>REGEXP</code> binary operators (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/1017";>#1017</a>) - Thanks <a href="https://github.com/lovasoa";><code>@lovasoa</code></a></li> <li>Support bigquery <code>CAST AS x [STRING|DATE] FORMAT</code> syntax (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/978";>#978</a>) - Thanks <a href="https://github.com/lustefaniak";><code>@lustefaniak</code></a></li> <li>Support Snowflake/BigQuery <code>TRIM</code>. (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/975";>#975</a>) - Thanks <a href="https://github.com/zdenal";><code>@zdenal</code></a></li> <li>Support <code>CREATE [TEMPORARY|TEMP] VIEW [IF NOT EXISTS] </code>(<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/993";>#993</a>) - Thanks <a href="https://github.com/gabivlj";><code>@gabivlj</code></a></li> <li>Support for <code>CREATE VIEW … WITH NO SCHEMA BINDING</code> Redshift (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/979";>#979</a>) - Thanks <a href="https://github.com/lustefaniak";><code>@lustefaniak</code></a></li> <li>Support <code>UNPIVOT</code> and a fix for chained PIVOTs (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/983";>#983</a>) - <a href="https://github.com/jmhain";><code>@jmhain</code></a></li> <li>Support for <code>LIMIT BY</code> (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/977";>#977</a>) - Thanks <a href="https://github.com/lustefaniak";><code>@lustefaniak</code></a></li> <li>Support for mixed BigQuery table name quoting (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/971";>#971</a>) - Thanks <a href="https://github.com/iffyio";><code>@iffyio</code></a></li> <li>Support <code>DELETE</code> with <code>ORDER BY</code> and <code>LIMIT</code> (MySQL) (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/992";>#992</a>) - Thanks <a href="https://github.com/ulrichsg";><code>@ulrichsg</code></a></li> <li>Support <code>EXTRACT</code> for <code>DAYOFWEEK</code>, <code>DAYOFYEAR</code>, <code>ISOWEEK</code>, <code>TIME</code> (<a href="https://redirect.github.com/sqlparser-rs/sqlparser-rs/issues/980";>#980</a>) - Thanks <a href="https://github.com/lustefaniak";><code>@lustefaniak</code></a></li> </ul> <!-- raw HTML omitted --> </blockquote> <p>... (truncated)</p> </details> <details> <summary>Commits</summary> <ul> <li>See full diff in <a href="https://github.com/sqlparser-rs/sqlparser-rs/compare/v0.40.0...v0.40.0";>compare view</a></li> </ul> </details> <br /> Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting `@dependabot rebase`. [//]: # (dependabot-automerge-start) [//]: # (dependabot-automerge-end) --- <details> <summary>Dependabot commands and options</summary> <br /> 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 show <dependency name> ignore conditions` will show all of the ignore conditions of the specified dependency - `@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) </details> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
