As identified in #80833: now we have a new build artifact cockroach-sql we would like to add testing for it.

Unfortunately, our existing acceptance testing frameworks don't know about this new binary:

• the tests in pkg/acceptance don't know how to obtain/install the binary inside the docker container used to run the tests.
• roachtest/roachprod does not know how to fetch the pre-built executable.

We need to evolve this and then add the missing UX/acceptance tests for the new product.

cc @srosenberg @rickystewart

Jira issue: CRDB-15449