title: Create new column with an array of range of numbers
body: <p>So I need to create an array of numbers enumerating from 1 to 100 as the value for each row as an extra column.</p>
  
  <p>Using the <code>array()</code> function with a bunch of literal values works, but surely there's a way to use / convert a Scala <code>Range(a to b)</code> instead of listing each number individually?</p>
  
  <pre><code>spark.sql("SELECT key FROM schema.table")
    .otherCommands
    .withColumn("range", array(lit(1), lit(2), ..., lit(100)))
  </code></pre>
  
  <p>To something like:</p>
  
  <pre><code>withColumn("range", array(1 to 100))
  </code></pre>