#27439 made us stop starting transactions where that isn't necessary (e.g. single-statement insertion). However, there may be cases where users still want a transaction to be created. For example, a user may be using a command interceptor to commit an additional row to the database (e.g. audit), and may want transactionality for the two rows.

Add a flag to allow users to get a transaction even when we don't require it.