# open projection: findFullNameByDepartmentName("Sales")  (getFullName uses @Value SpEL)
select e1_0.id,e1_0.bio,e1_0.department_id,e1_0.email,e1_0.first_name,e1_0.last_name,e1_0.salary from employee e1_0 left join department d1_0 on d1_0.id=e1_0.department_id where d1_0.name=?
columns selected: 7, entities now managed by the persistence context: 4
getFullName() of first row: First1 Last1