title: Use variable in sqlalchemy ilike statement
body: <p>I am trying to query my <code>database</code> to find all items that match my variable <code>received_input</code>.</p>
  
  <p>At the moment I have:</p>
  
  <pre><code>session.query(VenueItem).filter(VenueItem.venue_item_name.ilike("%received_input%")).all()
  </code></pre>
  
  <p>The items in my <code>database</code> may contain <code>uppercase</code> and <code>lowercase</code> characters. I need to ensure that the search is <code>case-insensitive</code> (<code>"ApPle"</code> would return from <code>input</code> of <code>"apple"</code>).</p>
  
  <p>I don't know the syntax to specify a <code>variable</code> in <code>ilike</code> as opposed to a <code>string</code>.</p>