title: Bulk move rows from one table to another with SQLAlchemy
body: <p>I have two identical tables <code>post</code> and <code>old_post</code>. I have a query that checks for old posts.  I would like to move the rows returned by the query into the table <code>old_post</code> and delete the rows from table <code>post</code>.</p>
  
  <p>I could solve this by iterating through the results returned by the initial query and update my results this way, however I am worried this is very inefficient and will start to cause me problems when I have 1,000+ rows. How can I efficiently "bulk move" rows from one table to another?</p>