[FEATURE] LIKE function should use WildcardQuery

[GumpacG]

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.

[dai-chen]

Is this fixed in #1108 ?

[GumpacG]

Is this fixed in #1108 ?

@dai-chen it is not. That PR introduced this issue. We want LIKE to use wildcardaquery however, if we do that it will be a breaking change. A fix to this issue will be towards 3.x. We did this in order to allow deprecation in 2.x.