PostgreSQL 19 adds standardized SQL/PGQ graph query syntax through multi-vendor collaboration

PostgreSQL 19 is set to ship baked-in SQL syntax for querying property graphs, implementing SQL/PGQ from the SQL 2023 standard. This is a departure from the previous approach where graph query capabilities in PostgreSQL were handled through object relational mapping layers rather than native syntax. The release is expected later this month or early October.

The implementation came out of collaboration among several of PostgreSQL's largest contributors, including committers who sit on the SQL standards committee and engineers behind OpenCypher, the open source graph query language. Alastair Turner, a PostgreSQL evangelist at Percona, described it as one of the big multi-vendor collaborations in the project, involving substantial coding and review work across contributors.

The current implementation creates queries across node-edge graphs and some perform well, but Turner acknowledged it still needs one or two additional syntax features before it can displace dedicated graph databases for a significant number of workloads. The more pressing gap is indexing: Turner said indexing add-ons will need to catch up in the next iteration or two to improve performance, meaning teams with heavy graph workloads may not see competitive performance immediately.

Only one feed carried this story, so the framing comes entirely from The Register's reporting and Turner's commentary. The headline's claim that this is a standardized, multi-vendor effort is corroborated by Turner's description of the collaboration, but the caveat about indexing limitations is equally central to the story and should temper expectations for production adoption at scale.