Hi, I have the exact same case that this stackoverflow question about LEFT JOINS and aggregation. Can you confirm this is the right answer ? Impossible to do it with a single query ? How does it scale ?

Joins and aggregations in a single query aren’t yet supported so the above approach is the only way. It would be great if you could add a 👍 to this request. As for scaling, depends on the number of items you’re pulling in.

Thanks for the confirmation Ryan, I added a 👍 on the request and I’ll implement it like that waiting for the support !