Exasol SQL Parser Support in GSP¶

This page documents the SQL syntax support for Exasol in the General SQL Parser.

Syntax Coverage Corpus¶

GSP tests Exasol syntax against 56 documented constructs grouped into 8 categories, each cross-referenced to the documentation that defines it (56 distinct source pages).

Parse coverage¶

Measured against GSP Java 4.2.6 on 2026-08-18 (UTC) (artifact sha256 44c4c247d5ee). Each construct below carries the complete set of examples from the Exasol documentation; a construct counts as fully covered only when every one of its examples parses. Percentages are pass rates over this documented-example corpus — not a percentage of the entire SQL dialect.

	Constructs fully parsed	Individual statements parsed
All constructs	54 of 56 (96%)	194 of 199 (97%)
SELECT (queries)	11 of 12 (92%)	28 of 29 (97%)
DML (INSERT / UPDATE / DELETE / MERGE)	5 of 5 (100%)	14 of 14 (100%)
Stored procedures	0 of 1 (0%)	0 of 2 (0%)

Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly. The SELECT, DML and stored-procedure rows classify each statement by its parsed statement type: a construct is counted in a row when its examples contain at least one statement of that class, and is fully parsed when all of them parse. Stored procedures covers CREATE PROCEDURE / FUNCTION / PACKAGE / TRIGGER definitions and anonymous blocks.

Machine-readable: dialect data (JSON) · all-dialect matrix · coverage matrix overview

All 56 constructs¶

Construct	Category	Parses	Specified in
`CLOSE SCHEMA`		all 5	Exasol docs
`COMMENT`		all 4	Exasol docs
`COMMIT`		all 4	Exasol docs
`CONSUMER GROUP`		all 3	Exasol docs
`DESC[RIBE]`		all 2	https://docs.exasol.com/sql/desc[ribe].htm
`EXECUTE SCRIPT`		all 3	Exasol docs
`EXPLAIN VIRTUAL`		all 1	Exasol docs
`EXPORT`		all 9	Exasol docs
`FLUSH STATISTICS`		all 3	Exasol docs
`GRANT`		all 10	Exasol docs
`IMPERSONATE`		all 2	Exasol docs
`IMPORT`		all 8	Exasol docs
`KILL`		all 1	Exasol docs
`MERGE`		all 2	Exasol docs
`OPEN SCHEMA`		all 1	Exasol docs
`PRELOAD`		all 1	Exasol docs
`RECOMPRESS`		all 2	Exasol docs
`RENAME`		all 3	Exasol docs
`REORGANIZE`		all 1	Exasol docs
`REVOKE`		all 6	Exasol docs
`ROLLBACK`		all 2	Exasol docs
`Table Operators - UNION [ALL], INTERSECT, MINUS`		all 4	Exasol docs
`TRUNCATE`		all 1	Exasol docs
`TRUNCATE AUDIT LOGS`		all 3	Exasol docs
`Verification of the Foreign Key Property (FOREIGN KEY)`		all 3	Exasol docs
`Verification of the Primary Key Property (PRIMARY KEY)`		all 3	Exasol docs
`Verification of the Uniqueness (UNIQUE)`		all 2	Exasol docs
`ALTER CONNECTION`	ALTER	all 3	Exasol docs
`ALTER SCHEMA`	ALTER	all 5	Exasol docs
`ALTER SESSION`	ALTER	all 4	Exasol docs
`ALTER SYSTEM`	ALTER	all 15	Exasol docs
`ALTER TABLE (Column)`	ALTER	all 12	Exasol docs
`ALTER TABLE (constraints)`	ALTER	all 5	Exasol docs
`ALTER TABLE (distribution/partitioning)`	ALTER	all 2	Exasol docs
`ALTER USER`	ALTER	all 3	Exasol docs
`CREATE CONNECTION`	CREATE	all 5	Exasol docs
`CREATE FUNCTION`	CREATE	1 of 5	Exasol docs
`CREATE ROLE`	CREATE	all 1	Exasol docs
`CREATE SCHEMA`	CREATE	all 3	Exasol docs
`CREATE SCRIPT`	CREATE	all 1	Exasol docs
`CREATE TABLE`	CREATE	all 9	Exasol docs
`CREATE USER`	CREATE	all 2	Exasol docs
`CREATE VIEW`	CREATE	all 3	Exasol docs
`DELETE`	DELETE	all 2	Exasol docs
`DROP CONNECTION`	DROP	all 1	Exasol docs
`DROP FUNCTION`	DROP	all 1	Exasol docs
`DROP ROLE`	DROP	all 1	Exasol docs
`DROP SCHEMA`	DROP	all 4	Exasol docs
`DROP SCRIPT`	DROP	all 1	Exasol docs
`DROP TABLE`	DROP	all 1	Exasol docs
`DROP USER`	DROP	all 2	Exasol docs
`DROP VIEW`	DROP	all 1	Exasol docs
`INSERT`	INSERT	all 6	Exasol docs
`SELECT`	SELECT	7 of 8	Exasol docs
`SELECT INTO`	SELECT	all 1	Exasol docs
`UPDATE`	UPDATE	all 3	Exasol docs

Key Features Supported¶

Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
Exasol-specific functions and data types
Stored procedures and user-defined functions
Window functions and analytical queries
Parallel processing optimizations
ETL and data integration features