title: How to add rows in BigQuery
body: <p>I have data as in this BigQuery table   </p>
  
  <pre><code>+-------+---------+------+------+
  | chrom |  start  | stop | cons |
  +-------+---------+------+------+
  | chr1  | 1       | 5    | 0.3  |
  | chr1  | 5       | 7    | 0.7  |
  | chr2  | 1       | 3    | 0.2  |
  +-------+---------+------+------+
  </code></pre>
  
  <p>where the value in "cons" is true for every number from start to stop (though the number in stop itself is excluded). Now I'd like to have the data in an non aggregated way, so the table would look like this</p>
  
  <pre><code>+-------+---------+------+------+
  | chrom |  start  | stop | cons |
  +-------+---------+------+------+
  | chr1  | 1       | 2    | 0.3  |
  | chr1  | 2       | 3    | 0.3  |
  | chr1  | 3       | 4    | 0.3  |
  | chr1  | 4       | 5    | 0.3  |
  | chr1  | 5       | 6    | 0.7  |
  | chr1  | 6       | 7    | 0.7  |
  | chr2  | 1       | 2    | 0.2  |
  | chr2  | 2       | 3    | 0.2  |
  +-------+---------+------+------+
  </code></pre>
  
  <p>The </p>
  
  <pre><code>INSERT INTO 
  </code></pre>
  
  <p>command is not supported by BigQuery. Any suggestions for a workaround?</p>