title: Is there a way to dynamically generate JOOQ sql statement without knowing column names in advance?
body: <p>I'm trying to put together a SQL generator, so I could dynamically build SQL statements, and pass them onto Spark Job Server.
  When the table columns are known in advance, it seems easy (using JOOQ):</p>
  
  <pre><code>String sql = DSL.select(field("field-1"), field("field-2"), field("field-3"))
          .from(table("myTable"))
  </code></pre>
  
  <p>However, the goal here is to be able to parse an incoming HTTP POST, get the JSON schema out of it, and generate a SQL select statement based on the table structure described in the JSON.</p>
  
  <p>...</p>
  
  <pre><code>List&lt;String&gt; fieldNames = new ArrayList&lt;&gt;();
  fieldNames.add("field-1");
  fieldNames.add("field-2");
  fieldNames.add("field-3");
  </code></pre>
  
  <p>...</p>
  
  <p>JOOQ "field" appears to be a strongly typed object.</p>
  
  <p>Is there a way to build such JOOQ select statement, using such dynamically constructed list of columns?</p>