[FEATURE] Support SQL Resources for restful api

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)

### Search before asking

- [X] I have searched in the [issues](https://github.com/apache/incubator-kyuubi/issues?q=is%3Aissue) and found no similar issues.

### Describe the feature

Support to execute sql query with restful api

TBD.
### Motivation

_No response_

### Describe the solution

_No response_

### Additional context

_No response_

### Are you willing to submit PR?

- [x] Yes I am willing to submit a PR!

The issue names no implementation files or tests and leaves the solution as TBD. Start by surveying Kyuubi's existing SQL execution and API entry points, then define the REST resource and request flow. Done means a REST API can accept a SQL query, execute it, and return a documented result.

Written by the indexing model from the issue text.