cwida / duckpgq-extension

DuckDB extension that adds support for SQL/PGQ
https://duckpgq.notion.site/b8ac652667964f958bfada1c3e53f1bb?v=3b47a8d44bdf4e0c8b503bf23f1b76f2
MIT License
86 stars 7 forks source link

Implement more complex join patterns #62

Closed Dtenwolde closed 10 months ago

Dtenwolde commented 11 months ago

Add support for more complex join patterns, such as combining the result of a quantified path pattern with more joins For example:

MATCH o = ANY SHORTEST (p:Person)-[w:knows]-> {1,3}(p2:Person)-[i:hasInterest]->(t:Tag)

Which is equivalent to

MATCH o = ANY SHORTEST (p:Person)-[w:knows]->{1,3}(p2:Person), 
                    (p2:Person)-[i:hasInterest]->(t:Tag)

Which can be broken down into two subqueries. The result of this is joined on the common node, which is (p2:Person) in this case.

Dtenwolde commented 10 months ago

Implemented as of https://github.com/cwida/duckpgq-extension/pull/69