Squill is a slick internal DSL for writing SQL queries in pure Java. It uses the database metadata and generics to catch as many errors as possible during compilation and is almost completely typesafe. At the same time it is designed to allow everything SQL allows you to do, exactly the way SQL is meant to do it. This means that you're encouraged to select only the data you need and no hidden queries are generated for you, leaving you in full control of the query performance. Squill also supports database-specific extensions, allowing you to both use advanced features and fully tweak your queries.

Documentation:

Quick Start Guide Step-by-Step Example Tutorial Devoxx Presentation Metadata generator documentation DSL documentation Releases:

Squill 1.0 M1 squill-1.0-M1.zip (889 KB) squill-with-examples-1.0-M1.zip (10.2 MB) Squill 1.0 M2 squill-1.0-M2.zip (1.26 MB) squill-with-examples-1.0-M2.zip (10.7 MB)