Prisma Client & Prisma schema
Source URL: https://docs.prisma.io/docs/orm/reference/preview-features/client-preview-features
Prisma Client & Prisma schema
Section titled “Prisma Client & Prisma schema”Prisma Client and Prisma schema features that are currently in Preview
When we release a new Prisma Client or Prisma schema feature, it often starts in Preview so that you can test it and submit your feedback. After we improve the feature with your feedback and are satisfied with the internal test results, we promote the feature to general availability.
For more information, see ORM releases and maturity levels.
Currently active Preview features
Section titled “Currently active Preview features”The following Preview feature flags are available for Prisma Client and Prisma schema:
| Feature | Released into Preview | Feedback issue |
|---|---|---|
views | 4.9.0 | Submit feedback |
relationJoins | 5.7.0 | Submit feedback |
nativeDistinct | 5.7.0 | Submit feedback |
typedSql | 5.19.0 | Submit feedback |
strictUndefinedChecks | 5.20.0 | Submit feedback |
fullTextSearchPostgres | 6.0.0 | Submit feedback |
shardKeys | 6.10.0 | Submit feedback |
partialIndexes | 7.4.0 | Submit feedback |
To enable a Preview feature, add the feature flag to the generator block in your schema.prisma file. Share your feedback on all Preview features on GitHub.
Enabling a Prisma Client Preview feature
Section titled “Enabling a Prisma Client Preview feature”To enable a Prisma Client Preview feature:
- Add the Preview feature flag to the
generatorblock:
generator client { provider = "prisma-client" output = "./generated" previewFeatures = ["relationJoins"] }- Re-generate Prisma Client:
npm
pnpm
yarn
bun
npx prisma generate- If you are using Visual Studio Code and the Preview feature is not available in your
.tsfile after generating Prisma Client, run the TypeScript: Restart TS server command.
Preview features promoted to General Availability
Section titled “Preview features promoted to General Availability”In the list below, you can find a history of Prisma Client and Prisma schema features that were in Preview and are now in general availability. The features are sorted by the most recent version in which they were promoted to general availability.
| Feature | Released into Preview | Released into General Availability |
|---|---|---|
driverAdapters | 5.4.0 | 6.16.0 |
multiSchema | 4.3.0 | 6.13.0 |
prismaSchemaFolder | 5.15.0 | 6.7.0 |
omitApi | 5.13.0 | 6.2.0 |
jsonProtocol | 4.11.0 | 5.0.0 |
extendedWhereUnique | 4.5.0 | 5.0.0 |
fieldReference | 4.3.0 | 5.0.0 |
clientExtensions | 4.7.0 | 4.16.0 |
filteredRelationCount | 4.3.0 | 4.16.0 |
tracing | 4.2.0 | 6.1.0 |
orderByNulls | 4.1.0 | 4.16.0 |
referentialIntegrity | 3.1.1 | 4.7.0 |
interactiveTransactions | 2.29.0 | 4.7.0 |
with Prisma Accelerate 5.1.1
extendedIndexes| 3.5.0| 4.0.0
filterJson| 2.23.0| 4.0.0
improvedQueryRaw| 3.14.0| 4.0.0
cockroachdb| 3.9.0
migrations in 3.11.0| 3.14.0
mongodb| 2.27.0
introspection in 3.2.0
embedded docs in 3.4.0
raw queries in 3.9.0
filters/ordering in embedded docs in 3.11.0| 3.12.0
microsoftSqlServer| 2.10.0| 3.0.1
namedConstraints| 2.29.0| 3.0.1
referentialActions| 2.26.0| 3.0.1
orderByAggregateGroup| 2.21.0| 3.0.1
orderByRelation| 2.16.0
aggregates in 2.19.0| 3.0.1
selectRelationCount| 2.20.0| 3.0.1
napi| 2.20.0| 3.0.1
groupBy| 2.14.0| 2.20.0
createMany| 2.16.0| 2.20.0
nativeTypes| 2.11.0| 2.17.0
uncheckedScalarInputs| 2.11.0| 2.15.0
transactionApi| 2.1.0| 2.11.0
connectOrCreate| 2.1.0| 2.11.0
atomicNumberOperations| 2.6.0| 2.10.0
insensitiveFilters (PostgreSQL)| 2.5.0| 2.8.0
aggregateApi| 2.2.0| 2.5.0
distinct| 2.3.0| 2.5.0