Is it possible to include schema names in the queries Hibernate generates?
For example, select [columns] from schema.tablename
I’ve looked at the multi-tenant code and it doesn’t get what I need (that basically changes the schema used for an individual query). I need to map tables that span multiple schemas in 1 query (legacy application that I need to interact with).
select [columns] from s1.table1 as t1, s2.table2 as t2 where …join logic
Thoughts on options (if any)?