Include schema name in queries

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)?

Thanks,
Chris…