Today, we are excited to share the 5.13.0 stable release 🎉
🌟 Help us spread the word about Prisma by starring the repo or posting on X about the release.
Highlights
omit fields from Prisma Client queries (Preview)
We’re excited to announce Preview support for the omit option within the Prisma Client query options. The highly-requestedomit feature now allows you to exclude fields that you don’t want to retrieve from the database on a per-query basis.
By default, when a query returns records, the result includes all scalar fields of the models defined in the Prisma schema. select can be used to return specific fields, while omit can now be used to exclude specific fields. omit lives at the same API level and works on all of the same Prisma Client model queries as select. Note, however, that omit and select are mutually exclusive. In other words, you can’t use both in the same query.
To get started using omit, enable the omitApi Preview feature in your Prisma schema:
// Includes all fields except password
await prisma.user.findMany({
omit: {
password: true
},
})
Here is an example of using omit with include:
// Includes all user fields except user's password and title of user's posts
await prisma.user.findMany({
omit: {
password: true
},
include: {
posts: {
</tr></table>
... (truncated)
Commits
781ddb2 chore(deps): update engines to 5.13.0-23.b9a39a7ee606c28e3455d0fd60e78c3ba82b...
Today, we are excited to share the 5.13.0 stable release 🎉
🌟 Help us spread the word about Prisma by starring the repo or posting on X about the release.
Highlights
omit fields from Prisma Client queries (Preview)
We’re excited to announce Preview support for the omit option within the Prisma Client query options. The highly-requestedomit feature now allows you to exclude fields that you don’t want to retrieve from the database on a per-query basis.
By default, when a query returns records, the result includes all scalar fields of the models defined in the Prisma schema. select can be used to return specific fields, while omit can now be used to exclude specific fields. omit lives at the same API level and works on all of the same Prisma Client model queries as select. Note, however, that omit and select are mutually exclusive. In other words, you can’t use both in the same query.
To get started using omit, enable the omitApi Preview feature in your Prisma schema:
// Includes all fields except password
await prisma.user.findMany({
omit: {
password: true
},
})
Here is an example of using omit with include:
// Includes all user fields except user's password and title of user's posts
await prisma.user.findMany({
omit: {
password: true
},
include: {
posts: {
</tr></table>
... (truncated)
Commits
f73ba0f chore: new promo message in main help (#23918)
2c2e484 chore(deps): update dependency global-dirs to v4 (#23578)
Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.
Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR:
- `@dependabot rebase` will rebase this PR
- `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it
- `@dependabot merge` will merge this PR after your CI passes on it
- `@dependabot squash and merge` will squash and merge this PR after your CI passes on it
- `@dependabot cancel merge` will cancel a previously requested merge and block automerging
- `@dependabot reopen` will reopen this PR if it is closed
- `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
- `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency
- `@dependabot ignore major version` will close this group update PR and stop Dependabot creating any more for the specific dependency's major version (unless you unignore this specific dependency's major version or upgrade to it yourself)
- `@dependabot ignore minor version` will close this group update PR and stop Dependabot creating any more for the specific dependency's minor version (unless you unignore this specific dependency's minor version or upgrade to it yourself)
- `@dependabot ignore ` will close this group update PR and stop Dependabot creating any more for the specific dependency (unless you unignore this specific dependency or upgrade to it yourself)
- `@dependabot unignore ` will remove all of the ignore conditions of the specified dependency
- `@dependabot unignore ` will remove the ignore condition of the specified dependency and ignore conditions
Bumps the minor group with 3 updates in the /src/prisma/prismaservice directory: @prisma/client, @types/node and prisma.
Updates
@prisma/client
from 5.12.1 to 5.13.0Release notes
Sourced from
@prisma/client
's releases.... (truncated)
Commits
781ddb2
chore(deps): update engines to 5.13.0-23.b9a39a7ee606c28e3455d0fd60e78c3ba82b...cb7784e
chore: unexclude sqlite createMany tests (#23689)0e3f95f
feat: React Native support (#23637)183c14d
chore(deps): update engines to 5.13.0-22.3364458a783b65fd18b9ccc7fe4acfa87fba...47e2430
feat(client): Addomit
option to the queries (#23770)67d5034
chore(deps): update engines to 5.13.0-21.b339b9da56f3d53fccd4fb229effb0118721...cb7aa39
chore(deps): update engines to 5.13.0-16.6d35870e9578a3e7406168f61f89f84e78c1...e2d1906
chore(deps): update engines to 5.13.0-15.8b36be322cc78c7e156e98b8966fb34e5ea0...0e209dc
chore(deps): update dependency wrangler to v3.49.0 (#23821)4954f35
chore(deps): update dependency@types/node
to v16.18.96 (#23801)Updates
@types/node
from 20.12.7 to 20.12.10Commits
Updates
prisma
from 5.12.1 to 5.13.0Release notes
Sourced from prisma's releases.
... (truncated)
Commits
f73ba0f
chore: new promo message in main help (#23918)2c2e484
chore(deps): update dependency global-dirs to v4 (#23578)523f386
chore(deps): update definitelytyped (#23800)89dda02
test: Fix jest snapshot drifts (#23735)1a4f361
perf(cli): CLI startup time improvement (#23622)c93714a
fix(migrate): fix --from/to-local-d1 & --local-d1 on Windows (#23700) #23725 ...cb9ce14
chore(deps): update studio to 0.500.0 (#23686)6e3b532
chore(deps): update dependency ts-pattern to v5.1.0 (#23677)5d6f5f4
chore(deps): update devdependencies patch (non-major) (#23552)891d47b
chore(deps): update dependency esbuild to v0.20.2 (#23551)Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting
@dependabot rebase
.Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show