title: Case when not equal in jooq
body: <p>I have two case statements in an order by.</p>
  <p>One sorts <code>FIELDB DESC</code> if <code>FIELDA</code> matches a pre-defined list of values. (Unrelated but since I see no way to replace WHEN IN (&quot;val1&quot;, &quot;val2&quot;), I define each value as its own when).</p>
  <pre><code>queryBuilder.addOrderBy(case_(MYTABLE.FIELDA)
    .when(&quot;val1&quot;, MYTABLE.FIELDB)
    .when(&quot;val2&quot;, MYTABLE.FIELDB)
    .desc());
  </code></pre>
  <p>However, I need to sort everything that <em>doesn't match</em> those values by <code>FIELDB ASC</code></p>
  <p>Problem is, I can't see a way to convert this sql to jooq:</p>
  <pre><code>CASE WHEN `mytable`.`fielda` != &quot;val1&quot; THEN `mytable`.`fieldb` END ASC
  </code></pre>