prisma-client-api

Use prisma.model.findMany with where for filters, orderBy for sorting, and take/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 with tagged template literals parameterizes interpolated values automatically, preventing injection. Avoid $queryRawUnsafe with string concatenation of user input, and use Prisma.raw only for trusted identifiers like column names.

Use relation filters some, every, and none for to-many relations, and is/isNot for to-one relations. For example, where: { posts: { some: { published: true } } } returns users having at least one published post.

Use upsert when a record may already exist and you want to update it or create it otherwise, keyed by a unique field. It takes where, update, and create arguments, avoiding separate existence checks and race conditions.