prisma-client-api

Use findMany with where 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 most recent 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 options like maxWait, timeout, and isolationLevel.

select returns only the specified scalar fields, while include adds full related records to the result. Both support nesting for relations, but select and omit cannot be used together on the same query.

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

Use relation filters in the where clause: some matches records with at least one matching relation, every requires all to match, and none requires zero matches. For one-to-one relations, use is and isNot.

Use findUniqueOrThrow when a missing record is an error condition, since it throws PrismaClientKnownRequestError instead of returning null. This is especially useful inside interactive transactions where the throw triggers a rollback.