# Prisma 5.0.0 — Release & Upgrade Intelligence
- **Product:** Prisma (https://prisma.io)
- **Version:** 5.0.0
- **Released:** Jul 11, 2023
- **Impact Score:** 7/10
- **Breaking Changes:** Source flagged
- **Canonical Analysis:** https://changelogs.us/prisma/updates/5.0.0/

## Executive Summary (TL;DR)
Prisma 5.0.0. Source highlight: We’re excited to share the `5.0.0` release today 🎉

## Breaking Changes & Deprecations
- As this is a major release, it includes a few breaking changes that might affect a small group of our users. Before upgrading, we recommend that you check out our [upgrade guide](https://www.prisma.io/docs/guides/upgrade-guides/upgrading-versions/upgrading-to-prisma-5) to understand the impact on your application.
- - General improvements and breaking changes - Dependency version changes - Minimum Node.js version change to 16.13.0
- We upgraded the embedded version of SQLite from 3.35.4 to 3.41.2. We do not anticipate any breaking changes or changes needed in projects using SQLite. However, if you’re using SQLite, especially with raw queries that might go beyond Prisma's functionality, make sure to check [the SQLite changelog](https://www.sqlite.org/changes.html).

## New Features
- Preview features moved to General Availability
- `fieldReference`: adds support for comparing columns of the same table.
- `extendedWhereUnique`: adds support for non-unique columns inside `where` clauses for queries that operate on unique records.
- **`--preview-feature`**: used in the `prisma db execute`, `prisma db seed`, and `prisma migrate diff` commands
- **`--experimental`** and **`--early-access-feature`**: used in the `prisma migrate` commands such as `prisma migrate dev`
- Full text search query with `OR` broke after opting in to `jsonProtocol` feature.

## Improvements
- `jsonProtocol`: improves communication between Prisma Client and the query engine, makes Prisma faster by default.
- General improvements and breaking changes

## Upgrade Command
```bash
npm install --save-dev --save-exact prisma@5.0.0
```