title: Is there any good dynamic SQL builder library in Java?
body: <p>Anyone knows some good SQL builder library for Java like <a href="http://code.google.com/p/squiggle-sql/">Squiggle</a> (not maintained anymore it seems). Preferably, a project in active development.</p>
  
  <p>Preferably with syntax like <a href="http://framework.zend.com/manual/en/zend.db.select.html">Zend_Db_Select</a>, something that will allow to make a query like </p>
  
  <pre><code>String query = db.select().from('products').order('product_id');
  </code></pre>