SQL/PGQ
A property graph query extension introduced in the SQL:2023 standard. It allows MATCH pattern queries to be written directly over relational tables using a graph model of vertices and edges, without requiring an additional graph database.
Timeline (last 90 days)
The larger user-visible features reverted from PostgreSQL 19 include SQL property graph queries (SQL/PGQ), ALTER TABLE ... MERGE/SPLIT PARTITION(S), UPDATE/DELETE ... FOR PORTION OF, GROUP BY ALL, and online data checksums.
SQL/PGQ is a property graph query extension introduced by the SQL:2023 standard that allows MATCH pattern queries to be written directly over relational tables using a graph model of vertices and edges.
Tom Lane once said that if PostgreSQL 19 shipped SQL/PGQ anyway, the resulting production bugs might not be fixed until PostgreSQL 20.
All Facts (3)
The larger user-visible features reverted from PostgreSQL 19 include SQL property graph queries (SQL/PGQ), ALTER TABLE ... MERGE/SPLIT PARTITION(S), UPDATE/DELETE ... FOR PORTION OF, GROUP BY ALL, and online data checksums.
50%UnverifiedSQL/PGQ is a property graph query extension introduced by the SQL:2023 standard that allows MATCH pattern queries to be written directly over relational tables using a graph model of vertices and edges.
50%UnverifiedTom Lane once said that if PostgreSQL 19 shipped SQL/PGQ anyway, the resulting production bugs might not be fixed until PostgreSQL 20.
50%