prisma-client-api

Use the where option in findMany with filter operators like equals, contains, gt, lt, in, and logical operators AND, OR, NOT. Combine multiple conditions for implicit AND, or nest OR and NOT blocks for complex queries.

Prisma supports sequential transactions via an array passed to $transaction, and interactive transactions via an async callback receiving a scoped tx client. Interactive transactions support conditional logic, dependent operations, and options like maxWait, timeout, and isolationLevel.

select returns only the specified scalar fields, while include loads entire related records alongside all scalar fields. You can nest select inside include or vice versa, but select and omit cannot be used together on the same query.

Yes, $queryRaw executes SELECT statements with typed results and $executeRaw runs INSERT, UPDATE, or DELETE returning affected counts. Template literals parameterize values automatically to prevent SQL injection; avoid $queryRawUnsafe with untrusted input.

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

Next.js hot reloading in development creates a new PrismaClient instance on each reload, exhausting database connections. Storing the client on globalThis ensures a single instance persists across reloads while production creates one instance per process.