title: How do I have a composite field set in JOOQ
body: <p>I have a query with a composite field set (I don't know what else to call it, pls put in comments what the proper term is so I can update)</p>
  
  <pre><code>select
      name,
      `value`
  from
      docs
  where
      superceded_by is null
      and doc_id = 1
      and ( name , effective_on) in (  &lt;----- composite field set
      select
          name,
          max(effective_on)
      from
          docs
      where
          superceded_by is null
          and doc_id = 1
          and effective_on &lt;= '2017-02-01'
      group by
          name )
  </code></pre>
  
  <p>I want to convert that to JOOQ but I can't seem to find an equivalent for it.  I tried <code>DSL.recordType</code> already but it does not support <code>in</code></p>
  
  <p>Here's the query in context</p>
  
  <p><a href="http://sqlfiddle.com/#!9/514a8c7/11" rel="nofollow noreferrer">http://sqlfiddle.com/#!9/514a8c7/11</a></p>