title: SQLAlchemy filter query "column LIKE ANY (array)"
body: <p>Hi SQLAlchemy experts out there, here's a tricky one for you:</p>
  
  <p>I'm trying to write a query that resolves into something like:</p>
  
  <pre><code>SELECT * FROM MyTable where my_column LIKE ANY (array['a%', 'b%'])
  </code></pre>
  
  <p>using SQLAlchemy:</p>
  
  <pre><code>foo = ['a%', 'b%']
  
  # this works, but is dirty and silly
  DBSession().query(MyTable).filter("my_column LIKE ANY (array[" + ", ".join(["'" + f + "'" for f in token.tree_filters]) + "])")
  
  # something like this should work (according to documentation), but doesn't (throws "AttributeError: Neither 'AnnotatedColumn' object nor 'Comparator' object has an attribute 'any'"
  DBSession().query(MyTable).filter(MyTable.my_column.any(foo, operator=operators.like)
  </code></pre>
  
  <p>Any solutions?</p>