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: PGQL on SQL Property Graphs in Oracle AI Database

Description of the illustration sql_pgq_diagram.png

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 AI 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.

• Migrating PGQL Property Graphs to SQL Property Graphs

• Supported PGQL Features and Limitations for SQL Property Graphs
  Learn about the supported PGQL features and limitations for SQL property graphs.