javasqlsqlbuilder

Is there any good dynamic SQL builder library in Java?


Anyone knows some good SQL builder library for Java like Squiggle (not maintained anymore it seems). Preferably, a project in active development.

Preferably with syntax like Zend_Db_Select, something that will allow to make a query like

String query = db.select().from('products').order('product_id');

Solution

  • Querydsl and jOOQ are two popular choices.