Make `tunnel-ssh` `autoClose` configurable

[ultram4rine]

Is your feature request related to a problem? Please describe.
Hi! I was playing with connect over SSH feature in clickhouse-driver and found out that tunnel automatically closes and every action fails.

Describe the solution you'd like
Maybe it is possible to configure this setting in tunnel-ssh?

Describe alternatives you've considered
:(

Additional context
LOC:

vscode-sqltools/packages/base-driver/src/index.ts

Line 149 in 2d96707

autoClose: true,

Some repro scripts:
Tunnel from usage example
Clickhouse:

import { createClient } from "@clickhouse/client";

const client = createClient({
  url: "http://localhost:51212",
});

client.ping().then((res) => console.log(res));

client
  .query({ query: "SELECT 1" })
  .then((res) => console.log(res.json().then((j) => console.log(j.data))));

If set autoClose to true, tunnel will close every time clickhouse script executed, if set to false, it remains opened.

[gjsjohnmurray]

@ultram4rine do you want the base-driver to hardwire autoClose: false? Or are you looking for a way for your driver to make base-driver do that for it?

I'm not clear why autoClose: true isn't apparently causing problems for the other drivers.

Pinging @d-mato who authored this new feature.

[ultram4rine]

I'm not sure that hardwire is a good option, thus I want to set autoClose when calling createTunnel.

I'm not clear why autoClose: true isn't apparently causing problems for the other drivers.

I guess that's because clickhouse nodejs driver works on HTTP.

[gjsjohnmurray]

If we enhance createSshTunnel so you can optionally pass a TunnelOptions object I think we'll also need to add sshTunnel to the object we return, so your driver can close the tunnel when appropriate, right?

[ultram4rine]

Yes, that's correct

[gjsjohnmurray]

@d-mato would you be willing to contribute a PR to do this in a back-compatible way so we don't have to rebuild the supported drivers?

[d-mato]

Thank you for the ping.
I understand the requirement and will create a PR within a week.

[ultram4rine]

Btw @d-mato maybe make ssh password hidden? Add to ui.schema.json in drivers:

"sshOptions": {
    "password": { "ui:widget": "password" }
  }

[d-mato]

Thanks for the suggestion! Since I've already created PR #1531 for the main autoClose configuration feature, I'll handle the password hiding feature in a separate PR to keep the changes focused and maintainable.