IBM PureQuery

Project formely known as JLINQ.

http://www.ibm.com/developerworks/db2/library/techarticle/dm-0708ahadian/

http://www-306.ibm.com/software/data/studio/purequery/ (IBM Data Studio)

http://en.wikipedia.org/wiki/IBM_PureQuery

http://db2mag.com/story/showArticle.jhtml?articleID=202400140

It seems it used within Project Zero:

http://www.projectzero.org/wiki/bin/view/Documentation/DataAccess

It is unfortunately limited to Java and RDBMS.

Here is an example:

Data data = DataFactory.getData (datasource);
// Insert an employee of type Employee bean in the database
data.update("insert into EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, SALARY,
BONUS, COMM) values( :employeeNumber, :firstName, :midinit, :lastname, :workdept, :phoneno, :hiredate, :job, :edlevel, :sex,
:birthdate, :salary, :bonus, :commision)", employee);

// Query the database for employees
Iterator<Employee> employee = data.queryIterator ("select * from EMPLOYEE where EMPNO = :employeeNumber", Employee.class);

I like the idea behind ProjectZero, but is JLINQ really what you expect from a modern Data Access layer?