Subqueries

[kit-ty-kate]

As discussed earlier, we heavily need subqueries (or EXTERNAL JOIN) like:

let sub l = <:view< group { tags = array_agg[t.name] } | t in $tags$; something with l and t >> in
Query.view db <:view< { tags = one ($sub$ l); l.id } | l in $links$ >>

So I'm making this issue to discuss and have feedbacks. I'll be glad to help if you need.

[kit-ty-kate]

I'll try with unions for the moment. I'll see if it fills my needs.

[gasche]

I've been working on this, but it is rather hard to implement, because of the interaction with flattening in particular (go have a look at sql_flatten.ml for one of the most complex parts of Macaque), so I will need a few more days.