title: Can I perform a INSERT-SELECT operation with the Rails API?
body: <p>I have to duplicate a BLOB field from one table into another and I want to use a INSERT-SELECT query to achive this. </p>
  
  <pre><code>INSERT INTO target_table (key, data, comment)
      SELECT 'my key', data, 'some comment' FROM source_table
  </code></pre>
  
  <p><strong>Can this be done with the Rails API?</strong></p>
  
  <p>Of course I could always use <code>ActiveRecord::Base.connection</code> to send a native query to the database, but I'm hoping to find a "Rails way" to do this. (One which doesn't involve actually loading the data in my Rails application)</p>