Allow joins with subselects in the FROM clause

It shall be possible to execute statements like

SELECT * FROM table1, (SELECT * FROM table2 WHERE xxx) t2 WHERE table1.id = t2.id

(I know this example can be rewritten as a simple join, the actual use case is more complicated)

In the case of the Criteria object, this would suggest a call sequence like

criteria.addAlias("t2", subCriteria);
criteria.addJoin("t2.id", Table1Peer.ID);