prisma-client-api

Use the where option with operators like equals, contains, gt, lt, in, and logical combinators AND, OR, NOT. For relations, apply some, every, or none filters, and use is/isNot for one-to-one relations.

Use take and skip for offset pagination, or cursor-based pagination by passing a cursor with the last record's unique field plus skip: 1. Negative take values return records from the end of the result set.

Sequential transactions pass an array of operations to $transaction and run them in order with better performance. Interactive transactions use an async callback with a tx client, supporting dependent operations and conditional logic.

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

Use select to return only specific scalar fields and reduce payload size. Use include to load full related records; both support nesting, filtering, and _count for relation counts, but select and omit cannot be combined.