we all know mapping a single table into a pojo-style record works:
Result<SiteRecord> records = sql.selectFrom(SITE).fetch();
also we know this works when joining tables:
Result<Record> joinedRecords =
sql.select().from(SITE).leftOuterJoin(ACCOUNT).onKey().fetch();
Since there is already logic for mapping fields into type-safe records,
would this orm-style of mapping be possible?
for (Record joinedRecord : joinedRecords) {
SiteRecord site = joinedRecord.getRecord(SiteRecord.class);
AccountRecord account = joinedRecord.getRecord(AccountRecord.class);
// bla
}
Regards,
Peter