title: Split a string into rows using pure SQLite
body: <p>Using <code>SQLite</code>, I'd like to split a string in the following way.</p>
  
  <p>Input string:</p>
  
  <pre><code>C:\Users\fidel\Desktop\Temp
  </code></pre>
  
  <p>and have the query return these <strong>rows</strong>:</p>
  
  <pre><code>C:\
  C:\Users\
  C:\Users\fidel\
  C:\Users\fidel\Desktop\
  C:\Users\fidel\Desktop\Temp
  </code></pre>
  
  <p>In other words, I'd like to split a file path into its constituent paths. Is there a way to do this in pure SQLite?</p>