title: Strange translation of jOOQ query for array contains function
body: <p>I have the following type in my PostgreSQL database :</p>
  
  <pre><code>myoptions text[]
  </code></pre>
  
  <p>I use a jOOQ converter so that I have a Set as corresponding type in my record :</p>
  
  <pre><code>Set&lt;String&gt; myoptions
  </code></pre>
  
  <p>In my query I have the following Condition :</p>
  
  <pre><code>c.MYOPTIONS.contains(Sets.newHashSet("option1"))
  </code></pre>
  
  <p>which is translated in SQL like this :</p>
  
  <pre><code>cast("c"."myoptions" as varchar) like ('%' || '[option1]' || '%') escape '!'
  </code></pre>
  
  <p>Is it the normal behavior ?</p>
  
  <p>I would like to have something like :</p>
  
  <pre><code>c.myoptions @&gt; ARRAY['option1']
  </code></pre>
  
  <p>or</p>
  
  <pre><code>'option1' = ANY(c.myoptions)
  </code></pre>
  
  <p>Thanks in advance for your help</p>