Good example. Now do it with undirected graph. How will the query look like?

So, is this basically running transitive closure on the database during query? it would be expensive.