Hi @viphuangwei,
The query special function in SQL is a wrapper for a query_string query from Elasticsearch. If you try the translate API from SQL you will see the actual query that ES is using to return the results.
These being said, query_string and phrase matching with wildcard will not work, thus the results you see. See here a suggestion from of the Lucene/ES developers about the type of query to use for such functionality. Unfortunately, ES SQL doesn't use that.