SQLite Forum

[Feature Request] split string table-valued function
Login
Now that SQLite support table-valued functions, could we please have `split`?  
And conversely, a `join` aggregate / window function would also be great, no?  
These belong in the SQLite Core IMHO.

And in the mean time, can someone please share how to emulate `split` with a CTE?

I have an existing DB with a column containing space separate values,  
which I need to split / transpose into rows for further processing (joins, etc...)