title: How do I make jOOQ generate a "delete [table].*"?
body: <p>I've created this jOOQ query to delete certain rows from a table :</p>
  <pre><code>    DSLContext ctx = DSL.using(c, SQLDialect.MYSQL);
      ctx.deleteFrom(table(&quot;filestorage&quot;).as(&quot;fis&quot;))
        .where(
          field(&quot;fis.file_id&quot;).eq(storageAudioFile.getId().toString())
          .and(field(&quot;fis.scheme&quot;).eq(storageAudioFile.getScheme()))
          .and(field(&quot;fis.updated&quot;).eq(storageAudioFile.getUpdated()))
        ).limit(1).execute();
  </code></pre>
  <p>This generates a query starting with <code>delete fis from [...]</code> instead of <code>delete fis.* from [..]</code> :</p>
  <pre><code>delete `fis` from filestorage as `fis` where (fis.file_id = ? and fis.scheme = ? and fis.updated = ?) limit ?
  </code></pre>
  <p>I can't find much in the documentation for this, and I've tried to modified the <code>table(&quot;filestorage&quot;)</code> with various different syntaxes - but with no luck.</p>
  <p>How do make jOOQ generate <code>delete fis.* from [...]</code> in this query?</p>