Prisma ORM v7.5.0: nested transaction savepoints and Studio updates

ORM

Nested transaction rollbacks via savepoints

Prisma ORM v7.5.0 adds support for nested transaction rollback behavior for SQL databases through savepoints.

This lets Prisma track transaction ID and nesting depth so it can reuse an existing open transaction in the underlying engine. It also enables using $transaction from an interactive transaction client while making sure inner nested transactions are rolled back when the outer transaction fails.

#21678: Added support for nested transaction rollbacks via savepoints

Bug fixes

Driver Adapters

#29285: adapter-mariadb now uses the binary MySQL protocol to fix lossy number conversions
#29277: Made @types/pg a direct dependency of adapter-pg for a better TypeScript experience

Prisma Client

#29286: Resolved Prisma.DbNull serializing as an empty object in some bundled environments like Next.js
#29274: Fixed DateTime fields returning Invalid Date with unixepoch-ms timestamps in some cases
#29327: Fixed a cursor-based pagination issue with @db.Date columns

Schema Engine

#5790, #5795: Preserve manual partial indexes when the partialIndexes preview feature is disabled
#5788: Improve partial index predicate comparison for quoted vs unquoted identifiers
#5792: Exclude partial unique indexes from DMMF uniqueFields and uniqueIndexes

Studio

Prisma Studio continues to gain features in v7.5.0 based on feedback since the Prisma ORM v7 launch.

Multi-cell selection and full table search

You can now select multiple cells while viewing your database, and you can search across a table for specific values in addition to finding a specific table.