title: Sqlalchemy many to one array response
body: <p>Im working with SQLAlchemy and Flask. I have a content table like:</p>
  
  <pre><code>--------------------------------------------
  |    id   |    title     |   description   |
  --------------------------------------------
  |    1    |    example   |   my content    |
  |    2    | another piece| my other content|
  --------------------------------------------
  </code></pre>
  
  <p>And a status table like this:</p>
  
  <pre><code>--------------------------------------------------------
  |   id   |   content_id  |     status type |    date   |
  --------------------------------------------------------
  |   1    |      1        |      written    |  1/5/2020 |
  |   2    |      1        |      edited     |  1/7/2020 |
  --------------------------------------------------------
  </code></pre>
  
  <p>I want to be able to query the db and get a content with all of the status's in one row instead of have multiple rows of the content repeated. For example I want:</p>
  
  <pre><code>----------------------------------------------------------
  | id  |   title    |   description    |      status's    |
  ----------------------------------------------------------
  |  1  |    example |   my content     |     [1,2]        |
  ----------------------------------------------------------
  </code></pre>
  
  <p>Is there a way to do this with sqlalchemy?</p>