title: how to execute LIKE query in sqlalchemy?
body: <p>I am using <code>sqlalchemy</code> to fetch data from tables.
  Right now fetching all records from a table called <code>audit_trail_table</code> is working as expected.</p>
  
  <pre><code>select_stmt = select([self.audit_trail_table]).where(self.audit_trail_table.c.id == int(id))
  row = conn.execute(select_stmt).fetchone()
  </code></pre>
  
  <p>Now I wish to execute <code>LIKE</code> queries on multiple columns as follows:</p>
  
  <pre><code>filter_query = #(some value which will work as a filter_query while fetching )records
  filter_stmt = select([self.audit_trail_table]).where(self.audit_trail_table.c.first_name like '%' + filter_query + '%' or self.audit_trail_table.c.last_name like '%')
  </code></pre>
  
  <p>But it gives an error at LIKE. How can I achieve this?</p>