7.5.0
📦 prismaView on GitHub →
✨ 9 features🐛 7 fixes🔧 7 symbols
Summary
Version 7.5.0 introduces support for nested transaction rollbacks via savepoints in the ORM and significantly enhances Prisma Studio with features like multi-cell selection, full table search, raw SQL execution, and a command palette. Several bug fixes address issues related to database adapters, date serialization, and partial index handling.
Migration Steps
- For users of `adapter-pg`, ensure `@types/pg` is listed as a direct dependency if you rely on the TypeScript experience provided by the adapter.
✨ New Features
- Added support for nested transaction rollbacks via savepoints for SQL databases, enabling rollback of inner transactions when an outer one fails.
- Prisma Client now tracks transaction ID + nesting depth to reuse existing open transactions in the underlying engine.
- Enables using `$transaction` from an interactive transaction client.
- Prisma Studio now supports multi-cell selection when viewing database data.
- Prisma Studio now supports full table search across the database.
- Prisma Studio filtering is more intuitive and includes an option for raw SQL filters.
- Prisma Studio in Console supports AI-generated filters.
- Prisma Studio introduced a Cmd+k command palette for keyboard navigation.
- Prisma Studio now allows running raw SQL queries via a new “SQL” tab in the sidebar.
🐛 Bug Fixes
- The `adapter-mariadb` now uses the binary MySQL protocol to fix lossy number conversions.
- Resolved `Prisma.DbNull` serializing as an empty object in some bundled environments like Next.js.
- Fixed DateTime fields returning `Invalid Date` when using `unixepoch-ms` timestamps in certain scenarios.
- Fixed a cursor-based pagination issue when using `@db.Date` columns.
- Manual partial indexes are now preserved when the `partialIndexes` preview feature is disabled, preventing unnecessary drops and additions during migrations.
- Enhanced partial index predicate comparison to correctly handle quoted vs unquoted identifiers, eliminating needless recreation cycles.
- Excluded partial unique indexes from DMMF `uniqueFields` and `uniqueIndexes` to prevent incorrect `findUnique` input type generation.