Prisma1: Single queries should be more powerful

[steebchen]

Is your feature request related to a problem? Please describe.
Currently, single queries like .user can only query by unique fields:

Describe the solution you'd like
I want to query by everything, not just unique IDs, just like I can do when querying multiple users:

[pantharshit00]

Hi @steebchen

I think it really doesn't make any sense to add non-unique value to a single query(any field annotated with @unique is available even if it is a relation).

Like if the field is non-unique there is absolutely a chance that we will get more than one match. That is why other non-unique fields are available via another method that will return an array. You can grab the first result if you are sure that one only such entity exist. In the upcoming API there will be findOne option that will do this for you.

[steebchen]

Makes sense. To rephrase, I was rather asking for a findOne method to only return a single result (not guaranteed by SQL, but guaranteed by my schema).