title: PostgreSQL ILIKE query with SQLAlchemy
body: <p>I'd like to run a query that selects all posts, case insensitive, that have titles that match <code>'%' + [some_phrase] + '%'</code>. That is, select all rows that have titles that <em>contain</em> some phrase, case insensitive. From the research I've done, it looks like I need to use Postgres's ILIKE query for it to match case insensitive. How can I execute a query like this with SQLAlchemy?</p>
  
  <pre><code>class Post(db.Model):
      id = db.Column(db.Integer, primary_key = True)
      title = db.Column(db.String(250))
      content = db.Column(db.String(5000))
  </code></pre>