[spion]

Have you tried drizzle? https://orm.drizzle.team/docs/select#aggregations

(note: it produces type-safe results too)

[KRAKRISMOTT]

Their migrations tool is proprietary and not open-source. The project is basically an open source bait and switch riding off the edge computing hype (since prisma and other major JS ORMs have poor support for edge environments).

[spion]

You don't need to use drizzle migrations. There are much better migration tools.