Prisma over hand-written SQL
On Royalty Series the schema lived in SQL and the code’s idea of it lived in TypeScript, kept in step by hand. Here the Prisma schema is the one source. Migrations and types are generated from it, so a schema change that the code doesn’t match fails at compile time.
Less control over the exact SQL that runs, and one more dependency that can hold up upgrades to the rest of the stack.
