Using CLI for execution #10
Description
I think it's an interesting idea to evaluate the feasability of using the CLI to execute the test statements.
Python would be used to parse and orchestrate all the testing and verification steps, but the actual SQL would be handled by the CLI.
The query results could be output as CSV, annotated with the output types for result verification.
The biggest hurdle with this approach would be the need to recreate and export the configuration of the session.
As every statement executed would be a new temporary CLI session.
Or we would need to somehow keep the CLI session running, like a server that we as a client send statements to.
Max and Carlo might have some thoughts on that.
Either way we would need some way to extract settings, to facilitate restart