A note, we won't be able to mix transactional backends and non transactional backends in the same transaction because the Worker has to either do the processing work before or after the transaction. We don't feel the use case for mixed modes strong enough. We can revisit if someone comes with the requirement.