It also makes me suspect that the same issue can occur with other databases.

Maybe we should add a test for checking that It is possible to execute a query outside a transaction.