Hi, Is there a way to use a case statement in

orderBy

of prisma client? If not what are some ideas for workarounds? (I see this issue in the archived prisma repo https://github.com/prisma/specs/issues/128, but it was closed as completed, though I don't see docs for allowing case statements in the

orderBy

clause. This issue https://github.com/prisma/prisma/issues/10335 is in the current repo, but it's not so clear from the title that the feature request is for case statements. Maybe the title should be renamed to 'Support case statements in orderBy' like the first issue?)

@Shmuel apologies for the delay in helping out with this problem, a few people from our team are on leave or just starting! 😊 Have you perhaps already resolved this or are you still looking for help?