title: Intersect sqlalchemy query objects
body: <p>I have a two sqlalchemy query objects (q1 and q2) - they both belong to the same table and I want to be able to intersect the two queries. Since my database is MySql, q1.intersect(q2) throws sql syntax error. Is there a way to perform intersect MySql queries in sqlalchemy? My research pointed at using subqueries, aliases and left joins but all these solutions are native sql queries. I am looking for a sqlalchemy syntax.</p>
  
  <p>Query:</p>
  
  <pre><code>q1 = Model1().query().filter(Model1.description.ilike(%aws%)) 
  q2 = Model1().query().filter(Model1.tags.ilike(%cloud%)) 
  </code></pre>
  
  <p>I want to return <code>q1.intersect(q2)</code></p>
  
  <p>Also, what I have specified here as queries is just one of the cases of a broader set. I have a function which takes in an operator (and/or) and two operands(sql alchemy query objects, q1 and q2) which can be different and complex for different function calls. In this case, I cannot do a nested filter. I need to work with just q1 and q2.</p>