how can I do something like this in prisma

LOWER(db_column) LIKE LOWER(?)

it is easy to lowercase the right part, but how to lowercase the left part before matching the value

@Yashu Mittal 👋 Performing a

lower

on the column is not possible at the moment. There’s a request for the same here so it would be great if you could add a 👍 to the request so that we know the priority for this 🙂

nice, thanks.