Add support for Indexes on Expressions

[chrisjaimes]

Let's say I have the following index expression (which works for defining complex unique constraints) https://www.postgresql.org/docs/current/indexes-expressional.html

create table request (
  from_user int,
  to_user int,
  active boolean default true
);

CREATE UNIQUE INDEX request_index_constraint 
ON request(greatest(from_user,to_user), least(from_user,to_user))
WHERE (active);

When generating the schema, there is no definition for this unique constraint.
findOne method won't be able to target these fields in the where obj.
Index constraints are useful for more complex unique constraints on table columns, and it would be useful to let Prisma find this 'uniqueness' in table rows. Currently, a workaround is the raw function.

[vimutti77]

I need this feature for unique two-way combination of columns

[rohanrajpal]

Did anyone find any workaround meanwhile?

[tclass]

same problem here, want to use index expressions in postgres, anyone found a workaround for this?