Hey <!everyone> ✌️ We just released Prisma 2.3.0 prisma rainbow Here is what’s new in this version 📝 Rename Helper Tool in VSCode Extension Thanks to @Carmen, you can now easily rename models and enums with the VSCode extension in your schema. 🕵️‍♀️ Introspection uses order of columns in table to order fields in model

prisma introspect

until recently ordered all fields in models alphabetically. Starting with 2.3.0 it now picks up the order from the columns in your database table and uses that same order for the fields in your models in your Prisma Schema file. prisma cool Experimental features have been renamed to preview features With

2.1.0

we introduced feature flags for Prisma Client, called “Experimental Features”. The property in the schema has been renamed from

experimentalFeatures

to

previewFeatures

to better communicate what they actually are. 🦕 Distinct API (preview) We introduce distinct querying capabilities to Prisma Client. It allows you to query for distinct (unique) rows of a model.

const result = await prisma.user.findMany({
  where: {},
  distinct: ['name']
})

🍄 Middlewares API (preview) Inspired by Koa - Prisma Client now allows you to provide powerful async middlewares.

prisma.use(async (params, next) => {
  console.log('params', params)
  const before = Date.now()
  const result = await next(params)
  const after = Date.now()
  console.log(`Query ${params.model}.${params.action} took ${after - before}ms`)
  return result
})

You can learn more about all features and fixes in the release notes, we’re looking forward to your feedback for the new version!