[Explore]add new operators to ad hoc filter

[junlincc]

• Add new operators: "Contains", "Starts with" and "Ends with" ('%str%', 'str%' and '%str' respectively) that will escape underscores, do case insensitive matching when writing all lowercase (e.g. "ma") and case sensitive when writing mixed case (e.g. "Ma"). These would be primarily geared towards less technical business users. The reason for deciding when to do case sensitive vs insensitive matching is to keep the basic UX as simple as possible and avoid having to add separate case sensitive and insensitive variants of these operators.

Someone will undoubtedly want to do case sensitive all lowercase matching, but for those cases they should probably just learn to use the full LIKE operator.

Originally posted by @villebro in #16396 (comment)

as comment to #16277 and #16396

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[rusackas]

Closing as stale, but if people are still interested in this, let's refresh it as an Ideas thread.