Allow creating gsheet secrets in other loaded secret storages

[stephaniewang526]

Currently running into when trying to create a gsheet secret in the loaded "motherduck" secret storage:

D load '/Users/stephaniewang/Documents/dev/duckdb-gsheets/build/release/extension/gsheets/gsheets.duckdb_extension';
D CREATE SECRET in motherduck (TYPE gsheet, PROVIDER oauth);
Visit the below URL to authorize DuckDB GSheets

https://accounts.google.com/o/oauth2/v2/auth?client_id=793766532675-rehqgocfn88h0nl88322ht6d1i12kl4e.apps.googleusercontent.com&redirect_uri=https://duckdb-gsheets.com/oauth&response_type=token&scope=https://www.googleapis.com/auth/spreadsheets&state=Ma6kU1SAVc

After granting permission, enter the token: <redacted>

Invalid Input Error: Secret type 'gsheet' not found

Same missing secret type error for both oauth provider and "token".

[archiewood]

Does motherduck store secrets in a place other than where duckdb does when operating locally?

[Alex-Monahan]

I think there are some details here (@stephaniewang526 is the expert though!): duckdb/duckdb#10042 in the "custom secret storage" section.