Supported PGQL Features and Limitations
Feature | PGQL on RDBMS | PGQL on RDBMS | PGQL on the Graph Server (PGX) |
---|---|---|---|
(PGQL Property Graph) | (SQL Property GraphFoot 1) | ||
CREATE PROPERTY GRAPH |
Supported | Supported | Supported
Limitations:
|
DROP PROPERTY GRAPH |
Supported | Supported | Not Supported |
Fixed-length pattern matching | Supported | Supported | Supported |
Variable-length pattern matching goals | Supported:
Limitations:
|
Not Supported | Supported:
|
Variable-length pattern matching quantifiers | Supported:
|
Not Supported | Supported:
Limitations:
|
Variable-length path unnesting | Supported:
Not supported:
|
Not Supported | Supported:
Limitation:
|
GROUP BY |
Supported | Supported | Supported |
HAVING |
Supported | Supported | Supported |
Aggregations | Supported:
Limitations:
|
Supported:
|
Supported:
Not Supported:
|
DISTINCT
|
Supported | Supported | Supported |
SELECT v.* |
Supported | Not Supported | Supported |
ORDER BY (+ASC/DESC), LIMIT, OFFSET |
Supported | Supported | Supported |
Data Types | All available Oracle RDBMS data types supported | All available Oracle RDBMS data types supported | Supported:
|
JSON | Supported:
|
Supported:
|
No built-in JSON support. However, JSON values can be stored as
STRING and manipulated or queried through user-defined functions
(UDFs) written in Java or JavaScript.
|
Operators | Supported:
|
Supported:
|
Supported:
|
Functions and predicates |
Supported are all available functions in the Oracle RDBMS that take
the form Supported PGQL functions/predicates:
Limitations:
|
Supported are all available functions in the Oracle RDBMS that take
the form Supported PGQL functions/predicates:
Unsupported PGQL functions/predicates are all vertex/edge functions |
Supported:
|
User-defined functions | Supported:
|
Supported:
|
Supported:
|
Subqueries:
|
Supported:
|
Supported subqueries:
|
Supported |
GRAPH_TABLE operator
|
Supported
Extension:
|
Not supported | Supported |
INSERT/UPDATE/DELETE |
Supported | Not supported | Supported |
INTERVAL literals and operations
|
Not supported | Not supported |
Supported literals:
Supported operations:
|
Footnote 1 SQL Property Graphs are supported only in Oracle Database 23ai, currently available with Always Free Autonomous Database.