title: Rails create mysql views or virtual table
body: <p>i'm currently trying to find a way how to get data from database as AREL object, which would be easy to paginate.</p>
  
  <p>From database perspective i see that i need to create mysql insertable/updatable view. Since i have two different tables with different column names. Also i don't need all data only some columns.</p>
  
  <p>I'm curious is there a way to do this without mysql views. Just using Active Record</p>
  
  <p>example </p>
  
  <pre><code> | table1: |
   | id, name, desc, quality | 
   | 1,  t1,   d1,   q1 |
   | 2,  t2,   d2,   q2 |
  
   | table2: |
   | id, title, description, etc |
   | 1,  p1,    desc1,       null|
   | 2.  p2,    desc2,       null|
  </code></pre>
  
  <p>I want receive somethig like </p>
  
  <pre><code> | JoinTabe |
   | id, col1, col2 |
   | 1,  t1,   d1   |
   | 1,  p1,   desc1|
   | 2,  t2,   d2   |
   | 2,  p2,   desc2|
  </code></pre>