Hello, has anyone been able to find a workaround to order by a field in a relationship?. For example, I have a Job model that has an "author" field of the type User and the user has an email address. I'm trying to sort the jobs alphabetically by the email of the author without having to fetch all of the jobs at once and sort them manually.

Hey @Kervin Vasquez 👋 Unfortunately

prisma.queryRaw

is the only way to order by relations at the moment. You can track this issue and add a 👍 for us to set the priority.