FWIW, you should be able to do:
join: c in fragment("some_other_schema.example")
or at least:
join: c in fragment("SELECT * FROM some_other_schema.example")
which you can easily encapsulate in a macro. But you do lose the Ecto schema information (although Ecto has many tools to help with that).
