Prisma 2.22.0 — Release Notes & Engineering Impact

Today, we are excited to share the `2.22.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%20@prisma%20release%20v2.22.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/2.22.0) about the release.** 🌟  ## Major improvements & new features ### `prisma db push` is now Generally Available `prisma db push` enables you to update the database schema from the Prisma schema file, without generating any migrations. This is especially useful when prototyping a new feature, iterating on the schema changes before creating migrations or generally if you are at stage of your development process, where you don't need to persist the schema change history via database migrations. It is now promoted from [Preview](https://www.prisma.io/docs/about/releases#preview) to [General Availabilty](https://www.prisma.io/docs/about/releases#generally-available-ga). You can find more info on `prisma db push` in the official [docs](https://www.prisma.io/docs/concepts/components/prisma-migrate/db-push). ### Deprecation of array notation for `provider` fields In this release, we are also entirely removing the array notation for the `provider` fields on `datasource` blocks. This has been deprecated since [2.11.0](https://github.com/prisma/prisma/releases/tag/2.11.0) (November 2020). You can read more about our reasons for this deprecation [here](https://github.com/prisma/prisma/issues/3834). ### Prisma Client Go gets support for `AND` operator We've always had `OR`, but this release we also added `AND` support: ```groovy first, err := client.User.FindFirst( User.Or( User.Email.Equals("[email protected]"), User.And( User.Name.Equals("John"), User.Username.Equals("johno"), ), ), ).Exec(ctx) ``` Learn more in our [docs](https://github.com/prisma/prisma-client-go/tree/master/docs). ## Fixes and improvements ### Prisma Migrate - [[Introspection] Catch ripple effects of guardrails](https://github.com/prisma/prisma/issues/1912) - [Treat missing `provider` as known error that does not trigger Error Reporting](https://github.com/prisma/prisma/issues/2093) - [List of integers in SQLite introspected as a list even though SQLite doesn't natively support lists](https://github.com/prisma/prisma/issues/3238) - [Formatting adds optional relation incorrectly](https://github.com/prisma/prisma/issues/3548) - [PANIC in query-engine/connectors/sql-query-connector/src/query_builder/write.rs:22:56called `Option::unwrap()` on a `None` value](https://github.com/prisma/prisma/issues/5966) - [Improve readability of errors in `prisma migrate deploy`](https://github.com/prisma/prisma/issues/6054) - [Introspection creates invalid schema: "Error parsing attribute "@default": The `autoincrement()` default value is used on a non-indexed field even though the datasource does not support this."](https://github.com/prisma/prisma/issues/6477) - [Error: [libs/sql-schema-describer/src/sqlite.rs:452:76] get name](https://github.com/prisma/prisma/issues/6499) - [Soft reset crash with custom user types on SQL Server](https://github.com/prisma/prisma/issues/6526) - [`migrate dev` with shadow database errors with "Database already exists FK__Address__userId" when migration fails because of existing foreign key](https://github.com/prisma/prisma/issues/6547) ### Prisma Client - [Test support for PlanetScale/Vitess](https://github.com/prisma/prisma/issues/5219) - [SQLServer decimal(26,0) causes PANIC in /root/.cargo/registry/src/github.com-1ecc6299db9ec823/tiberius-0.5.9/src/tds/numeric.rs:288:47](https://github.com/prisma/prisma/issues/5950) - [Cannot read property 'collectErrors' of null](https://github.com/prisma/prisma/issues/6052) - [Prisma client runtime causes "Critical dependency" warning in Webpack](https://github.com/prisma/prisma/issues/6327) - [Prisma is not compatible with Next.js webpack5 opt-in](https://github.com/prisma/prisma/issues/6328) - [No results when using cursor and orderBy (Text type)](https://github.com/prisma/prisma/issues/6337) - [Decimal value stored in MySql DB with floating point error](https://github.com/prisma/prisma/issues/6381) - [napi engine cause OOMKilled in container environment](https://github.com/prisma/prisma/issues/6474) - [Netlify Functions deploy fails with Prisma because of size problems, Prisma deploys with 2 QE binaries](https://github.com/prisma/prisma/issues/6503) - [Misleading validation error on MongoDB connection strings](https://github.com/prisma/prisma/issues/6539) - [Integrate feature flag changes in Prisma Client](https://github.com/prisma/prisma/issues/6575) - [MaxListenersExceededWarning: prisma 2.20.x and above](https://github.com/prisma/prisma/issues/6584) - [Prisma Client crashes with Node.js 16.0.0](https://github.com/prisma/prisma/issues/6682) ### Prisma Studio - [Unable to find query engine](https://github.com/prisma/studio/issues/659) ### Prisma engines - [Vitess test runs into mergeable state](https://github.com/prisma/prisma-engines/issues/1851) ## Credits Huge thanks to @Sytten, @schiller-manuel, @mongolyy, @paularah, @Iamshankhadeep, @meeq for helping! ## 📺 Join us for another "What's new in Prisma" livestream Learn about the latest release and other news from the Prisma community by joining us for another ["What's new in Prisma"](https://www.youtube.com/watch?v=zBIQUdqgfJM&ab_channel=Prisma) livestream. The stream takes place [on Youtube](https://www.youtube.com/watch?v=zBIQUdqgfJM&ab_channel=Prisma) on **Thursday, May 06** at **5pm Berlin | 8am San Francisco**.