Safeql[1] can also be a good middleground. Adds type checking to prisma raw queries.

[1] https://safeql.dev/compatibility/prisma.html