Can you do transactions spanning multiple connections?

No, clearly not.

I don't know of any database server that would allow you to do that.

Agreed.

But if we could get all the DBI handles out of Ima::DBI, we're thinking we could roll each handle back if any piece failed...

Not sure, though, how to get at all the handles.