SAP HANA SQL Parser Support in GSP

Explore the SAP HANA SQL Parser product page

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

Syntax Coverage Corpus

GSP tests SAP HANA syntax against 126 documented constructs grouped into 13 categories, each cross-referenced to the documentation that defines it (113 distinct source pages).

Parse coverage

Measured against GSP Java 4.2.8 on 2026-08-31 (UTC) (artifact sha256 1117856ef134). Each construct below carries the complete set of examples from the SAP HANA 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	122 of 126 (97%)	214 of 219 (98%)
SELECT (queries)	17 of 17 (100%)	26 of 26 (100%)
DML (INSERT / UPDATE / DELETE / MERGE)	5 of 5 (100%)	8 of 8 (100%)
Stored procedures	2 of 4 (50%)	4 of 6 (67%)

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 126 constructs

Construct	Category	Parses	Specified in
COMMENT ON		all 2	SAP docs
COMMIT		all 1	SAP docs
CONNECT		all 1	SAP docs
DELETE		all 1	SAP docs
INSERT		all 3	SAP docs
LOCK TABLE		all 2	SAP docs
ROLLBACK		all 1	SAP docs
SAVEPOINT		all 1	SAP docs
SELECT		all 2	SAP docs
UPDATE		all 2	SAP docs
WITH HINT		all 2	SAP docs
ALTER AUDIT POLICY	ALTER	all 3	SAP docs
ALTER CLIENTSIDE ENCRYPTION COLUMN KEY	ALTER	all 3	SAP docs
ALTER CLIENTSIDE ENCRYPTION KEYPAIR	ALTER	all 2	SAP docs
ALTER COLLECTION	ALTER	all 1	SAP docs
ALTER CREDENTIAL	ALTER	all 1	SAP docs
ALTER DATABASE	ALTER	all 3	SAP docs
ALTER FULLTEXT INDEX	ALTER	all 3	SAP docs
ALTER FUNCTION	ALTER	all 2	SAP docs
ALTER INDEX	ALTER	all 3	SAP docs
ALTER JWT PROVIDER	ALTER	all 3	SAP docs
ALTER LDAP PROVIDER	ALTER	all 3	SAP docs
ALTER LIBRARY	ALTER	all 1	SAP docs
ALTER PROCEDURE	ALTER	all 1	SAP docs
ALTER PSE	ALTER	all 3	SAP docs
ALTER REMOTE	ALTER	all 3	SAP docs
ALTER ROLE	ALTER	all 1	SAP docs
ALTER SAML PROVIDER	ALTER	all 3	SAP docs
ALTER SEQUENCE	ALTER	all 3	SAP docs
ALTER TABLE	ALTER	all 3	SAP docs
ALTER VIEW	ALTER	all 3	SAP docs
ALTER VIRTUAL TABLE	ALTER	all 3	SAP docs
BACKUP CATALOG DELETE	BACKUP	all 2	SAP docs
BACKUP CHECK	BACKUP	all 1	SAP docs
BACKUP DATA	BACKUP	all 3	SAP docs
CREATE AUDIT POLICY	CREATE	all 1	SAP docs
CREATE CERTIFICATE	CREATE	all 1	SAP docs
CREATE CLIENTSIDE ENCRYPTION COLUMN KEY	CREATE	all 2	SAP docs
CREATE COLLECTION	CREATE	all 2	SAP docs
CREATE CREDENTIAL	CREATE	all 2	SAP docs
CREATE DATABASE	CREATE	all 3	SAP docs
CREATE FULLTEXT INDEX	CREATE	all 2	SAP docs
CREATE FUNCTION	CREATE	all 2	SAP docs
CREATE GRAPH WORKSPACE	CREATE	all 1	SAP docs
CREATE INDEX	CREATE	all 3	SAP docs
CREATE JWT PROVIDER	CREATE	all 1	SAP docs
CREATE LDAP PROVIDER	CREATE	all 2	SAP docs
CREATE LIBRARY	CREATE	all 1	SAP docs
CREATE PROCEDURE	CREATE	1 of 2	SAP docs
CREATE PROJECTION VIEW	CREATE	all 1	SAP docs
CREATE ROLE	CREATE	all 2	SAP docs
CREATE SCHEMA	CREATE	all 1	SAP docs
CREATE STATISTICS	CREATE	all 3	SAP docs
CREATE TABLE	CREATE	all 6	SAP docs
CREATE TRIGGER	CREATE	all 1	SAP docs
CREATE TYPE	CREATE	all 1	SAP docs
CREATE USER	CREATE	all 2	SAP docs
CREATE VIEW	CREATE	all 1	SAP docs
CREATE VIRTUAL FUNCTION	CREATE	0 of 1	SAP docs
CREATE WORKLOAD CLASS	CREATE	all 2	SAP docs
CREATE WORKLOAD MAPPING	CREATE	all 3	SAP docs
ALTER STATISTICS	DDL	all 3	SAP docs
CALL	DDL	all 2	SAP docs
GRANT	DDL	all 2	SAP docs
LOAD Statement	DDL	all 2	SAP docs
REPLACE	DDL	all 1	SAP docs
REVOKE	DDL	1 of 3	SAP docs
TRUNCATE COLLECTION	DDL	all 1	SAP docs
TRUNCATE TABLE	DDL	all 1	SAP docs
DROP AUDIT POLICY	DROP	all 2	SAP docs
DROP CERTIFICATE	DROP	all 1	SAP docs
DROP CLIENTSIDE ENCRYPTION COLUMN KEY	DROP	all 1	SAP docs
DROP CLIENTSIDE ENCRYPTION KEYPAIR	DROP	all 1	SAP docs
DROP DATABASE	DROP	all 1	SAP docs
DROP FUNCTION	DROP	all 1	SAP docs
DROP INDEX	DROP	all 1	SAP docs
DROP JWT PROVIDER	DROP	all 2	SAP docs
DROP LDAP PROVIDER	DROP	all 1	SAP docs
DROP LIBRARY	DROP	all 1	SAP docs
DROP PROCEDURE	DROP	all 1	SAP docs
DROP PSE	DROP	all 1	SAP docs
DROP REMOTE SOURCE	DROP	all 1	SAP docs
DROP ROLE	DROP	all 1	SAP docs
DROP SAML PROVIDER	DROP	all 2	SAP docs
DROP SCHEMA	DROP	all 1	SAP docs
DROP SEQUENCE	DROP	all 1	third-party reference
DROP SYNONYM	DROP	all 2	SAP docs
DROP TABLE	DROP	all 1	SAP docs
DROP TRIGGER	DROP	all 2	SAP docs
DROP TYPE	DROP	all 1	SAP docs
DROP USER	DROP	all 1	SAP docs
DROP VIEW	DROP	all 1	SAP docs
IMPORT	IMPORT	all 3	SAP docs
IMPORT FROM	IMPORT	all 2	SAP docs
IMPORT SCAN	IMPORT	all 1	SAP docs
MERGE DELTA	MERGE	all 3	SAP docs
MERGE INTO	MERGE	all 1	SAP docs
RECOVER DATA	RECOVER	all 2	SAP docs
RECOVER DATABASE	RECOVER	all 2	SAP docs
RECOVER ENCRYPTION ROOT KEYS	RECOVER	all 1	SAP docs
REFRESH STATISTICS	REFRESH	all 3	SAP docs
REFRESH VIEW	REFRESH	all 1	SAP docs
RELEASE SAVEPOINT	RENAME	0 of 1	SAP docs
RENAME COLLECTION	RENAME	all 1	SAP docs
RENAME COLUMN	RENAME	all 2	SAP docs
RENAME DATABASE	RENAME	all 1	SAP docs
RENAME INDEX	RENAME	all 1	SAP docs
RENAME SCHEMA	RENAME	all 1	SAP docs
RENAME TABLE	RENAME	all 2	SAP docs
CASE JOIN	SELECT	all 1	SAP docs
FOR UPDATE	SELECT	all 2	SAP docs
FROM GROUP BY	SELECT	all 2	SAP docs
FROM GROUP BY HAVING	SELECT	all 1	SAP docs
FROM WHERE	SELECT	all 1	SAP docs
GROUP BY	Select	all 1	SAP docs
INNER JOIN	SELECT	all 2	SAP docs
JOIN	SELECT	all 2	SAP docs
LATERAL JOIN	SELECT	all 1	SAP docs
LEFT JOIN	SELECT	all 4	SAP docs
LEFT OUTER JOIN	SELECT	all 1	SAP docs
LIMIT	SELECT	all 1	SAP docs
SELECT FROM HAVING	SELECT	all 1	SAP docs
UNION	SELECT	all 1	SAP docs
SET SCHEMA	SET	all 1	SAP docs
SET SYSTEM LICENSE	SET	all 1	SAP docs
SET TRANSACTION	SET	all 1	SAP docs

Key Features Supported

• Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
• HANA-specific functions and data types
• Column store and row store operations
• Stored procedures and user-defined functions
• Window functions and analytical queries
• Spatial and graph processing features