Exploring property graphs with SQL/PGQ in PostgreSQL | POSETTE: An Event for Postgres 2026

A technical deep-dive into SQL/PGQ (Property Graph Queries), the SQL:2023 standard for declarative graph traversal in PostgreSQL. Uses the Ticket to Ride game as a practical example to demonstrate defining Property Graphs over relational tables and implementing pathfinding with the MATCH clause. Covers implementation details including how graph patterns transform into relational join trees and the complexities of path-variable bindings. Targeted at developers and DBAs wanting to understand upcoming PostgreSQL graph capabilities.