Is your feature request related to a problem?
See comment in this PR: https://github.com/opensearch-project/sql/pull/3915/files#r2241175991

Like function for keyword field datatype is optimized to wildcard query when it can be pushed down. Wildcard query for text field has inconsistent behavior with SQL like function.

It's proposed to figure out a way to pushdown like function as a script. ScriptDocValues don't recommend to run script against text field. We can prototype reading text field values from source like params._source['region'].

What solution would you like?
A clear and concise description of what you want to happen.

What alternatives have you considered?
A clear and concise description of any alternative solutions or features you've considered.

Do you have any additional context?
Add any other context or screenshots about the feature request here.