Basic SQL#

Data Description (DDL)#

SQL Commands	Parses	Works
ALTER TABLE	✅	❌
CREATE DATABASE	✅	🟠
CREATE TABLE	✅	🟠
DROP DATABASE	✅	🟠
DROP TABLE	✅	🟠

Data Manipulation (DML)#

SQL Commands	Parses	Works
CALL	✅	✅
DELETE	🟠	🟠
INSERT	🟠	🟠
SELECT	🟠	🟠
UPDATE	🟠	🟠
VALUES	🟠	🟠

All SQL#

Access management statements#

SQL Commands	Parses	Works
ALTER DEFAULT PRIVILEGES	✅	❌
ALTER GROUP	❌	❌
ALTER ROLE	❌	❌
ALTER USER	❌	❌
ALTER USER MAPPING	❌	❌
CREATE GROUP	🟠	❌
CREATE ROLE	🟠	❌
CREATE USER	🟠	❌
CREATE USER MAPPING	❌	❌
DROP GROUP	✅	❌
DROP ROLE	✅	❌
DROP USER	✅	❌
DROP USER MAPPING	❌	❌
GRANT	✅	❌
REASSIGN OWNED	❌	❌
REVOKE	✅	❌

Data definition statements#

SQL Commands	Parses	Works	Notes and limitations
ALTER AGGREGATE	✅	❌
ALTER COLLATION	✅	❌
ALTER CONVERSION	✅	❌
ALTER DATABASE	✅	❌
ALTER DOMAIN	✅	❌
ALTER EVENT TRIGGER	❌	❌
ALTER EXTENSION	❌	❌
ALTER FOREIGN DATA WRAPPER	❌	❌
ALTER FOREIGN TABLE	❌	❌
ALTER FUNCTION	✅	❌
ALTER INDEX	✅	❌
ALTER LANGUAGE	✅	❌
ALTER LARGE OBJECT	❌	❌
ALTER MATERIALIZED VIEW	✅	❌
ALTER OPERATOR	❌	❌
ALTER OPERATOR CLASS	❌	❌
ALTER OPERATOR FAMILY	❌	❌
ALTER POLICY	❌	❌
ALTER PROCEDURE	✅	❌
ALTER PUBLICATION	❌	❌
ALTER ROUTINE	❌	❌
ALTER RULE	❌	❌
ALTER SCHEMA	✅	❌
ALTER SEQUENCE	✅	❌
ALTER SERVER	❌	❌
ALTER STATISTICS	❌	❌
ALTER SUBSCRIPTION	❌	❌
ALTER SYSTEM	❌	❌
ALTER TABLE	✅	❌
ALTER TABLESPACE	❌	❌
ALTER TEXT SEARCH CONFIGURATION	❌	❌
ALTER TEXT SEARCH DICTIONARY	❌	❌
ALTER TEXT SEARCH PARSER	❌	❌
ALTER TEXT SEARCH TEMPLATE	❌	❌
ALTER TRIGGER	✅	❌
ALTER TYPE	✅	❌
ALTER VIEW	✅	❌
COMMENT	✅	❌
CREATE ACCESS METHOD	❌	❌
CREATE AGGREGATE	✅	❌
CREATE CAST	❌	❌
CREATE COLLATION	❌	❌
CREATE CONVERSION	❌	❌
CREATE DATABASE	✅	🟠
CREATE DOMAIN	✅	❌
CREATE EVENT TRIGGER	❌	❌
CREATE EXTENSION	✅	❌
CREATE FOREIGN DATA WRAPPER	❌	❌
CREATE FOREIGN TABLE	❌	❌
CREATE FUNCTION	✅	❌
CREATE INDEX	✅	❌
CREATE LANGUAGE	✅	❌
CREATE MATERIALIZED VIEW	✅	❌
CREATE OPERATOR	❌	❌
CREATE OPERATOR CLASS	❌	❌
CREATE OPERATOR FAMILY	❌	❌
CREATE POLICY	❌	❌
CREATE PROCEDURE	✅	❌
CREATE PUBLICATION	❌	❌
CREATE RULE	❌	❌
CREATE SCHEMA	✅	❌
CREATE SEQUENCE	✅	❌
CREATE SERVER	❌	❌
CREATE STATISTICS	❌	❌
CREATE SUBSCRIPTION	❌	❌
CREATE TABLE	✅	🟠
CREATE TABLE … PARTITION	✅	❌	PARTITIONs are parsed, but ignored
CREATE TABLESPACE	❌	❌
CREATE TEXT SEARCH CONFIGURATION	❌	❌
CREATE TEXT SEARCH DICTIONARY	❌	❌
CREATE TEXT SEARCH PARSER	❌	❌
CREATE TEXT SEARCH TEMPLATE	❌	❌
CREATE TRANSFORM	❌	❌
CREATE TRIGGER	✅	❌
CREATE TYPE	✅	❌
CREATE VIEW	✅	🟠
DROP ACCESS METHOD	❌	❌
DROP AGGREGATE	✅	❌
DROP CAST	❌	❌
DROP COLLATION	❌	❌
DROP CONVERSION	❌	❌
DROP DATABASE	✅	🟠
DROP DOMAIN	✅	❌
DROP EVENT TRIGGER	❌	❌
DROP EXTENSION	✅	❌
DROP FOREIGN DATA WRAPPER	❌	❌
DROP FOREIGN TABLE	❌	❌
DROP FUNCTION	✅	❌
DROP INDEX	✅	🟠
DROP LANGUAGE	✅	❌
DROP MATERIALIZED VIEW	✅	🟠
DROP OPERATOR	❌	❌
DROP OPERATOR CLASS	❌	❌
DROP OPERATOR FAMILY	❌	❌
DROP OWNED	❌	❌
DROP POLICY	❌	❌
DROP PROCEDURE	✅	❌
DROP PUBLICATION	❌	❌
DROP ROUTINE	❌	❌
DROP RULE	❌	❌
DROP SCHEMA	✅	❌
DROP SEQUENCE	✅	❌
DROP SERVER	❌	❌
DROP STATISTICS	❌	❌
DROP SUBSCRIPTION	❌	❌
DROP TABLE	✅	🟠
DROP TABLESPACE	❌	❌
DROP TEXT SEARCH CONFIGURATION	❌	❌
DROP TEXT SEARCH DICTIONARY	❌	❌
DROP TEXT SEARCH PARSER	❌	❌
DROP TEXT SEARCH TEMPLATE	❌	❌
DROP TRANSFORM	❌	❌
DROP TRIGGER	✅	🟠
DROP TYPE	✅	❌
DROP VIEW	✅	🟠
SECURITY LABEL	❌	❌

