Provide user input to a statement that is waiting on it?

[ChuckJonas]

Consider the the following commands:

INSTALL gsheets FROM community;
LOAD gsheets;

-- Authenticate with a Google Account in the browser (default)
CREATE SECRET (TYPE gsheet);

When you run this command in the terminal, you get the following and it waits for input:

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=wdG2MV8ZaG
After granting permission, enter the token: 

Is there anyway to provide this input when running these commands via the node-api?

[jraymakers]

I'm not sure. You may be able to use general Node functionality to send input to this, depending on how the extension is initiating it.

In general, extensions shouldn't assume they're being run in an interactive environment like this.