title: How do I do "SELECT something IN (...)" with jooq?
body: <p>I'm trying to do the following with Jooq and can't for the life of me figure out how to do it properly:</p>
  
  <pre><code>select name, id in (
    select capability_id 
     from a.capabilities_users 
     where user_id = ?) 
  from a.capabilities;
  </code></pre>
  
  <p>Basically I want to get all items (capabilities) and know whether each one applies to a particular user.  It seems that all the condition type operators (like greater than or in) can only be used in the where and not the select.  And I can't think of how else to express this.</p>
  
  <p>Worst case, I can do a select count and then do the boolean logic in Java, but I was hoping to use fetchMap.</p>