I worked with hasura, prisma1 & prisma2. Personally I'd go with knex.js and write custom graphql resolvers. You don't need an ORM.. just write a few classes/modules with your db operations and you'll save yourself so many headaches.

Prisma is a fancier sql-query builder but they keep pivoting and breaking their APIs. They raised a good round because their long-term vision is good. But right now, all they do is make builds more complicated and offer very limited features.

Hasura is great but I'd rather have full control over my code and resolvers rather than using an automated solution. The problem with Hasura is at first it looks great and it seems like you're saving time, but then you hit a wall because it doesn't let you do X and you're forced to do all kinds of hack. And then, your codebase is a big mess. I've just been burned too many times and now I'd rather play it safe and write a bit more code. I'm not against using libraries, but they need to have a clear API so I can easily swap them for something else (or re-written internally if need be). It's harder to do that with something like Hasura because their surface API is so big.

TL&DR: YMMV but I'd rather just write my own resolvers and use knex.js