SQLAlchemy filter for rows that do not contain value in an array column
<p>I have 1001 rows in my table.</p>

<pre><code># 1001
print len(Session.query(MyTable).all())
</code></pre>

<p>One row has the string 'Recalled' in the <code>info</code> column, which is an array. </p>

<pre><code># 1
query = Session.query(MyTable)
query = query.filter(MyTable.info.contains(['Recalled']))
print len(query.all())
</code></pre>

<p>But when I negate the filter, I get 0 results, instead of 1000 like I expected.</p>

<pre><code># 0
query = Session.query(MyTable)
query = query.filter(~MyTable.info.contains(['Recalled']))
print len(query.all())
</code></pre>

<p>Why isn't this working?</p>