Commit graph

581 commits

Author SHA1 Message Date
Yoav Cohen
8cfc46277f
Add support for MySQL's INSERT INTO ... SET syntax (#1641) 2025-01-06 20:13:38 +01:00
Yoav Cohen
17e22f0a60
Add support for the SQL OVERLAPS predicate (#1638) 2025-01-06 16:35:24 +01:00
Yoav Cohen
e23877cb2d
Add support for various Snowflake grantees (#1640) 2025-01-05 13:31:51 -05:00
wugeer
94ea20628f
Add support for MYSQL's RENAME TABLE (#1616)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2025-01-01 21:54:58 +01:00
Jax Liu
d0d4153137
Fix the parsing result for the special double number (#1621) 2024-12-28 14:16:30 +01:00
Yuval Shkolar
024a878ee7
Support Snowflake Update-From-Select (#1604)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2024-12-24 10:00:59 -05:00
Ifeanyi Ubah
14cefc47ed
Merge composite and compound expr test cases (#1615) 2024-12-22 16:40:08 -05:00
Toby Hede
27822e254b
Handle empty projection in Postgres SELECT statements (#1613) 2024-12-22 11:19:43 -05:00
Jax Liu
0647a4aa82
Consolidate MapAccess, and Subscript into CompoundExpr to handle the complex field access chain (#1551) 2024-12-22 15:28:44 +01:00
Ayman Elkfrawy
cd898cb6a4
Support arbitrary composite access expressions (#1600) 2024-12-22 15:22:16 +01:00
Dmitrii Blaginin
84e82e6e2e
Add #[recursive] (#1522)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2024-12-19 14:17:20 -05:00
artorias1024
c973df35d6
Support DOUBLE data types with precision for Mysql (#1611) 2024-12-19 18:11:39 +01:00
yuyang
eae5629fb8
Support optional table for ANALYZE statement (#1599) 2024-12-19 10:18:45 +01:00
Ramnivas Laddad
6523dabcf8
Allow foreign table constraint without columns (#1608) 2024-12-19 10:10:53 +01:00
cjw
8fcdf48e5c
Support parsing EXPLAIN ESTIMATE of Clickhouse (#1605)
Co-authored-by: Kermit <chenjiawei1@xiaohongshu.com>
2024-12-17 10:03:12 -05:00
Yoav Cohen
316bb14135
Add support for TABLESAMPLE (#1580) 2024-12-15 10:40:25 +01:00
Ifeanyi Ubah
a13f8c6b93
Add support for ODBC functions (#1585) 2024-12-11 17:31:55 -05:00
Ifeanyi Ubah
04271b0e4e
Parse INSERT with subquery when lacking column names (#1586) 2024-12-11 17:31:24 -05:00
Yoav Cohen
7b50ac31c3
Parse Snowflake USE ROLE and USE SECONDARY ROLES (#1578) 2024-12-05 19:17:52 +01:00
hulk
dd7ba72a0b
Add support of the ENUM8|ENUM16 for ClickHouse dialect (#1574) 2024-12-05 15:59:07 +01:00
Michael Victor Zink
c761f0babb
Fix displaying WORK or TRANSACTION after BEGIN (#1565) 2024-12-03 20:10:28 -05:00
Michael Victor Zink
6d4188de53
Support BIT column types (#1577) 2024-12-03 19:47:12 -05:00
Mark-Oliver Junge
3c8fd74804
Implement Spanned to retrieve source locations on AST nodes (#1435)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2024-11-26 11:22:30 -05:00
Ophir LOJKINE
525d1780e8
support json_object('k':'v') in postgres (#1546) 2024-11-25 16:01:23 -05:00
Yoav Cohen
fd21fae297
Fallback to identifier parsing if expression parsing fails (#1513) 2024-11-25 16:01:02 -05:00
Yoav Cohen
62fa8604af
PartiQL queries in Redshift (#1534) 2024-11-23 07:14:38 -05:00
wugeer
73947a5f02
Add support for PostgreSQL UNLISTEN syntax and Add support for Postgres LOAD extension expr (#1531)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2024-11-19 16:14:28 -05:00
gaoqiangz
92be237cfc
Add support for MSSQL's JSON_ARRAY/JSON_OBJECT expr (#1507)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2024-11-18 09:22:18 -05:00
Ophir LOJKINE
f961efc0c9
support column type definitions in table aliases (#1526) 2024-11-18 09:02:22 -05:00
Ophir LOJKINE
4c629e8520
support sqlite's OR clauses in update statements (#1530) 2024-11-18 07:30:53 -05:00
delamarch3
a67a4f3cbe
Support ANTI and SEMI joins without LEFT/RIGHT (#1528) 2024-11-18 07:30:20 -05:00
wugeer
724a1d1aba
Add support for Hive's LOAD DATA expr (#1520)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2024-11-15 09:53:31 -05:00
gaoqiangz
62eaee62dc
Add support for MSSQL's XQuery methods (#1500)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2024-11-14 15:32:57 -05:00
wugeer
2bb81444bd
Add support for MYSQL's CREATE TABLE SELECT expr (#1515) 2024-11-13 12:36:13 -05:00
hulk
6d907d3adc
Add support of COMMENT ON syntax for Snowflake (#1516) 2024-11-13 08:23:33 -05:00
Yoav Cohen
76322baf2f
Add support for Snowflake SHOW DATABASES/SCHEMAS/TABLES/VIEWS/COLUMNS statements (#1501) 2024-11-13 06:55:26 -05:00
Ophir LOJKINE
3a8369aaf5
Parse true and false as identifiers in mssql (#1510) 2024-11-13 05:25:26 -05:00
wugeer
e857787309
hive: support for special not expression !a and raise error for a! factorial operator (#1472)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2024-11-13 01:36:33 -05:00
Ophir LOJKINE
d853c35391
improve support for T-SQL EXECUTE statements (#1490) 2024-11-07 10:59:14 -05:00
Yoav Cohen
a5b0092506
Add support for TOP before ALL/DISTINCT (#1495) 2024-11-06 12:09:55 -05:00
wugeer
05821cc7db
Add support for PostgreSQL LISTEN/NOTIFY syntax (#1485) 2024-11-06 16:51:08 +01:00
Andrew Lamb
a9a9d58c38
Fix typo in Dialect::supports_eq_alias_assigment (#1478) 2024-11-06 16:47:01 +01:00
Yoav Cohen
e2197eeca9
Add support for SHOW DATABASES/SCHEMAS/TABLES/VIEWS in Hive (#1487) 2024-11-03 08:07:06 -05:00
tomershaniii
8e0d26abb3
fix for maybe_parse preventing parser from erroring on recursion limit (#1464) 2024-10-21 15:41:34 -04:00
Yoav Cohen
45c5d69b22
MsSQL TRY_CONVERT (#1477) 2024-10-20 16:29:55 -04:00
Yoav Cohen
1dd7d26fbb
Add support for parsing MsSql alias with equals (#1467) 2024-10-20 14:12:39 -04:00
Ophir LOJKINE
7c20d4ae1f
Fix #1469 (SET ROLE regression) (#1474) 2024-10-14 13:14:40 -04:00
Hans Ott
749b061fbf
MySQL dialect: Add support for hash comments (#1466) 2024-10-11 11:15:18 -04:00
Yoav Cohen
a4fa9e08b7
Add support for quantified comparison predicates (ALL/ANY/SOME) (#1459) 2024-10-09 17:47:14 -04:00
David Caldwell
c01e054fd8
Add "DROP TYPE" support. (#1461) 2024-10-09 09:59:00 -04:00