prisma-client-api

Prisma Client performs CRUD operations and filtering by providing typed methods for creating, reading, updating, and deleting records. You apply filters directly within query methods to retrieve specific data subsets efficiently.

Querying related data in Prisma ORM involves using the include or select options within your model queries. This allows you to retrieve related records from associated models in a single database round-trip.

Executing atomic operations in Prisma transactions is best achieved using the interactive transaction API. This ensures multiple database operations either all succeed or roll back, maintaining data integrity.

Yes, you can execute raw SQL queries using Prisma Client. It provides dedicated methods for raw SQL execution, allowing you to bypass the standard ORM layer for complex or database-specific queries.

Prisma ORM 7.x supports pagination and sorting through built-in query options. You can use cursor or offset pagination and apply orderBy parameters to structure your retrieved data.

You should use raw SQL instead of standard Prisma model queries when dealing with complex database-specific operations or performance-critical joins that exceed the ORM query builder capabilities.