Update prisma monorepo to v5.21.1

[renovate[bot]]

This PR contains the following updates:

Package	Change	Age	Adoption	Passing	Confidence
@prisma/client (source)	5.16.0 -> 5.21.1
prisma (source)	5.16.0 -> 5.21.1

---

Release Notes

prisma/prisma (@​prisma/client)

### [`v5.21.1`](https://redirect.github.com/prisma/prisma/releases/tag/5.21.1) [Compare Source](https://redirect.github.com/prisma/prisma/compare/5.21.0...5.21.1) - Fixed a bug where migrations were not using shadow database correctly in some edge cases ### [`v5.21.0`](https://redirect.github.com/prisma/prisma/releases/tag/5.21.0) [Compare Source](https://redirect.github.com/prisma/prisma/compare/5.20.0...5.21.0) Today, we are excited to share the `5.21.0` release 🎉 🌟 **Help us spread the word about Prisma by starring the repo ☝️ or [posting on X](https://twitter.com/intent/tweet?text=Check%20out%20the%20latest%20@​prisma%20release%20v5.21.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/5.21.0) about the release.** ##### Highlights ##### Better support for tracing in MongoDB The `tracing` Preview feature now has full support for MongoDB with previously missing functionality now implemented. This is a part of the ongoing effort to stabilize this Preview feature and release it in General Availability. `tracing` is a Preview feature that enables built-in support for OpenTelemetry instrumentation inside the Prisma Client and provides deep insights into the performance and timing of your queries. See our [documentation for more information](https://www.prisma.io/docs/orm/prisma-client/observability-and-logging/opentelemetry-tracing). For an easy to use and zero-configuration tracing instrumentation tool with a dashboard that provides an overview of your queries, statistics, and AI-powered recommendations, try [Prisma Optimize](https://pris.ly/gh/optimize). ##### WebAssembly engine size decrease for edge functions Due to recent changes, some users experienced a steep increase of the bundle size in Prisma 5.20 when using [the `driverAdapters` Preview feature](https://www.prisma.io/docs/orm/overview/databases/database-drivers#driver-adapters), going over the 1 MB limit on the free tier of Cloudflare Workers. This has now been fixed. ##### Fixes and improvements ##### Prisma Engines - [Avoid regex crate for wasm bundle size (to keep cloudflare free plan)](https://redirect.github.com/prisma/prisma-engines/issues/5008) ##### Credits Huge thanks to [@​austin-tildei](https://redirect.github.com/austin-tildei), [@​LucianBuzzo](https://redirect.github.com/LucianBuzzo), [@​mcuelenaere](https://redirect.github.com/mcuelenaere), [@​pagewang0](https://redirect.github.com/pagewang0), [@​key-moon](https://redirect.github.com/key-moon), [@​pranayat](https://redirect.github.com/pranayat), [@​yubrot](https://redirect.github.com/yubrot), [@​skyzh](https://redirect.github.com/skyzh) for helping! ### [`v5.20.0`](https://redirect.github.com/prisma/prisma/releases/tag/5.20.0) [Compare Source](https://redirect.github.com/prisma/prisma/compare/5.19.1...5.20.0) 🌟 **Help us spread the word about Prisma by starring the repo or [posting on X](https://twitter.com/intent/tweet?text=Check%20out%20the%20latest%20@​prisma%20release%20v5.20.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/5.20.0) about the release.** 🌟 ##### Highlights ##### `strictUndefinedChecks` in Preview With Prisma ORM 5.20.0, the Preview feature `strictUndefinedChecks` will disallow any value that is explicitly `undefined` and will be a runtime error. This change is direct feedback from [this GitHub issue](https://redirect.github.com/prisma/prisma/issues/20169) and follows [our latest proposal](https://redirect.github.com/prisma/prisma/issues/20169#issuecomment-2338360300) on the same issue. To demonstrate the change, take the following code snippet: ```tsx prisma.table.deleteMany({ where: { // If `nullableThing` is nullish, this query will remove all data. email: nullableThing?.property, } }) ``` In Prisma ORM 5.19.0 and below, this could result in unintended behavior. In Prisma ORM 5.20.0, if the `strictUndefinedChecks` Preview feature is enabled, you will get a runtime error instead: ```tsx Invalid \`prisma.user.findMany()\` invocation in /client/tests/functional/strictUndefinedChecks/test.ts:0:0 XX }) XX XX test('throws on undefined input field', async () => { → XX const result = prisma.user.deleteMany({ where: { email: undefined ~~~~~~~~~ } }) Invalid value for argument \`where\`: explicitly \`undefined\` values are not allowed." ``` We have also introduced the `Prisma.skip` symbol, which will allow you to get the previous behavior if desired. ```tsx prisma.table.findMany({ where: { // Use Prisma.skip to skip parts of the query email: nullableEmail ?? Prisma.skip } }) ``` From Prisma ORM 5.20.0 onward, we recommend enabling `strictUndefinedChecks`, along with the TypeScript compiler option `exactOptionalPropertyTypes`, which will help catch cases of undefined values at compile time. Together, these two changes will help protect your Prisma queries from potentially destructive behavior. `strictUndefinedChecks` will be a valid Preview feature for the remainder of Prisma ORM 5. With our next major version, this behavior will become the default and the Preview feature will be “graduated” to Generally Available. If you have any questions or feedback about `strictUndefinedChecks`, please ask/comment in our dedicated [Preview feature GitHub discussion](https://redirect.github.com/prisma/prisma/discussions/25271). ##### `typedSql` bug fix Thank you to everyone who has tried out our [`typedSql` Preview feature](https://www.prisma.io/blog/announcing-typedsql-make-your-raw-sql-queries-type-safe-with-prisma-orm) and [provided feedback](https://redirect.github.com/prisma/prisma/discussions/25106)! This release has a quick fix for typescript files generated when Prisma Schema enums had hyphens. ##### Fixes and improvements ##### Prisma - [Prisma incorrectly parses CRDB's FK constraint error as `not available`.](https://redirect.github.com/prisma/prisma/issues/24072) - [Invalid TypeScript files created by `generate` when typedSql is enabled and enum contains hyphens.](https://redirect.github.com/prisma/prisma/issues/25163) - [`@prisma/internals` didn't list `ts-toolbelt` in dependencies.](https://redirect.github.com/prisma/prisma/issues/17952) - [using `$extends` prevents model comments from being passed to TypeScript](https://redirect.github.com/prisma/prisma/issues/24648) ##### Prisma Engines - [Planetscale engine tests: interactive_tx](https://redirect.github.com/prisma/prisma-engines/issues/4469) - [Fix broken engine size publishing workflow](https://redirect.github.com/prisma/prisma-engines/issues/4991) ##### Credits Huge thanks to [@​mcuelenaere](https://redirect.github.com/mcuelenaere), [@​pagewang0](https://redirect.github.com/pagewang0), [@​key-moon](https://redirect.github.com/key-moon), [@​pranayat](https://redirect.github.com/pranayat), [@​yubrot](https://redirect.github.com/yubrot), [@​thijmenjk](https://redirect.github.com/thijmenjk), [@​mydea](https://redirect.github.com/mydea), [@​HRM](https://redirect.github.com/HRM), [@​haaawk](https://redirect.github.com/haaawk), [@​baileywickham](https://redirect.github.com/baileywickham), [@​brian-dlee](https://redirect.github.com/brian-dlee), [@​nickcarnival](https://redirect.github.com/nickcarnival), [@​eruditmorina](https://redirect.github.com/eruditmorina), [@​nzakas](https://redirect.github.com/nzakas), and [@​gutyerrez](https://redirect.github.com/gutyerrez) for helping! ### [`v5.19.1`](https://redirect.github.com/prisma/prisma/releases/tag/5.19.1) [Compare Source](https://redirect.github.com/prisma/prisma/compare/5.19.0...5.19.1) Today, we are issuing the `5.19.1` patch release. #### What's Changed We've fixed the following issues: - [https://github.com/prisma/prisma/issues/25103](https://redirect.github.com/prisma/prisma/issues/25103) - [https://github.com/prisma/prisma/issues/25137](https://redirect.github.com/prisma/prisma/issues/25137) - [https://github.com/prisma/prisma/issues/25104](https://redirect.github.com/prisma/prisma/issues/25104) - [https://github.com/prisma/prisma/issues/25101](https://redirect.github.com/prisma/prisma/issues/25101) **Full Changelog**: https://github.com/prisma/prisma/compare/5.19.0...5.19.x, https://github.com/prisma/prisma-engines/compare/5.19.0...5.19.x ### [`v5.19.0`](https://redirect.github.com/prisma/prisma/releases/tag/5.19.0) [Compare Source](https://redirect.github.com/prisma/prisma/compare/5.18.0...5.19.0) Today, we are excited to share the `5.19.0` stable release 🎉 🌟 **Help us spread the word about Prisma by starring the repo or [posting on X](https://twitter.com/intent/tweet?text=Check%20out%20the%20latest%20@​prisma%20release%20v5.19.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/5.19.0) about the release.** 🌟 #### Highlights ##### Introducing TypedSQL TypedSQL is a brand new way to interact with your database from Prisma Client. After enabling the `typedSql` Preview feature, you’re able to write SQL queries in a new `sql` subdirectory of your `prisma` directory. These queries are then checked by Prisma during using the new `--sql` flag of `prisma generate` and added to your client for use in your code. To get started with TypedSQL: 1. Make sure that you have the latest version of `prisma` and `@prisma/client` installed: npm install -D prisma@latest npm install @​prisma/client@latest 2. Enable the `typedSql` Preview feature in your Prisma Schema. generator client { provider = "prisma-client-js" previewFeatures = ["typedSql"] } 3. Create a `sql` subdirectory of your `prisma` directory. mkdir -p prisma/sql 4. You can now add `.sql` files to the `sql` directory! Each file can contain one sql query and the name must be a valid JS identifier. For this example, say you had the file `getUsersWithPosts.sql` with the following contents: ```sql SELECT u.id, u.name, COUNT(p.id) as "postCount" FROM "User" u LEFT JOIN "Post" p ON u.id = p."authorId" GROUP BY u.id, u.name ``` 5. Import your SQL query into your code with the `@prisma/client/sql` import: ```tsx import { PrismaClient } from '@​prisma/client' import { getUsersWithPosts } from '@​prisma/client/sql' const prisma = new PrismaClient() const usersWithPostCounts = await prisma.$queryRawTyped(getUsersWithPosts) console.log(usersWithPostCounts) ``` There’s a lot more to talk about with TypedSQL. We think that the combination of the high-level Prisma Client API and the low-level TypedSQL will make for a great developer experience for all of our users. To learn more about behind the “why” of TypedSQL [be sure to check out our announcement blog post](https://pris.ly/typedsql-blog). For docs, check out our new [TypedSQL section](https://pris.ly/d/typedsql). #### Bug fixes ##### Driver adapters and D1 A few issues with our `driverAdapters` Preview feature and Cloudflare D1 support were resolved via [https://github.com/prisma/prisma-engines/pull/4970](https://redirect.github.com/prisma/prisma-engines/pull/4970) and [https://github.com/prisma/prisma/pull/24922](https://redirect.github.com/prisma/prisma/pull/24922) - Mathematic operations such as `max`, `min`, `eq`, etc in queries when using Cloudflare D1. - Resolved issues when comparing `BigInt` IDs when `relationMode="prisma"` was enabled and Cloudflare D1 was being used. ##### Joins - [https://github.com/prisma/prisma/issues/23742](https://redirect.github.com/prisma/prisma/issues/23742) fixes Prisma Client not supporting deeply nested `some` clauses when the `relationJoins` Preview feature was enabled. #### Join us Looking to make an impact on Prisma in a big way? We're now hiring engineers for the ORM team! - [Senior Engineer (TypeScript)](https://boards.greenhouse.io/prisma/jobs/5350820002): This person will be primarily working on the TypeScript side and evolving our Prisma client. Rust knowledge (or desire to learn Rust) is a plus. - [Senior Engineer (Rust)](https://boards.greenhouse.io/prisma/jobs/6940273002): This person will be focused on the `prisma-engines` Rust codebase. TypeScript knowledge (or, again, a desire to learn) is a plus. #### Credits Huge thanks to [@​mcuelenaere](https://redirect.github.com/mcuelenaere), [@​pagewang0](https://redirect.github.com/pagewang0), [@​Druue](https://redirect.github.com/Druue), [@​key-moon](https://redirect.github.com/key-moon), [@​Jolg42](https://redirect.github.com/Jolg42), [@​pranayat](https://redirect.github.com/pranayat), [@​ospfranco](https://redirect.github.com/ospfranco), [@​yubrot](https://redirect.github.com/yubrot), [@​skyzh](https://redirect.github.com/skyzh) for helping! ### [`v5.18.0`](https://redirect.github.com/prisma/prisma/releases/tag/5.18.0) [Compare Source](https://redirect.github.com/prisma/prisma/compare/5.17.0...5.18.0) 🌟 **Help us spread the word about Prisma by starring the repo or [tweeting](https://twitter.com/intent/tweet?text=Check%20out%20the%20latest%20@​prisma%20release%20v5.18.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/5.18.0) about the release.** 🌟 ##### Highlights ##### Native support for UUIDv7 Previous to this release, the Prisma Schema function `uuid()` did not accept any arguments and created a UUIDv4 ID. While sufficient in many cases, UUIDv4 has a few drawbacks, namely that it is not temporally sortable. UUIDv7 attempts to resolve this issue, making it easy to temporally sort your database rows by ID! To support this, we’ve updated the `uuid()` function in Prisma Schema to accept an optional, integer argument. Right now, the only valid values are `4` and `7`, with `4` being the default. ```tsx model User { id String @​id @​default(uuid()) // defaults to 4 name String } model User { id String @​id @​default(uuid(4)) // same as above, but explicit name String } model User { id String @​id @​default(uuid(7)) // will use UUIDv7 instead of UUIDv4 name String } ``` ##### Bug squashing We’ve squashed a number of bugs this release, special thanks to everyone who helped us! A few select highlights are: - [SQLite db will now be created and read from the correct location when using `prismaSchemaFolder`](https://redirect.github.com/prisma/prisma/issues/24779). - [Empty `Json[]` fields will now return `[]` instead of `null` when accessed through a join using the `relationJoins` Preview feature.](https://redirect.github.com/prisma/prisma/issues/22923) ##### Fixes and improvements ##### Prisma - [Support UUID v7](https://redirect.github.com/prisma/prisma/issues/24079) ##### Language tools (e.g. VS Code) - [Support fetching references for a model](https://redirect.github.com/prisma/language-tools/issues/982) ##### Credits Huge thanks to [@​mcuelenaere](https://redirect.github.com/mcuelenaere), [@​pagewang0](https://redirect.github.com/pagewang0), [@​Druue](https://redirect.github.com/Druue), [@​key-moon](https://redirect.github.com/key-moon), [@​Jolg42](https://redirect.github.com/Jolg42), [@​pranayat](https://redirect.github.com/pranayat), [@​ospfranco](https://redirect.github.com/ospfranco), [@​yubrot](https://redirect.github.com/yubrot), [@​skyzh](https://redirect.github.com/skyzh), [@​haaawk](https://redirect.github.com/haaawk) for helping! ### [`v5.17.0`](https://redirect.github.com/prisma/prisma/releases/tag/5.17.0) [Compare Source](https://redirect.github.com/prisma/prisma/compare/5.16.2...5.17.0) 🌟 **Help us spread the word about Prisma by starring the repo or [tweeting](https://twitter.com/intent/tweet?text=Check%20out%20the%20latest%20@​prisma%20release%20v5.17.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/5.17.0) about the release.** 🌟 ##### Highlights ##### VSCode extension improvements We’re happy to introduce some cool new features that will make your experience with the Prisma VSCode extension even better! **Find references across schema files** The ability to hop between references of a given symbol is really useful in application code and now with the introduction of multi-file schema, we think it’s the perfect time to bring this feature to the VSCode extension! With the 5.17.0 release, you’ll now have the ability to use the native “find references” feature to find any usage of a given symbol  **Added context on hover** When hovering over a symbol that references a view, type, enum, or any other block with multiple values, you’ll now see a handy pop out that shows what is in that block at a glance.  **Additional quick fixes** We’ve taken some fixes made by the `prisma format` cli command and made them quick fixes available to the VSCode Extension. Now, when you have forget a back relation or relation scalar field, you’ll now see in real time what is wrong and have the option to fix it via the extension.  ##### QueryRaw performance improvements We’ve changed the response format of `queryRaw` to decrease its average size which reduces serialization CPU overhead. When querying large data sets, we expect you to see improved memory usage and up to 2x performance improvements. ##### Fixes and improvements ##### Prisma Client - [Remove or change `This is the 10th instance of Prisma Client being started. Make sure this is intentional.` warning](https://redirect.github.com/prisma/prisma/issues/23736) ##### Prisma - [Prisma generate option --allow-no-models doesn't work.](https://redirect.github.com/prisma/prisma/issues/24737) ##### Language tools (e.g. VS Code) - [LSP Rename incorrectly maps field name and appends character](https://redirect.github.com/prisma/language-tools/issues/1771) ##### Credits Huge thanks to [@​key-moon](https://redirect.github.com/key-moon), [@​pranayat](https://redirect.github.com/pranayat), [@​yubrot](https://redirect.github.com/yubrot), [@​skyzh](https://redirect.github.com/skyzh) for helping! ### [`v5.16.2`](https://redirect.github.com/prisma/prisma/releases/tag/5.16.2) [Compare Source](https://redirect.github.com/prisma/prisma/compare/5.16.1...5.16.2) Today, we are issuing the 5.16.2 patch release to fix an issue in Prisma client. #### Fix in Prisma Client - [nextjs app deployed to vercel edge can't import prisma WASM modul ](https://redirect.github.com/prisma/prisma/issues/24673) ### [`v5.16.1`](https://redirect.github.com/prisma/prisma/releases/tag/5.16.1) [Compare Source](https://redirect.github.com/prisma/prisma/compare/5.16.0...5.16.1) Today, we are issuing the 5.16.1 patch release to fix an issue in Prisma client. #### Fix in Prisma Client - [dotenv loading issue with PrismaClient ](https://redirect.github.com/prisma/prisma/issues/24634) - [Prisma Seed Script Fails After Upgrading to v5.16.0 (DATABASE_URL Error)](https://redirect.github.com/prisma/prisma/issues/24658)

---

Configuration

📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).

🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.

♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.

🔕 Ignore: Close this PR and you won't be reminded about these updates again.

---

• [ ] If you want to rebase/retry this PR, check this box

---

This PR was generated by Mend Renovate. View the repository job log.

[cr-gpt[bot]]

Seems you are using me but didn't get OPENAI_API_KEY seted in Variables/Secrets for this repo. you could follow readme for more information

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
solid-space	❌ Failed (Inspect)			Oct 17, 2024 5:52pm

[cr-gpt[bot]]

Seems you are using me but didn't get OPENAI_API_KEY seted in Variables/Secrets for this repo. you could follow readme for more information

[cr-gpt[bot]]

Seems you are using me but didn't get OPENAI_API_KEY seted in Variables/Secrets for this repo. you could follow readme for more information