1007 commits

Author	SHA1	Message	Date
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
Michael Victor Zink	1e54a34acd	Parse MySQL ALTER TABLE DROP FOREIGN KEY syntax (#1762)	2025-03-12 07:34:18 +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
Ophir LOJKINE	d5dbe86da9	re-add support for nested comments in mssql (#1754)	2025-03-01 07:13:33 +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
Michael Victor Zink	c2914f82e1	Parse ALTER TABLE AUTO_INCREMENT operation for MySQL (#1748)	2025-02-27 06:40:30 +01:00
Andrew Lamb	5b3500139a	Random test cleanups use Expr::value (#1749)	2025-02-27 06:33:08 +01:00
Michael Victor Zink	3adc746b11	Parse MySQL ALTER TABLE ALGORITHM option (#1745)	2025-02-26 07:03:38 +01:00
Michael Victor Zink	de4dbc5b1d	Parse SIGNED INTEGER type in MySQL CAST (#1739)	2025-02-26 07:00:08 +01:00
Michael	648efd7057	feat: adjust create and drop trigger for mysql dialect (#1734)	2025-02-25 07:50:29 +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
Artem Osipov	3ace97c0ef	Implement SnowFlake ALTER SESSION (#1712)	2025-02-21 07:22:24 +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
Jesse Stuart	c75a992621	Add support for Postgres ALTER TYPE (#1727)	2025-02-17 20:12:59 +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
Michael Victor Zink	cad49232c1	Parse Postgres VARBIT datatype (#1703)	2025-02-08 07:24:29 +01:00
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