[Feature] Support for openid login for SSO

[balajiv113]

Problem

Currently we are using username and password based login.

Can we provide support for openid connect based login mechanism which will help in providing better experience for login

Proposed solution

During login we will have a option to login via SSO, which should automatically take use to SSO login and those user we will store the details back in DB with password as optional

Alternatives considered

No response

Affected surface

Self-hosting / Docker

Additional context

No response

Pre-flight checks

• I confirmed this is not a duplicate of an existing feature request.
• I'm proposing a feature, not asking a usage question (those go to Discussions or the docs).