7 Executing PGQL Queries Against SQL Property Graphs

You can directly run PGQL queries against a SQL property graph in the database.

The PGQL query execution flow is shown in the following figure:

Figure 7-1 PGQL on SQL Property Graphs in Oracle Database

Description of "Figure 7-1 PGQL on SQL Property Graphs in Oracle Database"

The basic execution flow is:

1. The PGQL query is performed on a SQL property graph through a Java API.
2. The PGQL query is translated to SQL/PGQ (SQL graph query).
3. The translated SQL/PGQ is submitted to Oracle Database by JDBC.
4. The SQL/PGQ result set is wrapped as a PGQL result set and returned to the caller.

See Supported PGQL Features and Limitations for SQL Property Graphs for a complete list of supported and unsupported features.

• Creating a SQL Property Graph Using PGQL
  You can create a SQL property graph from the database tables using the CREATE PROPERTY GRAPH PGQL DDL statement.
• Executing PGQL SELECT Queries on a SQL Property Graph
  You can execute PGQL SELECT queries, on a SQL property graph, using the Java API in the oracle.pg.rdbms.pgql package.
• Supported PGQL Features and Limitations for SQL Property Graphs
  Learn about the supported PGQL features and limitations for SQL property graphs.