Query two databases in the same query using CakePhp

I would like to use two separate databases for a cakePHP application. I will need to execute queries that join tables from the two databases. Is this possible in cakePhp?

I know you can have multiple data sources in cakePHP and switch connections. I am using SQLite presently but would like the solution to be database agnostic if possible.

There is the ATTACH feature of SQLite databases, but I'm not sure if that's the correct approach. Is it possible to bake models for both databases? Does the attachment need to occur on every request?

In this similar question, a finderQuery is used but the database is not SQLite.

Thanks