Searching for a value that’s not stored in lowercase, what approach do you prefer?
Typically, some values can be stored in lowercase, and be forced to lowercase on the page, but others should not be.
I see various approaches, like a separate field stored in lowercase (not my favorite), doing lower case on the db field as part of the query, etc.
Do you, or does the platform, have a particular approach that works in a very large data environment?
I agree that a separate field is not the right answer.
Server side is with an ilike query condition:
{ where: { name: { ilike: '%dave%' } } }
Client side code is usually so fast for the 100s or 1,000s of things in memory that plain JavaScript is fine.
