I'm a big fan of this approach.

Will there be support for cross database and cross server joins.

I.E Modelling relationships between 2 entitities that can have there locations changed relative to each other.

e.g.

Can it handle

DB1..Table1 to DB2..Table2 in same server

or

Server1.DB1..Table1 to Server2.DB2..Table2

The SQL for the above scenarios will vary based on where you are connected and what the linked server names are etc.

is this supported, or will it be in the future.

Thanks and Regards
Pete