Advanced TypeScript Generics for Type-Safe Database Queries with Prisma

Prisma ORM is fantastic for out-of-the-box type safety, but when you start building highly reusable repository functions or custom query wrappers, you often find yourself wrestling with complex return types like Prisma.ScriptGetPayload<...>.

Using advanced TypeScript conditional types and utility types allows you to cleanly infer relational payloads without littering your codebase with any casts.

How do you structure your data access layer (DAL)? Are you writing queries directly inside your Server Actions/API routes, or abstracting them into dedicated service files?