[Feature Request] Add support for partial indexes

[lsmith77]

Is your feature request related to a problem? Please describe.
I would like to see support for partial indexes, since they are supported in Prisma Migration.

Describe the solution you'd like
Same syntax as prisma:

  @@unique([email], where: raw("status = 'active'"))
  @@index([email], where: raw("\"deletedAt\" IS NULL"))

Describe alternatives you've considered
Using @meta with a custom plugin to tweak the prisma schema generation.

Additional context
https://discord.com/channels/1035538056146595961/1087761218049167380/1494007717076140114