chore(deps): update sqlparser requirement from 0.46 to 0.47

[dependabot[bot]]

Updates the requirements on sqlparser to permit the latest version.

Changelog

Sourced from sqlparser's changelog.

[0.47.0] 2024-06-01

Fixed

• Re-support Postgres array slice syntax (#1290) - Thanks @​jmhain
• Fix DoubleColon cast skipping AT TIME ZONE #1266 (#1267) - Thanks @​dmitrybugakov
• Fix for values as table name in Databricks and generic (#1278) - Thanks @​jmhain

Added

• Support ASOF joins in Snowflake (#1288) - Thanks @​jmhain
• Support CREATE VIEW with fields and data types ClickHouse (#1292) - Thanks @​7phs
• Support view comments for Snowflake (#1287) - Thanks @​bombsimon
• Support dynamic pivot in Snowflake (#1280) - Thanks @​jmhain
• Support CREATE FUNCTION for BigQuery, generalize AST (#1253) - Thanks @​iffyio
• Support expression in AT TIME ZONE and fix precedence (#1272) - Thanks @​jmhain
• Support IGNORE/RESPECT NULLS inside function argument list for Databricks (#1263) - Thanks @​jmhain
• Support SELECT * EXCEPT Databricks (#1261) - Thanks @​jmhain
• Support triple quoted strings (#1262) - Thanks @​iffyio
• Support array indexing for duckdb (#1265) - Thanks @​JichaoS
• Support multiple SET variables (#1252) - Thanks @​iffyio
• Support ANY_VALUE HAVING clause (#1258) in BigQuery - Thanks @​jmhain
• Support keywords as field names in BigQuery struct syntax (#1254) - Thanks @​iffyio
• Support GROUP_CONCAT() in MySQL (#1256) - Thanks @​jmhain
• Support lambda functions in Databricks (#1257) - Thanks @​jmhain
• Add const generic peek_tokens method to parser (#1255) - Thanks @​jmhain

[0.46.0] 2024-05-03

Changed

• Consolidate representation of function calls, remove AggregateExpressionWithFilter, ArraySubquery, ListAgg and ArrayAgg (#1247) - Thanks jmhain
• Extended dialect trait to support numeric prefixed identifiers (#1188) - Thanks @​groobyming
• Update simple_logger requirement from 4.0 to 5.0 (#1246) - Thanks @​dependabot
• Improve parsing of JSON accesses on Postgres and Snowflake (#1215) - Thanks @​jmhain
• Encapsulate Insert and Delete into specific structs (#1224) - Thanks @​tisonkun
• Preserve double colon casts (and simplify cast representations) (#1221) - Thanks @​jmhain

Fixed

• Fix redundant brackets in Hive/Snowflake/Redshift (#1229) - Thanks @​yuval-illumex

Added

• Support values without parens in Snowflake and DataBricks (#1249) - Thanks @​HiranmayaGundu
• Support WINDOW clause after QUALIFY when parsing (#1248) - Thanks @​iffyio
• Support DECLARE parsing for mssql (#1235) - Thanks @​devanbenz
• Support ?-based jsonb operators in Postgres (#1242) - THanks @​ReppCodes
• Support Struct datatype parsing for GenericDialect (#1241) - Thanks @​duongcongtoai
• Support BigQuery window function null treatment (#1239) - Thanks @​iffyio
• Support extend pivot operator - Thanks @​iffyio
• Support Databricks SQL dialect (#1220) - Thanks @​jmhain
• Support for MSSQL CONVERT styles (#1219) - Thanks @​iffyio
• Support window clause using named window in BigQuery (#1237) - Thanks @​iffyio

... (truncated)

Commits

• f3f5de5 chore: Release sqlparser version 0.47.0
• 521a2c9 Add CHANGELOG for 0.47.0 (#1295)
• afa5f08 Support for Postgres array slice syntax (#1290)
• 80c03f5 Support for Snowflake ASOF joins (#1288)
• 375742d ClickHouse: create view with fields and data types (#1292)
• 029a999 Add support for view comments for Snowflake (#1287)
• c2d84f5 Support for Snowflake dynamic pivot (#1280)
• 792e389 Support CREATE FUNCTION for BigQuery (#1253)
• d5faf3c Support expression in AT TIME ZONE and fix precedence (#1272)
• 9d15f7e Support: Databricks and generic: fix for values as table name (#1278)
• Additional commits viewable in compare view

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 commands and options

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 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)