title: SQLAlchemy injecting data into a query result to be inserted into another table
body: <p>I've found a question on how to insert values from a table into another table:</p>
  <p><a href="https://stackoverflow.com/questions/3070733/sqlalchemy-inserting-the-results-of-a-query-into-another-table">SQLAlchemy: Inserting the results of a query into another table</a></p>
  <p>My query is is slightly different.</p>
  <p>When running a SQL you can do something like this:</p>
  <pre><code>insert into table1(col1, col2)
     select some_constant_value_or_variable, col2 from table2;
  </code></pre>
  <p>Is there a way to do this in SQLAlchemy</p>