pgql-lang.org

What It Is

PGQL (Property Graph Query Language) is a property graph query language designed to add graph pattern-matching capabilities to syntax that is familiar to SQL users. It is aimed both at developers with an existing SQL background and at users who want to use graph technologies but may not be familiar with SQL. The site demonstrates how to create property graphs from relational tables and query relationships among people, companies, accounts, and transactions.

Core Capabilities

PGQL retains SQL constructs such as SELECT, FROM, WHERE, GROUP BY, and ORDER BY, while adding fixed-length and variable-length graph pattern matching. Fixed-length patterns are suitable for matching a defined number of vertices and edges, and can use label expressions to match different types of relationships. Variable-length patterns support quantifiers such as *, +, and {2,4} for recursive matching, reachability queries, shortest paths, and lowest-cost path analysis. PGQL also supports CREATE PROPERTY GRAPH and the SQL-standard-style GRAPH_TABLE, with plans to align as closely as possible with SQL:2023 SQL/PGQ.

Pricing and Ecosystem

The main text does not provide commercial pricing for PGQL. The project is described as open source and offers an open-source PGQL parser along with specification documents for multiple versions. In terms of ecosystem, PGQL is closely tied to Oracle Database: it has been available as a standalone language since Oracle Database 12.2, and property graph capabilities are further integrated into SQL in Oracle Database 23ai. The page also links to Oracle Graph Database and Oracle Labs PGX.

Pros and Cons

Its advantages include strong SQL affinity, making it suitable for database teams to introduce graph querying smoothly; syntax that covers both custom PGQL and SQL-standard-style usage, giving it good migration flexibility; and relatively complete specification documents and examples. Its limitations are that the page feels more like a language specification site than a full developer platform, and it does not provide information on pricing, SLAs, SDKs, IDE plugins, or visual debugging. Implementations beyond Oracle and the level of community activity also cannot be determined from the main text.

Who It’s For / Access in China

PGQL is suitable for database developers and data platform teams that need to build property graphs on top of relational data and perform transaction network analysis, relationship network analysis, path discovery, and graph analytics. Access from mainland China is not mentioned in the main text, so its availability is unknown.