Commit graph

584 commits

Author SHA1 Message Date
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
Alexander Beedie
5d66dc5dc9
Add support for JSONB datatype (#1089) 2024-01-15 05:46:09 -05:00
Toby Hede
1d63466ef8
Support for pg ADD GENERATED in ALTER COLUMN statements (#1079)
Signed-off-by: Toby Hede <toby@cipherstash.com>
2024-01-02 10:22:25 -05:00
Mehmet Emin KARAKAŞ
c62ecb1100
Support Mysql REPLACE statement and PRIORITY clause of INSERT (#1072) 2023-12-24 07:24:53 -05:00
Ophir LOJKINE
1933f194e7
add support for CALL statements (#1063) 2023-12-19 15:01:44 -05:00
Toby Hede
541d684fba
Adds support for PostgreSQL "END" (#1035)
Signed-off-by: Toby Hede <toby@cipherstash.com>
2023-11-21 15:21:35 -05:00
Drew Thomas
3d2773a794
Support INSERT INTO ... DEFAULT VALUES ... (#1036) 2023-11-21 15:21:26 -05:00
Drew Thomas
5bdf2e6608
Add support for release and rollback to savepoint syntax (#1045) 2023-11-20 19:51:48 -05:00
Ophir LOJKINE
953c833a4a
Support mssql json and xml extensions (#1043) 2023-11-18 07:03:12 -05:00
Ophir LOJKINE
ff8312bfd8
add support for MAX as a character length (#1038) 2023-11-10 15:57:56 -05:00
Lukasz Stefaniak
254ccfb4d8
snowflake: add support for LATERAL FLATTEN and similar (#1026) 2023-10-27 14:52:47 -04:00
Lukasz Stefaniak
8164b7c316
common: Make sure + - * / % binary operators work the same in all dialects (#1025) 2023-10-27 05:45:18 -04:00
Ifeanyi Ubah
2f437db2a6
Support for BigQuery struct, array and bytes , int64, float64 datatypes (#1003) 2023-10-25 12:57:33 -04:00
yuval-illumex
b89edaa98b
Support IGNORE|RESPECT NULLs clause in window functions (#998)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2023-10-24 09:45:59 -04:00
Ophir LOJKINE
ce62fe6d27
Support FILTER in over clause (#1007)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2023-10-23 18:06:39 -04:00
Lukasz Stefaniak
88510f6625
fix column COLLATE not displayed (#1012) 2023-10-20 15:49:18 -04:00
Lukasz Stefaniak
c68e9775a2
Support bigquery CAST AS x [STRING|DATE] FORMAT syntax (#978) 2023-10-20 14:33:12 -04:00
Zdenko Nevrala
83cb734b3c
Support Snowflake/BigQuery TRIM. (#975) 2023-10-06 14:48:18 -04:00
Gabriel Villalonga Simon
5263da68cd
Handle CREATE [TEMPORARY|TEMP] VIEW [IF NOT EXISTS] (#993) 2023-10-05 15:32:43 -04:00
Lukasz Stefaniak
c811e22605
redshift: add support for CREATE VIEW … WITH NO SCHEMA BINDING (#979) 2023-10-02 13:42:01 -04:00
Joey Hain
40e2ecbdf3
snowflake: support for UNPIVOT and a fix for chained PIVOTs (#983) 2023-10-02 13:28:13 -04:00
Lukasz Stefaniak
2786c7eaf1
clickhouse: add support for LIMIT BY (#977) 2023-10-02 11:53:32 -04:00
Ulrich Schmidt-Goertz
6ffc3b3a52
Support DELETE with ORDER BY and LIMIT (MySQL) (#992) 2023-10-02 08:42:58 -04:00
Lukasz Stefaniak
4903bd4b8b
Add test for clickhouse: tokenize == as Token::DoubleEq (#981) 2023-10-02 07:39:44 -04:00
Lukasz Stefaniak
e718ce6c42
bigquery: EXTRACT support For DAYOFWEEK, DAYOFYEAR, ISOWEEK, TIME (#980) 2023-10-02 07:23:25 -04:00
chunshao.rcs
f6e4be4c15
Support mysql partition to table selection (#959)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2023-09-14 14:21:47 -04:00
Berkay Şahin
bb7b05e106
feat: Group By All (#964)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2023-09-08 06:47:56 -04:00
Forbes Lindesay
25e037c50f
feat: allow multiple actions in one ALTER TABLE statement (#960) 2023-09-07 16:39:47 -04:00
SeanTroyUWO
e0afd4b179
ANY and ALL contains their operators (#963) 2023-09-07 16:32:50 -04:00
dawg
b02c3f87ec
feat: show location info in parse errors (#958) 2023-09-07 16:23:09 -04:00
Andrew Lamb
14da37d182
Fix Rust 1.72 clippy lints (#957) 2023-08-25 12:21:31 -04:00
Marko Grujic
1ea8858575
Table time travel clause support, add visit_table_factor to Visitor (#951) 2023-08-22 06:06:32 -04:00
Forbes Lindesay
9a39afbe07
feat: support more Postgres index syntax (#943) 2023-08-17 11:47:11 -04:00
Jeremy Maness
8bbb85356c
Fix SUBSTRING from/to argument construction for mssql (#947) 2023-08-17 06:17:57 -04:00
liadgiladi
eb4be98980
Support DROP TEMPORARY TABLE, MySQL syntax (#916) 2023-08-07 10:54:24 -04:00
Ophir LOJKINE
10a6ec5637
Fix "BEGIN TRANSACTION" being serialized as "START TRANSACTION" (#935) 2023-07-27 07:32:55 -04:00
Ophir LOJKINE
53593f1982
Fix parsing of datetime functions without parenthesis (#930) 2023-07-26 15:47:02 -04:00
Andrew Lamb
3a412152b9
fix parsing of identifiers after % symbol (#927) 2023-07-21 05:55:41 -04:00
canalun
f98a2f9dca
feat: mysql no-escape mode (#870)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2023-07-19 16:36:52 -04:00
Igor Izvekov
df45db1375
fix: parsing JsonOperator (#913) 2023-07-17 15:03:48 -04:00
Andrew Lamb
4efe55dd8a
Remove most instances of #[cfg(feature(bigdecimal))] in tests (#910) 2023-07-17 14:19:51 -04:00
Jay Zhan
20ac38b4da
Support multi args for unnest (#909)
Signed-off-by: jayzhan211 <jayzhan211@gmail.com>
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2023-06-30 16:50:46 -04:00
liadgiladi
f05f71e20d
Support ALTER VIEW, MySQL syntax (#907)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2023-06-29 13:33:51 -04:00
Igor Izvekov
8877cbafa6
fix: unary negation operator with operators: Mul, Div and Mod (#902) 2023-06-22 11:15:31 -04:00
Sam Rijs
2b37e4ae6e
Add support for CREATE TYPE (AS) statements (#888)
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
2023-06-08 06:56:39 -04:00
Andrew Lamb
f740d528da
Fix merge conflict (#885) 2023-05-18 15:28:11 -04:00
Berkay Şahin
ef46cd3752
Named window frames (#881)
* after over clause, named window can be parsed with window ... as after having clause

* Lint errors are fixed

* Support for multiple windows

* fix lint errors

* simplifications

* rename function

* Rewrite named window search in functional style

* Test added and some minor changes

* Minor changes on tests and namings, and semantic check is removed

---------

Co-authored-by: Mustafa Akur <mustafa.akur@synnada.ai>
Co-authored-by: Mehmet Ozan Kabak <ozankabak@gmail.com>
2023-05-18 15:00:24 -04:00
Mustafa Akur
1b86abebe2
Add support for first, last aggregate function parsing (#882)
* Add order by parsing to functions

* Fix doc error

* minor changes
2023-05-18 14:59:14 -04:00