title: How to insert random data into a SQLite table using only queries?
body: <p>I have a test SQLite table:</p>
  
  <pre><code>CREATE TABLE test (
    id INTEGER PRIMARY KEY NOT NULL, 
    x REAL NOT NULL  DEFAULT (RANDOM()),
    y REAL NOT NULL  DEFAULT (RANDOM()),
    z REAL NOT NULL  DEFAULT (RANDOM())
  )
  </code></pre>
  
  <p>and I want to create over thousands of rows of random data, and how can I do it using a SQL query? I can't use a SQL <code>FOR</code> loop because loops are not supported in SQLite, and I'm thinking of <code>SELECT</code>ing all the data from the table then <code>INSERT</code> for each row, so the number of rows double each time I execute the query. I think that requires a nested query, which I don't understand.</p>