Comment by leetharris
2 years ago
The closest thing to what you're describing is Prisma in Node. It generates a Typescript file from your schema so you get code completion on your data. And it exists somewhere between a query builder and a traditional ORM.
I have worked in many languages with many ORMs and this has been my personal favorite.
Until Prisma can manage JOINs [0] there is no way I can recommend it.
[0]: https://github.com/prisma/prisma/discussions/12715
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...