Commit graph

1040 commits

Author SHA1 Message Date
hulk
1c505ce736
Allow to use ON CLUSTER cluster_name in TRUNCATE syntax (#1428) 2024-09-19 06:56:00 -04:00
Agaev Guseyn
246838a69f
Fix parsing of negative values (#1419)
Co-authored-by: Agaev Huseyn <h.agaev@vkteam.ru>
2024-09-16 17:04:21 -04:00
Simon Sawert
b9e7754886
feat: Add support for MSSQL table options (#1414) 2024-09-11 13:09:41 -04:00
Andrew Lamb
cb0c511b05
Add a test showing how negative constants are parsed (#1421) 2024-09-10 16:19:13 -04:00
hulk
6ba6068944
Fix Hive table comment should be after table column definitions (#1413) 2024-09-10 15:43:35 -04:00
hulk
a7b49b5072
Add support of DROP|CLEAR|MATERIALIZE PROJECTION syntax for ClickHouse (#1417) 2024-09-10 15:26:07 -04:00
Emil Ejbyfeldt
4875dadbf5
fix: Fix stack overflow in parse_subexpr (#1410) 2024-09-06 10:17:20 -04:00
Samuel Colvin
aa714e3447
Fix INTERVAL parsing to support expressions and units via dialect (#1398) 2024-09-06 10:16:09 -04:00
Toby Hede
1bed87a8ea
Suppor postgres TRUNCATE syntax (#1406) 2024-09-05 11:13:35 -04:00
张林伟
4d52ee7280
Support create index with clause (#1389)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2024-09-01 07:38:20 -04:00
hulk
df86f259ce
Fix identifier starts with $ should be regarded as a placeholder in SQLite (#1402) 2024-09-01 07:21:59 -04:00
hulk
7b4ac7ca9f
Add support of parsing CLUSTERED BY clause for Hive (#1397) 2024-09-01 07:21:26 -04:00
Samuel Colvin
222b7d127a
allow DateTimeField::Custom with EXTRACT in Postgres (#1394) 2024-08-26 15:56:57 -04:00
Kacper Muda
7282ce22f9
feat: support different USE statement syntaxes (#1387) 2024-08-23 11:42:51 -04:00
hulk
19e694aa91
Support ADD PROJECTION syntax for ClickHouse (#1390) 2024-08-22 12:33:44 -04:00
Andrew Lamb
dd78084ca0
fix: only require DESCRIBE TABLE for Snowflake and ClickHouse dialect (#1386) 2024-08-16 05:54:58 -04:00
Jay Zhan
8c4d30bb6d
Support DuckDB struct syntax and support list of struct syntax (#1372)
Signed-off-by: jayzhan211 <jayzhan211@gmail.com>
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2024-08-15 09:02:42 -04:00
hulk
6a11a67fcd
Add support of FREEZE|UNFREEZE PARTITION syntax for ClickHouse (#1380) 2024-08-14 11:29:27 -04:00
Seve Martinez
c2f46ae07b
adding support for scale in CEIL and FLOOR functions (#1377) 2024-08-14 09:11:40 -04:00
Luca Cappelletti
b072ce2589
Adding support for parsing CREATE TRIGGER and DROP TRIGGER statements (#1352)
Co-authored-by: hulk <hulk.website@gmail.com>
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2024-08-14 09:11:16 -04:00
Seve Martinez
f5b818e74b
supporting snowflake extract syntax (#1374)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2024-08-13 08:56:18 -04:00
Andrew Lamb
1e209d8741
Simplify arrow_cast tests (#1367) 2024-08-08 16:58:31 -04:00
hulk
dfb8b81630
Add support of ATTACH/DETACH PARTITION for ClickHouse (#1362) 2024-08-07 14:02:11 -04:00
Samuel Colvin
a5480ae498
Support Dialect level precedence, update Postgres Dialect to match Postgres (#1360) 2024-08-06 07:49:37 -04:00
Jax Liu
8f8c96f87f
Support parsing empty map literal syntax for DuckDB and Genric (#1361) 2024-08-04 07:47:32 -04:00
Jesse
d49acc67b1
Parse SETTINGS clause for ClickHouse table-valued functions (#1358) 2024-08-01 17:28:15 -04:00
hulk
a692ba5fd1
Add support of parsing OPTIMIZE TABLE statement for ClickHouse (#1359) 2024-08-01 17:20:56 -04:00
hulk
cc13841a37
Add support of parsing ON CLUSTER in ALTER TABLE for ClickHouse (#1342) 2024-07-30 16:31:42 -04:00
hulk
f96658006f
Allow to use the GLOBAL keyword before the join operator (#1353) 2024-07-30 16:30:46 -04:00
Ophir LOJKINE
bc15f7b4ce
Support for postgres String Constants with Unicode Escapes (#1355) 2024-07-29 17:18:16 -04:00
Joey Hain
c3ba2f33c6
Snowflake: support position with normal function call syntax (#1341)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2024-07-29 17:17:11 -04:00
hulk
7fdb2ec5d1
Allow to use the TABLE keyword in DESC|DESCRIBE|EXPLAIN TABLE statement (#1351) 2024-07-29 17:16:29 -04:00
hulk
390d4d3554
Add support of MATERIALIZED/ALIAS/EPHERMERAL default column options for ClickHouse (#1348) 2024-07-23 12:41:07 -04:00
hulk
b27abf00e2
Allow to use () as the GROUP BY nothing (#1347) 2024-07-22 15:50:24 -04:00
Jax Liu
48ea5640a2
Support Map literal syntax for DuckDB and Generic (#1344) 2024-07-21 08:18:50 -04:00
Alexander Beedie
71dc966586
Fix quoted identifier regression edge-case with "from" in SELECT (#1346) 2024-07-21 06:02:12 -04:00
Ifeanyi Ubah
028ada8350
Support subquery expression in SET expressions (#1343) 2024-07-20 06:55:24 -04:00
Nick Presta
845a1aaddd
[ClickHouse] Add support for WITH FILL to OrderByExpr (#1330)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2024-07-20 06:51:12 -04:00
hulk
20f7ac59e3
Fix AS query clause should be after the create table options (#1339) 2024-07-15 13:54:44 -04:00
hulk
993216f3ac
Enable PARTITION BY feature for PostgreSQL while parsing the create table statement (#1338) 2024-07-13 05:46:26 -04:00
hulk
9108bffc9a
Add support of table function WITH ORDINALITY modifier for Postgre Parser (#1337) 2024-07-09 17:43:22 -04:00
gai takano
32b8276b32
Postgres: support for OWNER TO clause (#1314)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2024-07-09 07:49:48 -04:00
hulk
07278952f9
Add support of FORMAT clause for ClickHouse parser (#1335) 2024-07-09 07:49:04 -04:00
Lorrens Pantelis
9f60eb1571
Support DROP PROCEDURE statement (#1324)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2024-07-09 07:46:49 -04:00
Andrew Lamb
17e5c0c1b6
Fix CI error message in CI (#1333) 2024-07-08 07:37:00 -04:00
Mohamed Abdeen
f77192d4ec
Re-enable trailing commas in DCL (#1318) 2024-07-08 06:31:33 -04:00
hulk
0884dd920d
Support PREWHERE condition for ClickHouse dialect (#1328) 2024-07-07 08:03:23 -04:00
hulk
700bd03d6f
Support SETTINGS pairs for ClickHouse dialect (#1327)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2024-07-07 07:17:43 -04:00
hulk
44d7a20f64
Support GROUP BY WITH MODIFIER for ClickHouse (#1323)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2024-06-30 07:33:43 -04:00
gstvg
f9ab8dcc27
Support for DuckDB Union datatype (#1322) 2024-06-27 07:58:11 -04:00