Describe the Proposal

Sometimes when using Docrine Dbal ADapter, it's necessary to first remove all rows and then insert them.
(This can be achieve through upserts (until it can't) in most cases).

So what we want to achieve is a transactional loader that will open a transaction, execute two or more other loaders and close transaction / rollback in case of failure.

The important part is that each load execution should open and close transaction so only one batch in time is handled in one transaction.

API Adjustments

Dbal Adapter DSL

to_dbal_transaction(Loader ...$loaders)

Are you intenting to also work on proposed change?

Yes

Are you interested in sponsoring this change?

None

Integration & Dependencies

No response