title: jOOQ - query builder with IN predicate
body: <p>I am trying to build a query like this:</p>
  
  <pre><code>List&lt;Integer&gt; ids = ...
  
  String query = DSL.select(TABLE.SOMETHING).from(TABLE).where(TABLE.ID.in(ids)).
  getSQL();
  </code></pre>
  
  <p>But I am not able to get the generated query with the values, just the placeholders. 
  I tried DSL.inline(ids) but it doesnt' work.</p>
  
  <p>How can I do this?</p>
  
  <p>I am using jOOQ 3.4.2.</p>
  
  <p>Thanks for the help.</p>
  
  <p>UPDATE:</p>
  
  <p>Seems I can do this with:</p>
  
  <pre><code>    Configuration configuration = new DefaultConfiguration();
      configuration.set(SQLDialect.DERBY);
      Settings settings = new Settings()
      .withStatementType(StatementType.STATIC_STATEMENT);
      configuration.set(settings);
      DSLContext create = DSL.using(configuration);
  
      String query = create.select(TABLE.SOMETHING).from(TABLE).where(TABLE.ID.in(ids)).getSQL();
  </code></pre>
  
  <p>If someone can confirm that is th right way, thanks.</p>