title: how to convert a column to an array in presto
body: <p>Postgres provides a way to turn a column into an array. Samle query:</p>
  <pre class="lang-sql prettyprint-override"><code>WITH
      dataset AS (
          SELECT '1' as a
          union
          SELECT '2' as a
          union
          SELECT '3' as a
      )
  SELECT
      array(select a from dataset) as array_result;
  </code></pre>
  <p>returns</p>
  <pre><code>| array_result |
  |--------------|
  | {2,3,1}      |
  </code></pre>
  <p>How to do the same with Presto SQL?</p>