prisma-client-api

Pass a where object to findMany with field conditions like { role: 'ADMIN' } or operators such as contains, gte, and in. Combine conditions with AND, OR, and NOT for complex logic, and add orderBy, take, and skip for sorting and pagination.

Use the interactive form prisma.$transaction(async (tx) => {...}) when operations depend on each other or need conditional logic. Use the array form prisma.$transaction([op1, op2]) for simple sequential batches; both roll back entirely on failure.

select returns only the specified scalar fields, while include adds full related records to the result. They can be combined at nested levels, but select and omit cannot be used together on the same query.

Yes, $queryRaw and $executeRaw use tagged templates that parameterize interpolated values, preventing SQL injection. Avoid $queryRawUnsafe with string concatenation; use Prisma.sql, Prisma.join, and Prisma.raw for dynamic fragments.

Use findUniqueOrThrow when a missing record is an error condition, since it throws PrismaClientKnownRequestError instead of returning null. This is especially useful inside interactive transactions where the throw triggers an automatic rollback.