title: What is the WITH statement doing in this example? I'm trying to randomly generate data
body: <pre><code>INSERT INTO files (fileUID, filename)
  WITH fileUIDS(fileUID) AS
  ( VALUES(1) UNION ALL
    SELECT fileUID+1 FROM fileUIDS WHERE fileUID &lt; 1000 )
  SELECT fileUID,
         TRANSLATE ( CHAR(BIGINT(RAND() * 10000000000 )), 'abcdefgHij', '1234567890' )
  FROM fileUIDS;
  </code></pre>