[FEATURE] Kyuubi OAuth support

### 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

Add support for OAuth to allow users to authorize themselves using some popular providers like Google
feature conversation reference
https://github.com/apache/incubator-kyuubi/discussions/1651

### Motivation

This will allow users to authorize themselves by business account provided by the company and avoid admins installing & maintaining additional components for security parts like LDAP, Kerberos, etc

### Describe the solution

_No response_

### Additional context

_No response_

### Are you willing to submit PR?

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

Start by reading the feature conversation in Discussion #1651 and clarify the intended OAuth providers and authorization flow. No source files, tests, or entry points are named in the issue, so the implementation scope must be established first. Done would mean users can authorize with supported business or popular-provider accounts without requiring separately maintained LDAP or Kerberos components.

Written by the indexing model from the issue text.