Hans-Juergen Schoenig: Heterogeneous Graphs in SQL/PGQ on PostgreSQL 19 (opens in new tab)

In the we discussed the basic syntax of graph queries in PostgreSQL 19 and discussed some simple SQL/PGQ examples. However, more often than not applications are more complex and need more than just two basic tables. Therefore, we want to dig a little deeper and see how we can write more complex queries and model some more sophisticated graphs based on real world scenarios. Loading sample data for graphs To demonstrate a couple queries, which happen to be increasingly advanced, we have compile...