Feature Request: Support full connection string as extension config var

[mickmister]

I'm trying to automate this extension's configuration through its settings, for use in a GitPod workspace https://www.gitpod.io

Right now the settings allow for providing a default connection name and default database, but this is only for things defined by the user using the extension's commands. It can't be hardcoded in the settings alone.

For my user case, the extension needs to be "ready to go" purely with database configuration that's already known ahead of time through the extension settings.

[dvasdekis]

Same is required in order to support CockroachDB Cloud, as it requires a connection parameter (e.g. connection string is in the form postgresql://username:[email protected]:26257/defaultdb?options=--cluster%3Dgolden-mermaid-3114). It won't let you connect without the cluster identifier.

[chuck-alt-delete]

Same for Materialize and anything else that supports PG wire protocol. It would also allow for all the other various PGOPTIONS people might want.