Sql Pgq

PostgreSQL 19 beta adds native property graph queries via SQL/PGQ

PostgreSQL 19, now in beta ahead of a general release expected around September or October 2026, introduces support for SQL/PGQ, the property-graph portion of the SQL:2023 standard. The feature lets developers define a graph structure over existing relational tables and query it with pattern-matching syntax rather than manually writing joins. A hands-on walkthrough tested against PostgreSQL 19 beta 3 demonstrates how tables can be declared as vertices and edges and then queried using the new GRAPH_TABLE construct.