Prisma 2.14.0 — Release Notes & Engineering Impact

We hope everyone enjoyed their holidays and recharged for 2021! Today, we are excited to share the `2.14.0` stable release 🎉 🌟 **Help us spread the word about Prisma by starring the repo or [tweeting](https://twitter.com/intent/tweet?text=Check%20out%20the%20latest%20Prisma%20release%202.14.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/2.14.0) about the release.** ## Major improvements ### Group By queries are now in Preview Prisma Client now supports group by queries! Opt-in to this feature by adding the `groupBy` flag to the `generator` block in your Prisma schema: ```diff generator client { provider = "prisma-client-js" + previewFeatures = ["groupBy"] } model Agent { id String @id name String location String rate Float } ``` Now you can re-generate your Prisma Client to have access to the new `groupBy` API: ``` npx prisma generate ``` With the updated Prisma Client, you can invoke the new `groupBy` query: ```ts const locations = await client.agent.groupBy({ by: ['location'], min: { rate: true }, }) // Result: // [ // { location: "Los Angeles", min: { rate: 10.00 } }, // { location: "London", min: { rate: 20.00 } }, // { location: "Tokyo", min: { rate: 30.00 } } // ] ``` Prisma also supports the `having` side of group by, so you can further filter your groups: ```jsx const locations = await client.agent.groupBy({ by: ['location', 'rate'], min: { rate: true }, having: { rate: { gte: 20 } } }) // Result: // [ // { location: "London", rate: 20.00, min: { rate: 20.00 } }, // { location: "Tokyo", rate: 30.00, min: { rate: 30.00 } } // ] ``` Read more in [the documentation](https://www.prisma.io/docs/concepts/components/prisma-client/group-by). ### Linux ARM64 support Good news for Linux users! Prisma now supports Linux ARM64 out of the box. If you already generate the Prisma Client on a Linux ARM box, it will just work. To target the specific binary, you can add a `binaryTarget` to the `generator` block in your Prisma schema: ```prisma generator client { provider = "prisma-client-js" binaryTargets = ["linux-arm-openssl-1.1.x"] } ``` Learn more in [the documentation](https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#binarytargets-options). ### Prisma Migrate fix for PostGIS users PostgreSQL users who are using the PostGIS extension [can now use Prisma Migrate](https://github.com/prisma/prisma/issues/4745) as well. ## Breaking changes This release introduces a **breaking change for TypeScript users**. Prisma Client now requires TypeScript v4.1 or above. You can read more about upgrading your TypeScript version on [their wiki](https://github.com/Microsoft/TypeScript/wiki/Breaking-Changes). ## Fixes and improvements ### [`prisma`](https://github.com/prisma/prisma) - [Support number is an input for BigInt fields](https://github.com/prisma/prisma/issues/4195) - [Deploying to Heroku does not generate Prisma Client by default](https://github.com/prisma/prisma/issues/4210) - [Create fail with multiple connectOrCreate and connect](https://github.com/prisma/prisma/issues/4230) - [Sequential $transaction with $executeRaw](https://github.com/prisma/prisma/issues/4269) - [Transaction items run outside Postgres transaction (breaks) with random order](https://github.com/prisma/prisma/issues/4331) - [Add more jsdoc to Prisma Client](https://github.com/prisma/prisma/issues/4344) - [Rename findOne in dmmf.schema.outputObjectTypes.prisma Query](https://github.com/prisma/prisma/issues/4358) - [Errors with setting foreigns keys directly](https://github.com/prisma/prisma/issues/4442) - [multiple identical compound unique fields with different types not generating multiple types](https://github.com/prisma/prisma/issues/4454) - [The target table of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.](https://github.com/prisma/prisma/issues/4535) - [Prisma Migrate: Error creating shadow database](https://github.com/prisma/prisma/issues/4571) - [Integrate Linux ARM in TypeScript](https://github.com/prisma/prisma/issues/4573) - [Reintrospection Bug on Relations](https://github.com/prisma/prisma/issues/4582) - [Prisma Migrate: Omit schema name when creating enum types?](https://github.com/prisma/prisma/issues/4626) - [Tearing down MSSQL schema returns "Cannot read property 'split' of null"](https://github.com/prisma/prisma/issues/4635) - [prisma introspect drops some @relation custom names in existing schema](https://github.com/prisma/prisma/issues/4664) - [Implement `react-prisma` prototype](https://github.com/prisma/prisma/issues/4767) - [unable to run migrations in an empty PostGIS db](https://github.com/prisma/prisma/issues/4745) ### [`prisma-client-js`](https://github.com/prisma/prisma-client-js) - [Group By](https://github.com/prisma/prisma-client-js/issues/1) - [Generated Github issue creation links do often not include helpful information](https://github.com/prisma/prisma-client-js/issues/865) - [PANIC: expected 0 parameters but got 1 (when running $executeRaw`...`)](https://github.com/prisma/prisma-client-js/issues/940) ### [`migrate`](https://github.com/prisma/migrate) - [Removing a model with a foreign key fails](https://github.com/prisma/migrate/issues/667) ### [`language-tools`](https://github.com/prisma/language-tools) - [While Prisma extension is enabled, typescript server keeps crashing on each save](https://github.com/prisma/language-tools/issues/604) - [Transition open-vsx extension to Eclipse Cloud Development Tools working group](https://github.com/prisma/language-tools/issues/621) - [Renaming models in schema.prisma may break whole file](https://github.com/prisma/language-tools/issues/652) ### [`studio`](https://github.com/prisma/studio) - [Allow filtering by relation fields](https://github.com/prisma/studio/issues/520) ### [`prisma-engines`](https://github.com/prisma/prisma-engines) - [MySQL case sensitivity issue in ME on windows](https://github.com/prisma/prisma-engines/issues/950) - [Apply `clippy` to `query-engine`](https://github.com/prisma/prisma-engines/issues/1387) ## Credits Huge thanks to @qsona for helping! ## Help shape the future of Prisma We love open-source and are commited to building world-class database tools that make developers more productive. In addition to building open-source tools, we are currently planning a cloud offering that will improve many database workflows, especially in collaborative environments. If you want to help us shape the future of this offering, we would much appreciate if you could fill out this short [**survey**](https://prisma103696.typeform.com/to/q2txzFif) that represents a potential _onboarding flow_ for that cloud offering.