could someone show me the way to do this query using drizzle

I have a query with a one to many join but I don't seem to be able to array agg and group by to stop the rows being produced multiple times, how could I do this?
Was this page helpful?