Array Aggregate.

[mwalkersigma]

If I have two collections, say for example PostCollection and CommentCollection.
Where a post can have many comments, obviously I can create a live query and add post_id to a where statement i.e
q.where(({ comment }) => eq(comment.post_id, post_id))

But If instead I wanted to array_aggregate the comments to end up with something like this,
{ ...post, comments: [ an array of all comments with this post id ]}

I didn't see an obvious way to do that in the documentation.

Love the library, its a total game changer!

[mwalkersigma]

Nvm I am blind,

We are working on an include system that will enable joins that project to a hierarchical object. For example an issue row could have a comments property that is an array of comment rows. See this issue for more details.