# nested projection: asks for firstName and department.name only
select e1_0.first_name,d1_0.id,d1_0.location,d1_0.name from employee e1_0 left join department d1_0 on d1_0.id=e1_0.department_id where d1_0.name=?
columns selected: 4 (1 from employee + 3 from department), entities now managed: 1
department name read from the projection: Sales
extra statements after reading it: 0
