I wrote something similar a few years ago:

http://GitHub.com/zerorm/zerorm

after a search, I found http://www.querydsl.com/ -- seems reasonable and sound with the sql syntax

Any ORM?