Provide easy way to run Presto CLI against environment started with `env up`

[findepi]

We have env up command, which is currently very useful:
for example it allows me to use the test env to manually reproduce some issue.

However, when the environment is secured, it is hard today to run connect to it with Presto CLI.

Provide an easy way to connect Presto CLI to such secured environment

• correct port number (it's not always 8080)
• a CA bundle or --insecure option
• keytab when kerberos auth is required

Relates to: #4911

[wendigo]

I have an idea of how to do that.

[kokosing]

Notice that each environment has to participate to that, we need to collect all parameters that are required to connect to Presto.

Once upon a time... we had https://github.com/prestosql/presto/blob/cd65c0552816d36309ec24b8c0817831a49afdfd/presto-product-tests/conf/docker/files/presto-cli.sh, which had CLI_ARGUMENTS and this variable was updated in each environment, like here: https://github.com/prestosql/presto/blob/cd65c0552816d36309ec24b8c0817831a49afdfd/presto-product-tests/conf/docker/common/kerberos.yml

[kokosing]

Also having this merged: #4996 it should be easily doable.

[nineinchnick]

Environments defined in the PTL can have multiple database connections, both for Trino and direct connections to data sources. These in turn can be defined over multiple Tempto configuration files, that Tempto merged before starting tests.

My first idea was to print the JDBC strings in Tempto, after it prints the merged configuration. This would help to avoid duplicating the config merging logic (and resolving variables in configs). But I also wanted to print commands to run the Trino CLI, but I'm not sure Tempto should be doing that. Or maybe it's fine just for the connections using io.trino.jdbc.TrinoDriver.

I'm not sure why, but Tempto performs Kerberos authentication before opening the JDBC connection, even though the Trino JDBC driver could also do this.

To be able to start the CLI from PTL, it should be able to somehow get a list of JDBC strings from Tempto after it processed the configs, but I'm not sure how to best do that.

[nineinchnick]

Another question - how to best map JDBC properties to CLI arguments? Maybe the CLI could accept an URL instead of individual options?

[nineinchnick]

We can discuss allowing the CLI to accept URLs here: #12543