Commit graph

1007 commits

Author SHA1 Message Date
Martin Abelson Sahlen
7bc6ddb8fb
Add support for BigQuery ANY TYPE data type (#1602)
Co-authored-by: Martin Abelson Sahlen <sahlen@Martins-MacBook-Air.local>
Co-authored-by: Martin Abelson Sahlen <sahlen@Mac.lan>
2024-12-15 10:39:42 +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
Yuval Shkolar
00abaf2187
Support INSERT OVERWRITE INTO syntax (#1584) 2024-12-09 15:25:10 -05:00
Yoav Cohen
d0fcc06652
Snowflake ALTER TABLE clustering options (#1579) 2024-12-06 10:41:01 +01: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
6517da6b7d
Support parsing optional nulls handling for unique constraint (#1567) 2024-12-03 20:09:00 -05:00
Michael Victor Zink
6d4188de53
Support BIT column types (#1577) 2024-12-03 19:47:12 -05:00
Philip Cristiano
e16b24679a
Encapsulate CreateFunction (#1573) 2024-12-02 12:45:14 -05:00
Ayman Elkfrawy
bd750dfada
Support Databricks struct literal (#1542) 2024-12-02 10:23:48 -05:00
Ayman Elkfrawy
f4f112d7d6
Support snowflake double dot notation for object name (#1540) 2024-11-30 08:02:08 -05:00
Ophir LOJKINE
96f7c0277a
json_object('k' VALUE 'v') in postgres (#1547)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2024-11-30 08:01:13 -05:00
Michael Victor Zink
48b0e4db4e
Support MySQL size variants for BLOB and TEXT columns (#1564) 2024-11-30 07:55:54 -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
tomershaniii
10519003ed
recursive select calls are parsed with bad trailing_commas parameter (#1521) 2024-11-23 06:33:14 -05:00
Michael Victor Zink
fad2ddd641
Parse byte/bit string literals in MySQL and Postgres (#1532) 2024-11-20 06:55:38 +01: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
wugeer
632ba4cf8e
Fix the parsing error in MSSQL for multiple statements that include DECLARE statements (#1497) 2024-11-13 06:54:57 -05:00
Ophir LOJKINE
3a8369aaf5
Parse true and false as identifiers in mssql (#1510) 2024-11-13 05:25:26 -05:00
gaoqiangz
90824486df
Add support for MSSQL's OPENJSON WITH clause (#1498) 2024-11-13 01:41:13 -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
Andrew Lamb
9394ad4c0c
Add Apache License to additional files (#1502) 2024-11-06 16:48:49 -05:00
Ophir LOJKINE
fc0e13b80e
add support for FOR ORDINALITY and NESTED in JSON_TABLE (#1493) 2024-11-06 16:04:13 -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
David Caldwell
a8432b57db
Add PostgreSQL specfic "CREATE TYPE t AS ENUM (...)" support. (#1460) 2024-10-21 14:44:38 -04:00
Yoav Cohen
45c5d69b22
MsSQL TRY_CONVERT (#1477) 2024-10-20 16:29:55 -04:00
Aleksei Piianin
3421e1e4d4
Snowflake: support for extended column options in CREATE TABLE (#1454) 2024-10-20 14:13:25 -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