Prisma now supports SQL joins(prisma.io)

https://www.prisma.io/blog/prisma-orm-now-lets-you-choose-the-best-join-strategy-preview