prisma-client-api

Use prisma.model.findMany with a where clause containing filter operators like equals, contains, in, gt, or lt. Combine conditions with AND, OR, and NOT, and add orderBy, take, and skip for sorting and pagination.

Use prisma.$transaction with an array for sequential independent operations, or pass an async function for interactive transactions where later operations depend on earlier results. Interactive transactions support maxWait, timeout, and isolationLevel options.

select returns only the specified scalar fields, while include adds full related records to the result. You can nest select inside include or vice versa, but select and omit cannot be used together on the same query.

Yes, use $queryRaw and $executeRaw with tagged template literals so user input is automatically parameterized. Avoid $queryRawUnsafe with string concatenation, which creates SQL injection risk; use Prisma.sql and Prisma.join for dynamic fragments.

Use relation filters in the where clause: some matches records with at least one matching relation, every requires all to match, and none requires zero matches. For one-to-one relations, use is and isNot.

Use upsert when a record may already exist and you want to update it or create it otherwise, keyed on a unique field. It takes where, update, and create arguments, avoiding separate existence checks and race conditions.