sqlQuery.addRoot( "org", Organization.class );
sqlQuery.addFetch( "emp", "org", "employments" );
sqlQuery.list();
// now try full explicit mappings
sqlQuery.addRoot( "org", Organization.class )
.addProperty( "id", "orgid" )
.addProperty( "name" ).addColumnAlias( "name" );
sqlQuery.addFetch( "emp", "org", "employments" )
.addProperty( "key", "employer" )
.addProperty( "element", "empid" )