Quaere

A different concept framework to add queries to your java programs:

Quaere is an open source, extensible framework that adds a querying syntax reminiscent of SQL to Java applications. Quaere allows you to filter, enumerate and create projections over a number of collections and other queryable resources using a common, expressive syntax.

Just for your information it is based on a LINQ to SQL: .NET Language-Integrated Query for Relational Data.