Using prisma.$queryRaw, I was able to write a basic query that returned the data I needed. However, I also needed the query to filter and order the data.
This series covers building a simple REST API using the Prisma ORM and Postgresql. Here, I'll explain how to use this Prisma client in our express server.
Prisma migrations are simple for local development, but what about staging and production on Heroku? Here are three ways to run Prisma migrations on Heroku.
Are you thinking about using Prisma as your ORM? If you're using Yarn PnP or SQL views in your project, you might want to know these Prisma quirks first.