Hey <!everyone> prisma cool we hope you enjoyed your holidays and are recharged and ready for an awesome 2021! 🍀🤞 We just released v2.14.0, here's what's new! prisma rainbow 🎳 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. Here is an example for invoking the new 

groupBy

 query:

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 } }
// ]

Note that Prisma also supports the 

having

 side of group by, so you can further filter your groups. You can read more about the group by queries in the documentation. 📟 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:

generator client {
  provider      = "prisma-client-js"
  binaryTargets = ["linux-arm-openssl-1.1.x"]
}

Learn more in the documentation. 🗺️ Prisma Migrate fix for PostGIS users PostgreSQL users who are using the PostGIS extension can now use Prisma Migrate as well. 📚 Learn more in the release notes For more info and links to documentation, you can read the release notes. 🌟 Help us spread the word about Prisma To help spread the word about Prisma, we'd very much appreciate if you would star the repo 🌟 And if you're excited about the features in this week's release, then help us and share your excitement on Twitter. 📰 Join us on Thursday for the "What's new in Prisma" livestream As usual, my colleague @ryan and I will discuss the latest release and other news from the Prisma ecosystem in a  on Thursday at 5pm Berlin | 8am San Francisco.