Querydsl is a framework that enables the construction of statically typed SQL-like queries. Instead of writing queries as inline strings or externalizing them into XML files, they can be constructed via a fluentDSL/API like Querydsl. It supports JPA, JDO, Java Collections, SQL via JDBC, Lucene, and Hibernate Search.
The Generic Repository (grepo) is a framework for Java which allows you to access (database) repositories in a generic and consistent manner. Using grepo, it is generally no longer required to provide all the boilerplate code which is necessary in order to access (database) repositories from Java. All you have to do is write appropriate database code (queries, procedures, functions, etc.), an appropriately annotated Java interface, and very little Spring configuration.