title: Joining a PostgreSQL table into another table's column
body: <p>I'm looking for a way to join(?) two tables together, but not in the traditional way of matching foreign keys and creating a row of the match.</p>
  
  <p>For example, if I have a person table and a cars table:</p>
  
  <pre><code>Table person
  | name | age | cars |
  | ---- | --- | ---- |
  | Mike | 41  |  {}  |
  
  Table cars
  | owner | make | model | year |
  | ----- | ---- | ----- | ---- |
  | Mike  | Honda| Civic | 2012 |
  | Mike  | Ford | Focus | 2018 |
  </code></pre>
  
  <p>Is it possible to query a result that looks like this:</p>
  
  <pre><code>{
      name: 'Mike',
      age: 41,
      cars: [{
          make: 'Honda',
          model: 'Civic',
          year: 2012
      },
      {
          make: 'Ford',
          model: 'Focus',
          year: 2018
      }]
  }
  </code></pre>
  
  <p>I'm using node/express/massive if that makes a difference. I'm pretty new to SQL, and for all I know this is a wild goose chase and isn't even possible, but if it is, I certainly don't know how.</p>