I hope this information will help you.
The problem seems to be somewhere around there:
at org.apache.cayenne.access.trans.JoinStack.appendJoinSubtree(Appendable,
JoinTreeNode)
178: qualifierTranslator.doAppendPart(dbQualifier);
where dbQualifier is our qualifier.
It goes down to
org.apache.cayenne.access.trans.QueryAssemblerHelper.processColumnWithQuoteSqlIdentifiers(DbAttribute
dbAttr, Expression pathExp)
294: String alias = (queryAssembler.supportsTableAliases()) ? queryAssembler
295: .getCurrentAlias() : null;
returns root table alias (usually "t0") instead of joined table ("t1" or
other), if pathExp was matchDbExp
