Feature List
- Compose queries, updates, and inserts out of Java expressions which map to a usable subset of the relational algebra but translate into standards compliant SQL.
- Operations include project, restrict, cross product, joins (natural & theta joins; inner, left outer, right outer, full outer), aggregate operations (sum, average, etc.), and sorting.
- Support for the creation of multiple SQL dialects for the handling of variances between database vendors. Comes with an abstract ANSI SQL implementation which can be easily extended for each vendor.
- Support for introspection of a database schema using JDBC to produce JRel descriptions of the schema to make it easy to produce queries.
- A reusable query expression visitor framework which in addition to being used to produce SQL could be used to rewrite/optimize queries, or work against in-memory native data-types instead of a database.
Planned Features
- Support for the execution of queries with the JDBC ResultSets coming back mapped into relational constructs that can be re-used, in-memory, in queries.
- More database vendor implementations.
- Additional query features ("HAVING" clauses, additional data types).
Download in other formats:
