Add option to completely disable transactions

During testing, I want the option to use goose with chDB, an embedded version of ClickHouse that doesn't support transactions. Unfortunately, this errors out on creating the version table because transactions are used. It would be helpful to have a global option that completely disables the use of transactions anywhere.