sql
SELECT "Post"."id", "Post"."title", "Post"."userId" FROM "Post" WHERE ("Post"."id" = $1 AND 1=1) LIMIT $2 OFFSET $3
SELECT "User"."id" FROM "User" WHERE (1=1 AND "User"."id" IN ($1)) OFFSET $2
SELECT "User"."id", "User"."commentId" FROM "User" WHERE ("User"."id" = $1 AND 1=1) LIMIT $2 OFFSET $3
SELECT "Comment"."id" FROM "Comment" WHERE (1=1 AND "Comment"."id" IN ($1)) OFFSET $2
UPDATE "Comment" SET "body" = $1 WHERE ("Comment"."id" = $2 AND 1=1) RETURNING "Comment"."id"
SELECT "Post"."id", "Post"."title" FROM "Post" WHERE "Post"."id" = $1 LIMIT $2 OFFSET $3
Fixes and improvements
Prisma Client
- [CFW: Avoid including Query Engine when data proxy is enabled](https://github.com/prisma/prisma/issues/9597)
- [Local Prisma Studio does not work with Data Proxy](https://github.com/prisma/prisma/issues/12734)
- [Postinstall hook always generates non Data Proxy Prisma Client](https://github.com/prisma/prisma/issues/13608)
- [`limit` is gone when `findUnique` with include relation ](https://github.com/prisma/prisma/issues/14499)
- [`Cannot fetch data from service: include is not a function` Error while using Next.js with Data Proxy](https://github.com/prisma/prisma/issues/15395)
- [`take` key doesn't work correctly for nested query that returns one item with its nested children](https://github.com/prisma/prisma/issues/15623)
- [Prisma Client Edge: environment variables are not working with the "new" Module Worker syntax for Cloudflare Workers](https://github.com/prisma/prisma/issues/15958)
- [Add documentation to "PrismaClient is unable to be run in the browser"](https://github.com/prisma/prisma/issues/16153)
- [Change how Data Proxy Client deals with unsupported preview features](https://github.com/prisma/prisma/issues/17796)
- [Custom Prisma Client output location breaks Prisma Data Proxy in NextJS](https://github.com/prisma/prisma/issues/18227)
- [GetPayload type error since 4.16.1 "Two different types with this name exist, but they are unrelated."](https://github.com/prisma/prisma/issues/20422)
- [Browser bundle: Unhandled Runtime Error when upgrading to 5.1.0 from 5.0.0 ](https://github.com/prisma/prisma/issues/20480)
- [Prisma Client: `disconnect: true` does not appear to delete the foreign key in the returned data](https://github.com/prisma/prisma/issues/20491)
- [Prisma Client errors with "TypeError: Cannot create proxy with a non-object as target or handler" when using result client extension with no `needs` and `count` method](https://github.com/prisma/prisma/issues/20499)
- [Upgrading from Prisma 5.0.0 -> 5.1.0 results in "TS2321: Excessive stack depth comparing types" error using `mockDeep<PrismaClient>()`](https://github.com/prisma/prisma/issues/20516)
- [Unnecessary reads for to-one nested updates](https://github.com/prisma/prisma/issues/20556)
- [Better error message if `prisma/client/edge` can not find environment variable](https://github.com/prisma/prisma/issues/20589)
- [5.1: Alias for old name for `<Model>CountOutputTypeDefaultArgs` does not exist](https://github.com/prisma/prisma/issues/20614)
- [Incorrect pagination for nested m2m chunked reads](https://github.com/prisma/prisma/issues/20624)
Prisma Migrate
- [RustPanic on `prisma generate` when Unsupported field defined in a Composite type](https://github.com/prisma/prisma/issues/19694)
- [Use PostgreSQL System Information Functions instead of manually joining fields](https://github.com/prisma/prisma/issues/19935)
- [Duplicate expression index comment whenever db pull is run](https://github.com/prisma/prisma/issues/20386)
Credits
Huge thanks to skyzh, alula, michaelpoellath, RobertCraigie, darthmaim, Gerschtli, andyjy, mejiaej, iurylippo, mrazauskas, coder246, RDIL for helping!