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: { role: 'ADMIN', email: { contains: '@prisma.io' } } returns admins with matching emails.

Use prisma.$transaction with an array for sequential operations or an async callback for interactive transactions with dependent logic. Interactive transactions accept options like maxWait, timeout, and isolationLevel such as Serializable.

select returns only the specified scalar fields, while include adds related records to the result. You cannot combine select and omit on the same query, but select and include can be nested within relation options.

Yes, $queryRaw and $executeRaw use tagged templates that parameterize interpolated values, preventing SQL injection. Avoid $queryRawUnsafe with string concatenation, and use Prisma.raw only for trusted identifiers like column names.

Error code P2002 indicates a unique constraint violation, typically from create or update with a duplicate unique field. Use upsert to update-or-create atomically, or catch the error inside a transaction to handle it gracefully.