<p><a href="https://github.com/ribasushi" class="user-mention">@ribasushi</a>: The generic operator support is not quite enough for <code>ANY</code>, since the syntax is <code>foo = ANY(?)</code> (see <a href="http://www.postgresql.org/docs/current/static/functions-comparisons.html#AEN19686">http://www.postgresql.org/docs/current/static/functions-comparisons.html#AEN19686</a>):</p>

<pre><code>$ reply
0&gt; my $s = SQL::Abstract-&gt;new
[…]
1&gt; $s-&gt;where({foo =&gt; { -any =&gt; { -value =&gt; [2] } }})
$res[1] = [
  ' WHERE ( foo ANY ? )',
  [
    2
  ]
]

5&gt; $s-&gt;where({foo =&gt; { '=' =&gt; { -any =&gt; { -value =&gt; [2] }}}})
$res[2] = [
  ' WHERE ( foo = (ANY ?) )',
  [
    2
  ]
]
</code></pre>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br>Reply to this email directly or <a href="https://github.com/dbsrgits/sql-abstract/pull/2#issuecomment-70488592">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeAqhT3RG1ebJy2LKuKeEvU_dqep4Kks5njPbDgaJpZM4BwK_I.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
  <div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
    <link itemprop="url" href="https://github.com/dbsrgits/sql-abstract/pull/2#issuecomment-70488592"></link>
    <meta itemprop="name" content="View Pull Request"></meta>
  </div>
  <meta itemprop="description" content="View this Pull Request on GitHub"></meta>
</div>