Optiq - a dynamic data management framework

Optiq makes data anywhere, of any format, look like a database. For example, you can execute a complex ANSI-standard SQL statement on in-memory collections.

Optiq supports the following features

• Query parser, validator and optimizer 
• Support for reading models in JSON format 
• Many standard functions and aggregate functions 
• JDBC queries against Linq4j and JDBC back-ends 
• Linq4j front-end

check out the git repository here