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:
Make sure that you have the latest version of prisma and @prisma/client installed:
Create a sql subdirectory of your prisma directory.
mkdir -p prisma/sql
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
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
0f63437 chore(deps): update engines to 5.19.0-31.5fe21811a6ba0b952a3bc71400666511fe3b...
a411e43 chore(deps): update engines to 5.19.0-30.de1356e7b79f44aaa2d308a544c32a4d2951...
1ff458a chore(deps): update engines to 5.19.0-27.0bc306ebdcdb88c93b6fd25d43855afc7e4f...
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)
Bumps @prisma/client from 5.17.0 to 5.19.0.
Release notes
Sourced from
@prisma/client
's releases.... (truncated)
Commits
0f63437
chore(deps): update engines to 5.19.0-31.5fe21811a6ba0b952a3bc71400666511fe3b...a411e43
chore(deps): update engines to 5.19.0-30.de1356e7b79f44aaa2d308a544c32a4d2951...1ff458a
chore(deps): update engines to 5.19.0-27.0bc306ebdcdb88c93b6fd25d43855afc7e4f...8957496
feat(client): Typed SQL (#24907)2afa20b
chore(deps): update engines to 5.19.0-26.8a3982b39f6dc8065ba99a0d212b3e18a5cd...f3856a9
chore(deps): update devdependencies patch (non-major) (#24813)2d27e8c
chore(deps): update engines to 5.19.0-23.c356d1b4064663e128504e183e2b0cbe5fcd...78cbbfd
chore(deps): update engines to 5.19.0-19.cb8fbf23062d1b8788a70d0d0cd3d2e0bd6e...b28fa63
chore(deps): update engines to 5.19.0-12.ae18f9165678fc6c7b7b107340ca0435be43...3b585cc
chore(deps): update engines to 5.19.0-8.44f753d2ce0008a24ce36e34aff65a5afe266...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