OAuth Providers array in user object

[maximousblk]

Feature request

Is your feature request related to a problem? Please describe.

In app_metadata.provoder in the user object, currently we can only get what provider did the user signed up with and not all the provides that the user has connected.

Describe the solution you'd like

Instead of providing only the initial OAuth Provider, provide an array of all the providers user has used in the past.

{
  // ...
  "app_metadata": {
-   "provider": "github"
+   "providers": ["github", "gitlab"]
  },
  // ...
}

This could be a massive breaking change, so here's an alternative solution:

Provide the current OAuth Provider and Dev's can record it on the application side.

Describe alternatives you've considered

N/A

Additional context

This can be used to show which OAuth Provider the user has connected and if they want to disconnect a provider or connect more, similar to the following:

ref: GitLab profile settings

[kiwicopple]

Nice - seems like a good idea. I'll shift this to our GoTrue repo 👍

[maximousblk]

I'd like to add that it would be nice if email:pass and email-link are specified separately so that in case an app needs password to be setup (login on cli and similar), but user signed up using magic links we can prompt the user to set it up.

[maximousblk]

Any updates on this?

[bnjmnt4n]

This is addressed by #208 (and relevantly, #240).