Commit graph

581 commits

Author SHA1 Message Date
Simon Sawert
029a999645
Add support for view comments for Snowflake (#1287)
Co-authored-by: Joey Hain <joey@sigmacomputing.com>
2024-05-30 12:21:39 -04:00
Joey Hain
c2d84f5683
Support for Snowflake dynamic pivot (#1280) 2024-05-30 12:20:16 -04:00
Joey Hain
d5faf3c54b
Support expression in AT TIME ZONE and fix precedence (#1272) 2024-05-23 13:30:05 -04:00
Joey Hain
5ed13b5af3
Databricks: support SELECT * EXCEPT (#1261) 2024-05-13 05:49:00 -04:00
Dmitry Bugakov
49d178477e
Fix DoubleColon cast skipping AT TIME ZONE #1266 (#1267) 2024-05-11 15:26:57 -04:00
Ifeanyi Ubah
eb36bd7138
Support multiple SET variables (#1252) 2024-05-07 12:51:39 -04:00
Joey Hain
d9d69a2192
Databricks: support for lambda functions (#1257) 2024-05-06 13:37:48 -04:00
Hiranmaya Gundu
2555f713c3
fix: allow snowflake to accept values without parens (#1249) 2024-05-03 16:05:16 -04:00
Joey Hain
a14faa36bb
Consolidate representation of function calls, remove AggregateExpressionWithFilter, ArraySubquery, ListAgg and ArrayAgg (#1247)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2024-05-03 14:46:03 -04:00
Andrew Lamb
8e64b73e9d
Accept WINDOW clause after QUALIFY when parsing (#1248)
Co-authored-by: ifeanyi <ifeanyi@validio.io>
2024-05-03 14:02:09 -04:00
Andrew Repp
4aa37a46a9
Support ?-based jsonb operators in Postgres (#1242)
Co-authored-by: Andrew Repp <arepp@cloudflare.com>
2024-05-01 06:50:45 -04:00
Ifeanyi Ubah
fb20f8ccbe
Support BigQuery window function null treatment (#1239) 2024-04-30 16:44:13 -04:00
Ifeanyi Ubah
8626051513
Extend pivot operator support (#1238) 2024-04-30 14:13:26 -04:00
Joey Hain
4bfa399919
Improve parsing of JSON accesses on Postgres and Snowflake (#1215)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2024-04-30 10:49:05 -04:00
Ifeanyi Ubah
6fcf8c9abe
BigQuery: Support window clause using named window (#1237) 2024-04-30 09:41:24 -04:00
Joey Hain
0b5722afbf
Support for CONNECT BY (#1138) 2024-04-27 06:52:21 -04:00
Joey Hain
deaa6d8151
Snowflake: support for object constants (#1223) 2024-04-26 14:01:33 -04:00
Joey Hain
2490034948
Initial Databricks SQL dialect (#1220) 2024-04-26 14:01:09 -04:00
Ifeanyi Ubah
0adf4c675c
Support BigQuery MERGE syntax (#1217) 2024-04-26 14:00:54 -04:00
Simon Sawert
b51f2a0c25
fix: Add support for MAX for NVARCHAR (#1232) 2024-04-26 13:56:37 -04:00
Yuval Shkolar
547c5cde14
fix redundant brackets in Hive/Snowflake/Redshift (#1229) 2024-04-24 07:56:09 -04:00
universalmind303
ce85084deb
feat: add fixed size list support (#1231) 2024-04-23 17:53:03 -04:00
Joey Hain
39980e8976
Support Snowflake MATCH_RECOGNIZE syntax (#1222) 2024-04-22 16:17:50 -04:00
tison
bf89b7d808
Encapsulate Insert and Delete into specific structs (#1224)
Signed-off-by: tison <wander4096@gmail.com>
2024-04-21 09:13:18 -04:00
Ifeanyi Ubah
d2c2b15f9e
Add support for quoted string backslash escaping (#1177) 2024-04-21 09:07:56 -04:00
Hiranmaya Gundu
4604628c43
feat: implement select * ilike for snowflake (#1228) 2024-04-21 08:22:08 -04:00
Joey Hain
d1f67bdc47
Preserve double colon casts (and simplify cast representations) (#1221) 2024-04-21 08:21:58 -04:00
Hiranmaya Gundu
9db20e293f
fix: have wildcard replace work in duckdb and snowflake syntax (#1226) 2024-04-21 08:20:41 -04:00
Ifeanyi Ubah
eda86d8ed7
Add support for arbitrary map access expr (#1179) 2024-04-09 17:21:22 -04:00
Ifeanyi Ubah
127be97369
Support more DateTimeField variants (#1191) 2024-04-09 17:16:03 -04:00
xring
20c5754784
Support [FIRST | AFTER column_name] support in ALTER TABLE for MySQL (#1180) 2024-04-07 08:43:23 -04:00
Ifeanyi Ubah
732e1ec1fc
BigQuery support inline comment with hash syntax (#1192) 2024-04-07 08:31:04 -04:00
Nikita-str
23103302e6
Support named windows in OVER (window_definition) clause (#1166)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2024-04-07 08:20:21 -04:00
Joey Hain
3bf40485c5
Fix parsing of equality binop in function argument (#1182) 2024-04-06 13:08:40 -04:00
Ophir LOJKINE
6b03a259aa
Parse SUBSTRING FROM syntax in all dialects, reflect change in the AST (#1173) 2024-03-13 11:08:27 -04:00
Jonathan Lehto
ef4668075b
Support EXPLAIN / DESCR / DESCRIBE [FORMATTED | EXTENDED] (#1156)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2024-03-01 14:07:04 -05:00
Jonathan Lehto
a511c47bd0
set_tblproperties (#1151) 2024-03-01 13:42:21 -05:00
Jonathan Lehto
e2ce324722
Support Unload statement (#1150)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2024-02-29 14:55:46 -05:00
Andrew Repp
0c5f6fbf81
ISSUE-1147: Add support for MATERIALIZED CTEs (#1148)
Co-authored-by: Andrew Repp <arepp@cloudflare.com>
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2024-02-29 07:54:36 -05:00
Lukasz Stefaniak
1cf6585649
SupportSELECT AS VALUE and SELECT AS STRUCT for BigQuery (#1135) 2024-02-29 07:14:00 -05:00
Ophir LOJKINE
d59b6638fa
add support for insert into ... select ... returning ... (#1132) 2024-02-12 16:44:22 -05:00
universalmind303
d981b0996a
feat: support = operator in function args (#1128)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2024-02-08 20:24:42 -05:00
Greg Gaughan
8fae601743
Add support for UPDATE FROM for SQLite (further to #694) (#1117) 2024-02-04 08:58:51 -05:00
Ifeanyi Ubah
df738f9b10
BigQuery: Parse optional DELETE FROM statement (#1120) 2024-02-04 08:57:33 -05:00
Daniel Imfeld
c86508bae5
Add support for constraint characteristics clause (#1099) 2024-01-24 14:26:19 -05:00
Andrew Repp
70764a17e9
ISSUE-1088: Fix array_agg wildcard behavior (#1093)
Co-authored-by: Andrew Repp <arepp@cloudflare.com>
2024-01-24 07:42:39 -05:00
Joey Hain
398a81029e
Support for unquoted hyphenated identifiers on bigquery (#1109) 2024-01-23 20:04:22 -05:00
Ifeanyi Ubah
3a6d3ecba2
Add support for BigQuery table and view options (#1061) 2024-01-23 17:21:53 -05:00
0rphon
d72f0a966b
Add APIs to reuse token buffers in Tokenizer (#1094) 2024-01-22 14:46:36 -05:00
Alexander Beedie
3ec337ec5f
Add "timezone_region" and "timezone_abbr" support for EXTRACT (and DATE_PART) (#1090) 2024-01-16 08:46:10 -05:00