feat: github social auth implementation

[cofin]

Pull Request Checklist

• [ ] New code has 100% test coverage
• [ ] (If applicable) The prose documentation has been updated to reflect the changes introduced by this PR
• [ ] (If applicable) The reference documentation has been updated to reflect the changes introduced by this PR
• [ ] Pre-Commit Checks were ran and passed
• [ ] Tests were ran and passed

Description

This PR enables a Github social authentication login flow.

Close Issue(s)

[railway-app[bot]]

🚅 Previously deployed to Railway in the Litestar Fullstack project. Environment has been deleted.

[sonarqubecloud[bot]]

Quality Gate passed

Issues
8 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud