prisma-client-api

Use findMany with a where clause for filters and include or select for relations. For example, filter users by role with where: { role: 'ADMIN' } and load related posts with include: { posts: true }. Filter operators like contains, gt, and in handle complex conditions.

Use prisma.$transaction with an array for sequential operations or an async callback for interactive transactions with dependent logic. Interactive transactions support conditional checks and rollback automatically if any operation throws. You can set maxWait, timeout, and isolationLevel options.

Yes, $queryRaw and $executeRaw use tagged templates that parameterize interpolated values, preventing SQL injection. Avoid $queryRawUnsafe with string concatenation of user input. Use Prisma.sql and Prisma.join to build dynamic queries safely.

select returns only specified fields, include adds related records to the result, and omit excludes specific fields like passwords. You cannot combine select and omit in the same query. Both select and include support nested relation options and filtering.

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 skip: 1 to exclude it. Negative take values return records from the end.

Next.js hot reloading in development creates new PrismaClient instances 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.