Is your feature request related to a problem?
LIKE query should be mapped to wildcard_query as mentioned in #1108 (comment)

What solution would you like?
This will be a breaking change since which should be implemented in 3.x.
Refer to #1108 and remove the LikeQuery class and its associated tests. Then make LIKE create a new WildCardQuery object in https://github.com/opensearch-project/sql/pull/1108/files#r1033815758.