title: How to modify plain sql text with jOOQ such as appending order-by/limit-offset clause or changing where condition value?
body: <p>I build a sql template with named params using jOOQ 3.11.11.</p>
  
  <pre class="lang-sql prettyprint-override"><code>select * from table1 where report_date = :bizdate
  </code></pre>
  
  <p>Then I stored the sql template text. For each query, I will replace the param <em>bizdate</em> with user input.<br>
  <a href="https://stackoverflow.com/questions/57588198/how-to-generate-sql-from-template-and-param-placeholder-with-jooq">how to generate sql from template and param placeholder with JOOQ?</a><br>
  the realtime sql like this:  </p>
  
  <pre class="lang-sql prettyprint-override"><code>select * from table1 where report_date = '20190801'
  </code></pre>
  
  <p>It works well. But there is another question. I want to append an order-by clause and a limit-offset clause to the sql. The order by field is dynamic and decided by user input as well as the limit offset param. 
  The realtime sql like this:</p>
  
  <pre class="lang-sql prettyprint-override"><code>select * from table1 where report_date = '20190801' order by id desc limit 0,10
  </code></pre>
  
  <p>or</p>
  
  <pre class="lang-sql prettyprint-override"><code>select * from table1 where report_date = '20190801' order by name asc limit 5,20
  </code></pre>
  
  <p>How to generate the sql from the template and realtime input with jOOQ?</p>