Commit graph

581 commits

Author SHA1 Message Date
Ifeanyi Ubah
e3e88290cd
Add support for RAISE statement (#1766) 2025-03-18 15:19:51 +01:00
Ifeanyi Ubah
f81aed6359
BigQuery: Add support for CREATE SCHEMA options (#1742) 2025-03-14 08:00:19 +01:00
Ifeanyi Ubah
862e887a66
Add CASE and IF statement support (#1741) 2025-03-14 07:49:25 +01:00
Ifeanyi Ubah
cf4ab7f9ab
Add support for DROP MATERIALIZED VIEW (#1743) 2025-03-13 15:51:29 -04:00
Michael Victor Zink
fb578bb419
Preserve MySQL-style LIMIT <offset>, <limit> syntax (#1765) 2025-03-12 21:24:06 +01:00
Mohamed Abdeen
85f855150f
SET with a list of comma separated assignments (#1757) 2025-03-12 21:02:39 +01:00
Ophir LOJKINE
3392623b00
add support for with clauses (CTEs) in delete statements (#1764) 2025-03-12 11:42:51 +01:00
Luca Cappelletti
6ec5223f50
Extend support for INDEX parsing (#1707)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2025-03-04 06:59:39 +01:00
Michael Victor Zink
9e09b617e8
Parse SET NAMES syntax in Postgres (#1752) 2025-03-01 07:12:25 +01:00
Michael Victor Zink
a629ddf89b
Ignore escaped LIKE wildcards in MySQL (#1735) 2025-03-01 07:07:39 +01:00
Ophir LOJKINE
c335c8883b
Store spans for Value expressions (#1738) 2025-02-25 07:33:57 +01:00
Ifeanyi Ubah
aab12add36
BigQuery: Add support for BEGIN (#1718) 2025-02-24 08:34:36 +01:00
Ophir LOJKINE
72312ba82a
Replace parallel condition/result vectors with single CaseWhen vector in Expr::Case (#1733) 2025-02-22 07:23:36 +01:00
Yoav Cohen
7fc37a76e5
Parse casting to array using double colon operator in Redshift (#1737) 2025-02-22 07:21:45 +01:00
SiLe Zhou
1f1c0693da
Add support for ORDER BY ALL (#1724) 2025-02-22 06:52:07 +01:00
benrsatori
339239d0c5
Add support for PostgreSQL/Redshift geometric operators (#1723) 2025-02-20 19:50:32 +01:00
Michael Victor Zink
97f0be6991
Treat COLLATE like any other column option (#1731) 2025-02-20 06:26:20 +01:00
Ifeanyi Ubah
b482562618
Add support for EXECUTE IMMEDIATE (#1717) 2025-02-19 18:54:14 +01:00
Ifeanyi Ubah
3e90a18f6d
Replace Method and CompositeAccess with CompoundFieldAccess (#1716) 2025-02-19 18:49:42 +01:00
Michael Victor Zink
68c41a9d5a
Differentiate LEFT JOIN from LEFT OUTER JOIN (#1726) 2025-02-14 17:23:00 +01:00
wugeer
1c0e5d3554
Add supports for Hive's SELECT ... GROUP BY .. GROUPING SETS syntax (#1653)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2025-02-14 17:16:10 +01:00
Tyler Brinks
a5bbb5e8ac
Add support for MS Varbinary(MAX) (#1714) (#1715) 2025-02-13 05:40:35 -05:00
Armin Ronacher
46cfcfe8f7
Implement FROM-first selects (#1713) 2025-02-09 06:10:58 +01:00
wugeer
486b29ffab
Add support for CREATE/ALTER/DROP CONNECTOR syntax (#1701) 2025-02-04 18:33:12 +01:00
Yoav Cohen
ec948eaf6e
Add parsing for GRANT ROLE and GRANT DATABASE ROLE in Snowflake dialect (#1689) 2025-02-03 20:17:47 +01:00
Yoav Cohen
906f395341
Add support for GRANT on some common Snowflake objects (#1699) 2025-02-03 08:21:17 +01:00
Paul Grau
447142c6d0
Make TypedString preserve quote style (#1679) 2025-01-31 07:04:41 +01:00
gstvg
aeaafbe6e4
Extend lambda support for ClickHouse and DuckDB dialects (#1686) 2025-01-31 06:59:16 +01:00
Ifeanyi Ubah
94b2ff7191
Make numeric literal underscore test dialect agnostic (#1685) 2025-01-30 18:05:36 -05:00
Michael Victor Zink
252fdbab82
Allow plain JOIN without turning it into INNER (#1692) 2025-01-30 07:15:57 +01:00
Ifeanyi Ubah
7980c866a3
BigQuery: Fix column identifier reserved keywords list (#1678) 2025-01-29 06:03:55 -05:00
Ifeanyi Ubah
8de3a62948
BigQuery: Add support for select expr star (#1680) 2025-01-28 11:33:07 +01:00
AvivDavid-Satori
f7b0812b01
Add support for mysql table hints (#1675) 2025-01-28 09:41:03 +01:00
Ifeanyi Ubah
fdbe864d0d
Support multiple tables in UPDATE FROM clause (#1681) 2025-01-28 08:45:14 +01:00
Yoav Cohen
74163b148e
Add support for parsing empty dictionary expressions (#1684) 2025-01-26 15:20:00 +01:00
Ayman Elkfrawy
211b15e790
Enhance object name path segments (#1539) 2025-01-26 15:13:51 +01:00
Ifeanyi Ubah
fd6c98e933
BigQuery: Support trailing commas in column definitions list (#1682) 2025-01-25 10:01:33 -05:00
Yoav Cohen
183274e274
Add support for Snowflake account privileges (#1666) 2025-01-20 20:20:41 +01:00
Yoav Cohen
44df6d6f92
Add support for qualified column names in JOIN ... USING (#1663) 2025-01-19 11:43:45 +01:00
Alexander Beedie
e9498d538a
Add support for IS [NOT] [form] NORMALIZED (#1655)
Co-authored-by: Alexander Beedie <alexander.beedie@adia.ae>
2025-01-17 10:59:47 +01:00
Ophir LOJKINE
3eeb9160ea
fix parsing of INSERT INTO ... SELECT ... RETURNING (#1661) 2025-01-17 08:13:12 +01:00
bar sela
36db176657
Support trailing commas in FROM clause (#1645)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2025-01-14 09:38:24 -05:00
wugeer
6507484697
Support single line comments starting with '#' for Hive (#1654) 2025-01-13 17:57:11 +01:00
cjw
b09514e492
feat: support INSERT INTO [TABLE] FUNCTION of Clickhouse (#1633)
Co-authored-by: Kermit <chenjiawei1@xiaohongshu.com>
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2025-01-10 15:23:56 +01:00
Stepan Koltsov
c54ba4dc41
ALTER TABLE DROP {COLUMN|CONSTRAINT} RESTRICT (#1651) 2025-01-10 01:29:34 +01:00
Yoav Cohen
5a761dd6db
Add support for the Snowflake MINUS set operator (#1652) 2025-01-10 00:52:09 +01:00
Michael Victor Zink
4fdf5e1b30
Fix MySQL parsing of GRANT, REVOKE, and CREATE VIEW (#1538) 2025-01-10 00:31:06 +01:00
Yoav Cohen
687ce2d5f4
Add support for MS-SQL BEGIN/END TRY/CATCH (#1649) 2025-01-08 19:31:24 +01:00
Stepan Koltsov
397bceb241
Replace ReferentialAction enum in DROP statements (#1648) 2025-01-08 19:27:25 +01:00
wugeer
62bcaa1c98
Support pluralized time units (#1630) 2025-01-08 18:28:20 +01:00