I believe the bug here is that an ANSI-style join is not being generated for the implicit join (e.department) when an attribute of the joined entity (e.department.deptName) is selected in:

select e.lastName, e.department.deptName, e.title from Employee e

As a workaround, the implicitly joined entity can be selected instead; theANSI-style join is correctly generated in this case:

select e.lastName, e.department, e.title from Employee e

When processing the second column (e.department) returned, simply call Department.getDeptName() to get the value for e.department.deptName.