title: Which column type has support for lists in sqlalchemy?
body: <p>I'm currently setting up a database for solar active regions and one of the columns is supposed to get the region number which, for now, I have declared in the following way:</p>
  
  <pre><code>noaa_number = sql.Column(sql.Integer, nullable=True)
  </code></pre>
  
  <p>However, since a new number may be assigned as the region evolves, which column type would better support a list to keep all the numbers that a given region is given? So instead of having an entry like:</p>
  
  <pre><code>noaa_number = 12443
  </code></pre>
  
  <p>I could have my result stored as:</p>
  
  <pre><code>#a simple entry
  noaa_number = [12443]
  #or multiple results
  noaa_number = [12444,12445]
  </code></pre>
  
  <p>Where these elements in the list would be integers.</p>
  
  <p>I was checking the <a href="https://docs.sqlalchemy.org/en/latest/core/type_basics.html#generic-types" rel="nofollow noreferrer">documentation</a> and the best idea I had was to place this column as a string and parse all the numbers out of it. While that would work just fine I was wondering if there is a better and more appropriate way of doing so.</p>