title: Join two text() statements in SQLAlchemy
body: <p>What is the recommended way to join two text() statements in SQLAlchemy?</p>
  
  <pre><code>q1 = text('select a, b from table1')
  q2 = text('select b, xxx from table2')
  </code></pre>
  
  <p>How do I join these two statements on column 'b', when none of them has the <code>c</code> (columns) attribute, so I cannot do <code>.outerjoin(q2, q1.c.b == q2.c.b)</code>. The final query I need is following:</p>
  
  <pre><code>SELECT a,b,xxx from table1 left join table2 on table1.b = table2.b;
  </code></pre>
  
  <p>What is the recommended way do it? What is easiest way to "fake" the columns in <code>c</code> ?</p>
  
  <p>Note: I gave simple example with the text statements. In reality, they are much more complicated than this.</p>