prisma-client-api

Prisma Client queries support CRUD model methods including find, create, update, delete, alongside aggregate and groupBy. You shape results using `where`, `select`, `include`, ordering, pagination, distinct, and cursor-based patterns for precise data retrieval.

Loading nested relations safely in Prisma uses `include` and `select` to fetch related data, while relation filter operators allow you to filter based on related model properties without risking invalid query structures.

Executing raw SQL securely in Prisma involves using the `$queryRaw` and `$executeRaw` APIs. Following raw query safety guidance prevents SQL injection vulnerabilities while running custom database queries outside the standard Prisma Client model methods.

Prisma handles database transactions through dedicated transaction APIs. These allow you to execute multiple database operations sequentially or interactively, ensuring atomicity so that either all operations succeed or none are applied.

Prisma query options for pagination and sorting include `take`, `skip`, `cursor`, and `orderBy`. You can combine these with `distinct` to retrieve unique records and manage large datasets efficiently across your application.