title: How to get all the result columns from database with other custom(concat, sum, count) columns in Jooq
body: <p>I have a table Table1 with 6 columns.</p>
  
  <p>Here is the sql statement that i need to map.</p>
  
  <pre><code>Select *,count(ID) as IdCount from Table1;
  </code></pre>
  
  <p>Now, the sql query result will be 7 columns ( 6 Table1 columns and 1 IdCount column). But when i implement the same in Jooq with this query, it only gets a single column "IDCount".</p>
  
  <pre><code>SelectQuery q = factory.selectQuery();
          q.addSelect(Table1.ID.count().as("IdCount"));
          q.addFrom(Table1.TABLE1);
  </code></pre>
  
  <p>Now, the resultant recordset have only a single column "IdCount" while what i need is all the columns and one additional column "IdCount". I want 7 columns in Jooq too.</p>