And if I'm planning on writing raw SQL against my prisma database should I be aware of any gotchas?

I am also interested in this question. What about using an ORM (Sequelize/Postgres) to access to the database as well as prisma?