chore(deps): bump prisma from 4.16.2 to 5.19.0

[dependabot[bot]]

Bumps prisma from 4.16.2 to 5.19.0.

Release notes

Sourced from prisma's releases.

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 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:

   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:

      import { PrismaClient } from '@prisma/client'
      import { getUsersWithPosts } from '@prisma/client/sql'
   

... (truncated)

Commits

• 8957496 feat(client): Typed SQL (#24907)
• f3856a9 chore(deps): update devdependencies patch (non-major) (#24813)
• ce552f3 feat(cli): remove Optimize specific login in Platform CLI (#25036)
• 26c8d91 feat(cli): Chokidar-based watch (#24983)
• cebc9c0 feat: Added a tip to remove tips (#24818)
• b58adc8 fix(client): Correctly resolve configDir when prismaSchemaFolder is used ...
• a15d3b9 feat(cli, generate command): Added promo array to rotate and make cli messagi...
• 7308378 feat(cli): Support prisma platform auth show --sensitive (#24745)
• 190bac1 chore(cli): cleanup import message when running generate (#24739)
• 1cc5cb0 fix(cli): restored prisma generate --allow-no-models after regression (#24741)
• Additional commits viewable in compare view

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 this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

[vercel[bot]]

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

Name	Status	Preview	Comments	Updated (UTC)
revert-client	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Sep 2, 2024 5:27am
revert-next	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Sep 2, 2024 5:27am

[github-actions[bot]]

Thank you for following the naming conventions for pull request titles! 🙏

[dependabot[bot]]

Superseded by #619.