Until Prisma can manage JOINs [0] there is no way I can recommend it.
The support for JOINs is coming, currently under a feature flag [0]
[0]: https://github.com/prisma/prisma/issues/5184#issuecomment-18...
But the migration stuff is a horrible joke. No way to just rollback a broken migration. https://www.prisma.io/docs/orm/prisma-migrate/workflows/gene...
I have worked in many languages with many ORMs and this has been my personal favorite.