prisma-client-api

Use the where option with filter operators like equals, contains, gt, lt, in, and logical operators AND, OR, NOT. Combine multiple conditions for precise filtering, and use relation filters like some, every, and none for related records.

Prisma supports sequential transactions via an array passed to $transaction, and interactive transactions via an async callback receiving a transaction-scoped client. Interactive transactions support conditional logic, rollback on thrown errors, and options like maxWait, timeout, and isolationLevel.

Yes, use $queryRaw for SELECT queries with typed results and $executeRaw for INSERT, UPDATE, or DELETE returning affected counts. Template literals parameterize values automatically to prevent SQL injection; avoid $queryRawUnsafe with untrusted input.

select returns only the specified scalar fields and relations, while include adds all scalar fields plus the specified relations. You cannot combine select and omit in the same query, but include can be nested inside select for fine-grained control.

The SQL provider workflow requires passing a driver adapter such as PrismaPg with a connectionString to the PrismaClient constructor. The adapter handles the actual database connection, and the client can also be configured with logging, errorFormat, and transaction defaults.