Align PostgREST API conventions with GoTrue-JS

[logemann]

Feature request

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

Alignment of various parts of the API. Would like to have the AUTH API behaves the same way as the DB REST Api.

See this how throwOnError works in the DB API
supabase/postgrest-js#188

Describe the solution you'd like

same thing for methods like signIn() and friends.

Describe alternatives you've considered

nothing.

[matheusbn]

Maybe for storage as well?