Support subqueries starting with SHOW

[joshuali925]

Is your feature request related to a problem? Please describe.
When using ODBC driver with other softwares, queries might be transformed. For example SHOW TABLES LIKE % in Tableau becomes

SELECT *
FROM (
  SHOW TABLES LIKE %
) `Custom SQL Query`
LIMIT 1

And it is not currently supported

  "error": {
    "reason": "Invalid SQL query",
    "details": "ERROR. token : SHOW, pos : 22",
    "type": "ParserException"
  },

Describe the solution you'd like
https://github.com/opensearch-project/sql/blob/3fd8ebf78eeab6dbe8416d697434a21485dd95b9/sql/src/main/antlr/OpenSearchSQLParser.g4#L124-126
Currently subquery can only be select ..., add more queries support so SHOW ... will work in subqueries.

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

Additional context
Add any other context or screenshots about the feature request here.