We just spelled out a proposal for a round of enhanced index capabilities for the Prisma Schema language. We're happy to listen to feedback if you want to have a look before we start implementing. You can chime in on Github.
https://github.com/prisma/prisma/issues/9577