Data manipulation statements#

SQL Commands	Parses	Works
CALL	✅	✅
CLOSE	❌	❌
CREATE TABLE AS	✅	❌
CLUSTER	❌	❌
COPY	❌	❌
DECLARE	❌	❌
DELETE	🟠	🟠
DO	❌	❌
FETCH	❌	❌
IMPORT FOREIGN SCHEMA	❌	❌
INSERT	🟠	🟠
LOAD	❌	❌
MERGE	❌	❌
MOVE	❌	❌
REFRESH MATERIALIZED VIEW	✅	❌
REINDEX	❌	❌
SELECT	🟠	🟠
SELECT INTO	❌	❌
TRUNCATE	🟠	🟠
UPDATE	🟠	🟠
VACUUM	❌	❌
VALUES	🟠	🟠

Prepared statements#

SQL Commands	Parses	Works
DEALLOCATE	✅	❌
PREPARE	✅	❌
EXECUTE	✅	❌

Session management statements#

SQL Commands	Parses	Works
DISCARD	🟠	❌
RESET	✅	❌
SET	✅	🟠
SET CONSTRAINTS	✅	❌
SET ROLE	✅	❌
SET SESSION AUTHORIZATION	✅	❌
SET TRANSACTION	🟠	❌
SHOW	✅	🟠

Transactional statements#

SQL Commands	Parses	Works
ABORT	✅	✅
BEGIN	🟠	🟠
CHECKPOINT	❌	❌
COMMIT	✅	✅
COMMIT PREPARED	❌	❌
END	✅	✅
LISTEN	❌	❌
LOCK	❌	❌
NOTIFY	❌	❌
PREPARE TRANSACTION	❌	❌
RELEASE SAVEPOINT	✅	✅
ROLLBACK	✅	✅
ROLLBACK PREPARED	❌	❌
ROLLBACK TO SAVEPOINT	✅	✅
SAVEPOINT	✅	✅
START TRANSACTION	🟠	🟠
UNLISTEN	❌	❌

Utility statements#

SQL Commands	Parses	Works	Notes and limitations
ANALYZE	❌	❌
EXPLAIN	❌	❌