prisma-client-api

Use the where clause with filter operators like equals, contains, gt, lt, in, and logical operators AND, OR, NOT. For example, prisma.user.findMany({ where: { email: { contains: '@prisma.io' }, role: 'ADMIN' } }) filters by multiple conditions.

Prisma supports sequential transactions via prisma.$transaction([op1, op2]) and interactive transactions via prisma.$transaction(async (tx) => {...}). Interactive transactions allow dependent operations and conditional logic, with options for maxWait, timeout, and isolationLevel.

findUnique locates a record by a unique field or composite unique key, while findFirst returns the first record matching any filter condition. Both have OrThrow variants that raise an error when no record is found.

Yes, use $queryRaw and $executeRaw with tagged template literals, which automatically parameterize values to prevent SQL injection. Avoid $queryRawUnsafe with string concatenation, and use Prisma.sql and Prisma.join for dynamic query construction.

Use the include option to load relations, or select for fine-grained field control. Both support nesting, filtering with where, ordering, and pagination on relations, plus _count for relation counts.

Use select to explicitly choose which fields to return, and omit to exclude specific fields like passwords while returning everything else. Note that select and omit cannot be used together in the same query.