title: SQLAlchemy: Inserting the results of a query into another table
body: <p>So I have some results which I've got from the <code>install</code> table, like so: </p>
  
  <pre><code>install = metadata.tables['install']  
  results = session.query(install) #&lt;sqlalchemy.orm.query.Query object&gt;
  </code></pre>
  
  <p>I'd like to insert these same results into the <code>install_archive</code> table.</p>
  
  <p>I'm not entirely sure how to do this, because I don't want to duplicate the schema by defining an <code>install-archive</code> object and then parsing the results into that. I believe I'm not using the ORM, because I'm just <em>reflecting</em> (is that the right term?) the tables and querying them.</p>
  
  <p>All the tutorials I can see use the ORM.</p>
  
  <p>A slow way of doing it, in psudocode, would be:</p>
  
  <pre><code>for id in result.all():
      install_archive.insert(install(id))
  </code></pre>
  
  <p>Thanks in advance!</p>