Jequel is an Java embedded DSL for SQL. Using its expressions one can easily create expression trees that can be rendered e.g. to SQL.
Advantages:
- code completion, syntax highlighting, error reporting in IDE
- re-generate java schema-model during CI build, all non complying code will fail to compile
- enhance the schema-model with lots of other information and have this at your fingertips (quick documentation lookup of your IDE)
- generate browseable javadoc from the schema model files
What exists by now:
- Expression Language
- small Generator Framework
- Ant Tasks for Generation
- Unit tests for all the above
