prisma-client-api

Use the where option with filter operators like equals, contains, gt, lt, in, and logical operators AND, OR, NOT. For example, where: { age: { gte: 18 }, role: 'ADMIN' } returns adult admins, and you can combine conditions with relation filters like some, every, and none.

Prisma supports sequential transactions via prisma.$transaction([op1, op2]) for independent operations and interactive transactions via prisma.$transaction(async (tx) => {...}) for dependent logic. Interactive transactions accept options like maxWait, timeout, and isolationLevel such as Serializable.

select returns only the specified scalar fields, while include adds full related records to the result. You cannot combine select and omit on the same query, but you can nest select inside include or vice versa for fine-grained control over returned data.

Yes, $queryRaw and $executeRaw use tagged templates that automatically parameterize interpolated values, preventing SQL injection. Avoid $queryRawUnsafe with string concatenation of user input; use Prisma.sql, Prisma.join, and Prisma.raw only for trusted identifiers.

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 thrown error triggers an automatic rollback.