6334 Commits

Author SHA1 Message Date
Fran Lozano
fa2f63b348 Databricks: Adds support for ALTER TABLE ADD COLUMN (#7187) 2025-10-18 13:20:17 +00:00
Annebelle Olminkhof
52f74979c1 BigQuery: allow multiple aliases in FROM for RF01 (#7188)
Co-authored-by: Annebelle Olminkhof <20630578+annebelleo@users.noreply.github.com>
2025-10-18 13:19:24 +00:00
VictorAtIfInsurance
5edc73c2fc [DATABRICKS] add 'UNSET/SET TAG ON' grammar sequence (#7190) 2025-10-18 13:15:40 +00:00
Fran Lozano
e71e6fc6f8 Redshift: Adds EXCEPT set operator support (#7184) 2025-10-13 21:33:26 +00:00
Annebelle Olminkhof
a89a716948 BigQuery: allow pipe syntax in CTEs (#7180)
Co-authored-by: Annebelle Olminkhof <20630578+annebelleo@users.noreply.github.com>
2025-10-13 12:31:23 +00:00
Cameron
aa302b0a34 MySQL/MariaDB: Support column list in derived table alias (#7179) 2025-10-13 09:21:30 +00:00
Alan Cruickshank
6147525ab3 Logo Updates (#7181) 2025-10-12 22:29:46 +00:00
Joir-dan Gumbs
71c7200144 Add support for FlinkSQL SET statements (#7175)
Co-authored-by: greptile-apps[bot] <165735046+greptile-apps[bot]@users.noreply.github.com>
2025-10-10 22:44:25 +00:00
Annebelle Olminkhof
505390870a Correct comment name in BigQuery test (#7174)
Co-authored-by: Annebelle Olminkhof <20630578+annebelleo@users.noreply.github.com>
2025-10-10 22:36:29 +00:00
Cameron
7b6beffacd Snowflake: add ALTER DYNAMIC TABLE support (#7176) 2025-10-10 22:32:07 +00:00
Cameron
9ca671d3f2 AL09: fix aliases without spaces after column name (#7173) 2025-10-10 22:30:02 +00:00
Joshua Jorenby
c303f53ca2 LT01: Fix alias alignment with templates (#7088)
Co-authored-by: Claude <noreply@anthropic.com>
2025-10-10 04:53:09 +00:00
Fran Lozano
44edd0cee8 Athena: Adds Athena-specific ALTER TABLE statement (#7170) 2025-10-10 04:35:01 +00:00
Cameron
7402e56571 bigquery: fix escape_replacements control character value (#7165) 2025-10-09 11:33:11 +00:00
Cameron
e849a602c1 TSQL: Support Computed Columns in Table Variables (#7167) 2025-10-09 11:32:38 +00:00
Cameron
eec772c25b cli: support .sqlfluffignore when using stdin-filename (#7168) 2025-10-09 11:29:53 +00:00
G Karthik Koundinya
47155a8c3d Add support for PostgreSQL OPERATOR() syntax (#7163)
Co-authored-by: keraion <keraion@users.noreply.github.com>
2025-10-08 11:32:47 +00:00
Vasiliy Kiryanov
099fb2ca19 SET LANGUAGE statement segment added to tsql dialect. (#7161) 2025-10-07 00:49:39 +00:00
Dave Bunten
97d050ecfb Add new check for ambiguousLIMIT or OFFSET without ORDER BY (non-deterministic results) (#6749)
Co-authored-by: Danny Jones <51742311+WittierDinosaur@users.noreply.github.com>
2025-10-06 15:48:47 +00:00
Peter Budai
84f5ea171f TSQL: Refactor cursor statements (#7130)
Co-authored-by: Danny Jones <51742311+WittierDinosaur@users.noreply.github.com>
2025-10-05 21:02:02 +00:00
Axell
b6d321aeb1 TSQL: Allow consecutive semicolons & add rule ST12 (warn and fix) (#7094) 2025-10-05 20:45:08 +00:00
Levi Nelson
d35ff2dda9 fix: #7157 (#7158) 2025-10-03 17:04:55 +00:00
Fran Lozano
3ea458a893 MariaDB: Adds OR REPLACE clause support for CREATE PROCEDURE and CREATE FUNCTION (#7148) 2025-10-01 03:54:15 +00:00
Matthias Beyer
114b2fa35b Fix typo (#7151) 2025-09-29 22:13:22 +00:00
Cameron
2bb18bdf69 postgres: Add DROP COLLATION statement (#7143)
Co-authored-by: greptile-apps[bot] <165735046+greptile-apps[bot]@users.noreply.github.com>
2025-09-25 09:30:00 +00:00
Cameron
604af292f2 oracle: Support COLUMN_VALUE as a bare function (#7144) 2025-09-25 09:29:34 +00:00
Enterprize1
eb6cbaab5d MySQL: Allow if not exists in create procedure (#7133) 2025-09-24 19:47:39 +00:00
Cameron
0038d4331d oracle: Add support for utf8 identifiers (#7145) 2025-09-24 19:28:26 +00:00
Cameron
fb838bd9eb CV11: Ignore trino and athena dialects (#7146) 2025-09-24 19:27:49 +00:00
Enrique Perez Delgado
8c65a2033f fix[sparksql]: Add support for INSERT INTO REPLACE WHERE/USING statements (#7147) 2025-09-24 19:27:14 +00:00
stephen-zabel-q2
44d8c4bda9 Per Issue 5567 update _common_directives_for_xml to AnyNumberOf (they… (#7139) 2025-09-24 01:57:17 +00:00
VictorAtIfInsurance
73427eb5bb extend databricks COMMENT ON to include columns (#7140) 2025-09-24 01:46:32 +00:00
Danny Jones
f1ccddd45b Streamline release commands (#7005) 2025-09-20 21:31:53 +00:00
Dan Parizher
5eecf7ddef Fix false positive CV05 detection for T-SQL variable assignments in SELECT statements (#7134) 2025-09-20 20:53:31 +00:00
Enrique Perez Delgado
9a5d677dbc Add partitioned by and cluster by segments to SparkSQL Create view statement (#7137) 2025-09-20 20:44:00 +00:00
Danny Jones
655b8f2c3b Mariadb: Enhance CreateIndex Statement (#7127) 2025-09-15 20:26:50 +00:00
Danny Jones
56a4586fe4 Snowflake: Support warehouse resource constraints (#7128) 2025-09-15 20:23:42 +00:00
Peter Budai
9c252f9480 TSQL: Rework batch and statement handling (#7113)
Co-authored-by: Danny Jones <51742311+WittierDinosaur@users.noreply.github.com>
2025-09-14 14:36:07 +00:00
Aaron Keesing
2ad1e3bd82 fix: allow STORING segment in BigQuery CREATE VECTOR INDEX (#7119)
Co-authored-by: Danny Jones <51742311+WittierDinosaur@users.noreply.github.com>
2025-09-14 14:21:51 +00:00
Adam Carruthers
22934e9cb9 Support brackets in CASE statement condition (#7122)
Co-authored-by: Danny Jones <51742311+WittierDinosaur@users.noreply.github.com>
2025-09-14 14:19:04 +00:00
Fran Lozano
edb42dec31 Redshift: Adds NONATOMIC clause support for CREATE PROCEDURE (#7123)
Co-authored-by: Danny Jones <51742311+WittierDinosaur@users.noreply.github.com>
2025-09-14 14:11:38 +00:00
Ben
4d6f9700b2 chore: rename files in trino to comment on (#7125)
Co-authored-by: Danny Jones <51742311+WittierDinosaur@users.noreply.github.com>
2025-09-14 14:10:38 +00:00
Danny Jones
39c5fd0704 Fix mypy error in nested_combine call (#7126) 2025-09-14 13:41:43 +00:00
Fran Lozano
642141941c Postgres: Add support for pg_trgm similarity operators (#7086) 2025-09-06 18:33:40 +00:00
Peter Stenger
8f4f1d4302 Resolve unused CTE bug (#7095) 2025-09-06 18:30:35 +00:00
Fran Lozano
6fc36e9914 Postgres: Fix parse failure on VARIADIC function calls with named parameters (#7115) 2025-09-06 18:20:34 +00:00
Fran Lozano
ecff46f8db Postgres: Support text search configuration statements (#7117) 2025-09-06 18:18:56 +00:00
Victor Blomqvist
5393aa72c2 Add support for T-SQL binary constants notation (0x, 0xAE, etc.) (#7112)
Co-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>
2025-09-01 14:33:28 +00:00
Yuuki Kuno
86c527bace ClickHouse: Add support for DROP PARTITION and REPLACE PARTITION (#7111) 2025-08-31 16:04:32 +00:00
Julian Ahrens
6e5aecdbd8 Snowflake: add multi_line toggle on csv type copy into <table> (#7107) 2025-08-31 15:44:13 +00:00