I suggest to not add a layer.
Stay close of the SQL request, you can simply have a function that will fulfill an access pattern. No need for ORM.
What I am looking for is ideally something that helps with type saftey and seeds/migrations/schema creation.
The thing is of course that with very complex queries you'll end up making quite intricate string building stuff which may not be very pretty. I myself am curious to find out if Prisma can make that part go away.