6.9.1 PGQL Features Supported

PGQL is a SQL-like query language for querying property graph data. It is based on the concept of graph pattern matching and allows you to specify, among other things, topology constraints, paths, filters, sorting and aggregation.

The Java API for PGQL defined in the oracle.pg.rdbms.pgql package supports the PGQL specification with a few exceptions. (The PGQL specification can be found at https://pgql-lang.org).

The following features of PGQL are not supported.

• Shortest path
• ARRAY_AGG aggregation
• IN and NOT IN predicates
• Single CHEAPEST path and TOP-K CHEAPEST path using COST functions
• Case-insensitive matching of uppercased references to labels and properties

In addition, the following features of PGQL require special consideration.

• Temporal Types
  
• Type Casting
  
• CONTAINS Built-in Function