Problem

We support ordering by a relation field, but not order by a relation aggregate.

For example: get all users, order by post count.

prisma.user.findMany({
  orderBy: {
    posts: { 
      count: 'asc'
    }
  }
})

Additional context

• same request but for groupby: Order by aggregate (like count) in groupBy #5464
• order by relation field: Support Order by Relations #5008