Commit graph

1680 commits

Author SHA1 Message Date
Yoav Cohen
86abbd6028
Fix incorrect parsing of JsonAccess bracket notation after cast in Snowflake (#1708) 2025-02-06 18:14:03 +01:00
DanCodedThis
0b8ba91156
Add suppport for Show Objects statement for the Snowflake parser (#1702)
Co-authored-by: Denys Tsomenko <denys.tsomenko@caspiandb.com>
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2025-02-06 18:11:02 +01:00
Hans Ott
443f492b4b
Require space after -- to start single line comment in MySQL (#1705) 2025-02-05 20:47:17 +01:00
Yoav Cohen
751dc5afce
Parse Snowflake COPY INTO <location> (#1669) 2025-02-05 20:23:27 +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
Rémy SAISSY
257da5a82c
Add RETURNS TABLE() support for CREATE FUNCTION in Postgresql (#1687)
Co-authored-by: Ifeanyi Ubah <ify1992@yahoo.com>
2025-02-03 08:27:37 +01:00
Yoav Cohen
906f395341
Add support for GRANT on some common Snowflake objects (#1699) 2025-02-03 08:21:17 +01:00
Yoav Cohen
c3256a80d7
Do not parse ASOF and MATCH_CONDITION as table factor aliases (#1698) 2025-02-01 13:42:38 +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
Ifeanyi Ubah
9c384a9194
Fix CREATE FUNCTION round trip for Hive dialect (#1693) 2025-01-30 17:45:31 -05:00
Rémy SAISSY
a7e984099f
Fix DDL generation in case of an empty arguments function. (#1690) 2025-01-30 07:50:30 +01:00
Michael Victor Zink
252fdbab82
Allow plain JOIN without turning it into INNER (#1692) 2025-01-30 07:15:57 +01:00
Yoav Cohen
784605c913
Fix bug when parsing a Snowflake stage with ; suffix (#1688) 2025-01-29 17:50:36 +01:00
Ifeanyi Ubah
7980c866a3
BigQuery: Fix column identifier reserved keywords list (#1678) 2025-01-29 06:03:55 -05:00
Paul Grau
269967a6ac
Support underscore separators in numbers for Clickhouse. Fixes #1659 (#1677) 2025-01-28 14:26:08 +01: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
Yoav Cohen
cbe59a2d8b
Enable GROUP BY exp for Snowflake dialect (#1683) 2025-01-26 15:15:36 +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
Hans Ott
ef072be9e1
Only support escape literals for Postgres, Redshift and generic dialect (#1674) 2025-01-24 09:02:53 +01:00
Hans Ott
4f7154288e
National strings: check if dialect supports backslash escape (#1672) 2025-01-23 17:16:53 +01:00
Denys Tsomenko
c7c0de6551
Add support for Create Iceberg Table statement for Snowflake parser (#1664) 2025-01-20 21:39:44 +01:00
Yoav Cohen
183274e274
Add support for Snowflake account privileges (#1666) 2025-01-20 20:20:41 +01:00
Andrew Lamb
e5bc3dfad8
Update rat_exclude_file.txt (#1670) 2025-01-20 20:19:14 +01:00
Andrew Lamb
17d5610f09
Update verson to 0.54.0 and update changelog (#1668) 2025-01-20 11:32:12 -05:00
Yoav Cohen
5da702fc19
Add support for Snowflake AT/BEFORE (#1667) 2025-01-19 12:08:45 +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
Yoav Cohen
b4b5576dd4
Add support for Snowflake column aliases that use SQL keywords (#1632) 2025-01-16 17:50:30 +01:00
AvivDavid-Satori
474150006f
Add support for parsing RAISERROR (#1656) 2025-01-16 10:09:53 +01:00
Martin Abelson Sahlen
9105cae261
Allow empty options for BigQuery (#1657)
Co-authored-by: Martin Abelson Sahlen <sahlen@Mac.lan>
2025-01-16 09:27:26 +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
Hans Ott
c808c4e4fd
Correctly look for end delimiter dollar quoted string (#1650) 2025-01-12 21:34:09 +01:00
Yoav Cohen
3b4dc0f227
MsSQL SET for session params (#1646) 2025-01-11 10:51:01 +01:00
Simon Sawert
0c3b6c0974
Add support for ClickHouse FORMAT on INSERT (#1628) 2025-01-10 18:17:28 +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