Split a string into rows using pure SQLite
<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>