No rollback transaction option for multiple databases

Currently we have two databases for our application. For some use cases, we need to make changes to the two databases. I can create transaction for each of the database and if some exception happens, it will rollback changes to this database only. But there is no way to rollback other database changes as well.
In spring boot, we can just place @Transaction annotation at the top of the method, it will rollback changes to all the databases if there is an exception. is there similar option in exposed?

Start by reviewing Exposed's transaction API and how separate database transactions are currently created. Compare that behavior with Spring Boot's transaction annotation, then define what coordinated rollback across both databases should mean and how completion would be verified.

Written by the indexing model from the issue text.