title: SQL Alchemy - INSERT results of query
body: <p>I'm looking for a way in SQLAlchemy to do a bulk <code>INSERT</code> whose rows are the result of a query.  I know the session has the function <code>add</code> which can be used to add an individual object, but I can't seem to find how how it works with a subquery.</p>
  
  <p>I know I could iterate over the results of the subquery and <code>add</code> them individually, but this would seem to be somewhat inefficient. In my case I am dealing with a potentially very large set of data that needs insertion.</p>