prisma-client-api

Use prisma.model.findMany with a where clause for filters, orderBy for sorting, and take with skip or cursor for pagination. For example, pass where: { role: 'ADMIN' }, orderBy: { createdAt: 'desc' }, and take: 10 to get the ten newest admins.

Use prisma.$transaction with an array for independent sequential operations, or pass an async function for interactive transactions where later operations depend on earlier results. Interactive transactions accept maxWait, timeout, and isolationLevel options.

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

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.

Relation filters require the correct operator for the relation cardinality: some, every, or none for to-many relations, and is or isNot for one-to-one relations. Using a scalar operator on a relation field causes a validation error.