Lazy loaded dependency from different connection

[Condor70]

It would be very nice if I could specify a connection for every query, so that lazy loaded dependencies could be retrieved from a different connection.

I know that MyBatis has a limitation of one connection and transaction manager for each sql factory, so I know this is a difficult and massive request.

This feature would however put MyBatis ahead of the competition, because AFAIK there currently is no ORM tool that can do this.

Note: To simplify things:

1. I only need insert/update/delete on the primary connection.
2. The additional connections wouldn't have to be managed by the transaction manager.