Description
Similar to #118304, ESQL should catch this "pattern" not just for equality but also pattern matching:
...
| WHERE TO_UPPER(string_a) like "String" // this will never match since the value contains lower case chars
| WHERE TO_LOWER(string_b) like "abc" // rewritten as a case-insensitive wildcard query
| WHERE TO_LOWER(string_b) rlike "abc.*xyz" // rewritten as a case-insensitive regex query
...
Description
Similar to #118304, ESQL should catch this "pattern" not just for equality but also pattern matching: