title: Selecting conditions with jooq
body: <p>In SQL, I can execute a query of type:</p>
  
  <pre><code>SELECT cost &gt; 1000 AS above_k, name FROM products;
  </code></pre>
  
  <p>Giving me a list:</p>
  
  <pre><code>+---------+--------+
  | above_k | name   |
  +---------+--------+
  | true    | Gold   |
  | false   | Silver |
  +---------+--------+
  </code></pre>
  
  <p>How can I model a similar query using <code>jooq</code>? I cannot do this (obviously):</p>
  
  <pre><code>ctx.select(Tables.PRODUCTS.COST.gt(1000))
  </code></pre>
  
  <p>Since, there is no method <code>select(Condition condition)</code>. Or if I just wanted to:</p>
  
  <pre><code>SELECT cost*0.9 AS discounted_cost FROM products;
  </code></pre>
  
  <p>Is there a way to do this using jooq?</p>