prowdsponsor / esqueleto

Bare bones, type-safe EDSL for SQL queries on persistent backends.
http://hackage.haskell.org/package/esqueleto
BSD 3-Clause "New" or "Revised" License
177 stars 51 forks source link

Combine subqueries with outer joins #114

Open rubenmoor opened 8 years ago

rubenmoor commented 8 years ago

In this stackoverflow question I learned that subqueries can be joined only as inner joins.

How big of a restriction is that? I.e. could I fork esqueleto and implement it or would require fundamental changes?

(cf. my question on stackoverflow on the topic)

meteficha commented 8 years ago

I don't see an easy way of supporting it. But I don't want to discourage you, maybe you'll approach this problem from a better angle than I did =).

BTW, subqueries are orthogonal to this issue.

meteficha commented 8 years ago

(Pressed "Comment" too early.) Instead of "subqueries", I think it would be better to say "composition".