Hello Community,

I'm currently planning the migration process of my company from C and native SQL to Java and Hibernate.
Since most of our objects are not known at deployment-time (our table-definitions are mostly stored in the database) we're going to work with <dynamic-component>s and a single POJO. Our table-definitions also includes sql-columns that contain native SQL-code which is joined with a subselect by the current program. I've just had a look on <sql-query>/<return-scalar> nodes. Such queries can be used as custom loaders with the help of the <class>/<loader> node. Is it possible to _join_ the result of a custom loader (foreign table) with other properties of that class?

Best regards,
Markus Iser

Ok I can give the answer myself now. Normally one would use @Formula or <formula>-nodes to accomplish this.