feat: deny only open CommitTx flag for non-interactive transactions

[rekby]

Feature Request

Describe the Feature Request

Prevent use only open flag for controlTx for methods with guarantee non-interactive transactions.

This code is cause of transaction-leak and bad_session errors (sesstion close when starts many non-closed transaction).

// Example of code with transaction leak
client.DB.Query().QueryResultSet(ctx,
		sql,
		query.WithParameters(params),
		query.WithTxControl(query.SnapshotReadOnlyTxControl()),
		query.WithIdempotent(),
	)

Describe Preferred Solution

Deny only open controlTx (and return error) AutoAdd CommitTx() option.

I prefer check flag and return error with describe cause and solution.