Supported Features
-
INSERT, DELETE, UPDATE, and SELECT
-
Subqueries
-
Tables, indices, triggers, and views
-
BEGIN, ROLLBACK, COMMIT
-
INNER JOIN, LEFT OUTER JOIN, NATURAL JOIN
-
UNION, UNION ALL, INTERSECT, EXCEPT
-
UNIQUE and NOT NULL constraints
|
Features Not Supported
-
CHECK constraints (parsed but not enforced)
-
Correlated Subqueries
-
Foreign Keys (parsed but not enforced)
-
ALTER TABLE
-
Some details of TRIGGER are omitted
-
RIGHT and FULL OUTER JOIN
-
Writing to VIEWs
-
GRANT and REVOKE
|
