[BUG] opensearch-sql CLI doesn't print a error return if http code is 500

Describe the bug
Some queries cause a error on server side and REST returns a message describing it followed by code 500. In this case CLI doesn't print the error.

opensearchsql> SELECT A, B FROM (SELECT `key` as A, DAYOFWEEK(date1) AS B from calcs) tmp WHERE tmp.B IN (1, 7);
KeyError('datarows')

In such cases I have to use CURL to see the message:

curl -XPOST http://localhost:9200/_plugins/_sql -H 'Content-Type: application/json' -d '{"query" : "SELECT A, B FROM (SELECT `key` as A, DAYOFWEEK(date1) AS B from calcs) tmp WHERE B IN (1, 7);"}'
{
  "error": {
    "reason": "There was internal problem at backend",
    "details": "The following method is not supported in Schema: DAYOFWEEK",
    "type": "UnsupportedOperationException"
  },
  "status": 500
}

The CLI interface is much more convenient for use rather than CURL, so it would be useful to keep using it to see the error message.

Additional context
Low priority