prisma-client-api

Use findMany with a where clause for filters, orderBy for sorting, and take with skip or cursor for pagination. Filter operators include equals, contains, gt, lt, in, and logical operators AND, OR, NOT.

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

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

select returns only the specified scalar fields, while include adds full related records to the result. You can nest select inside include or vice versa, but select and omit cannot be used together on the same query.

Next.js hot reloading creates multiple PrismaClient instances that exhaust database connections. Use the singleton pattern that caches the client on globalThis in development so only one instance persists across reloads.