Count in relational queries
How do I count in relational queries? For example if i'm querying db.query.posts.findMany() and want to include an extra field that counts the number of likes (diff table), how can I achieve that? Couldn't make it work with the "extras" and trying to make a sql
count() there.
Thanks in advance6 Replies
aggregations are not supported yet, but it's one of our priorities
@bloberenober any news here?
still no updates here, currently you should use separate query to count anything you need
Or use drizzle core api to make, where you can simulate almost any query complexity
Any updates @Andrew Sherman ?
Would prefer this done as well
and learn some sql along the way! drizzle core API > query builder 🤣