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 and relations, while include adds all scalar fields plus the specified relations. You cannot combine select and omit on the same query, but include can be nested inside select.

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

Use take and skip for offset pagination, or cursor with take for cursor-based pagination. For cursor pagination, pass the last record's unique field as cursor and set skip: 1 to exclude the cursor record itself.

PostgreSQL returns BigInt for COUNT aggregations through raw queries. Convert the result with Number(result[0].count) before using it in JSON serialization or arithmetic operations.