[fifilura]

What I think you'd do here (in modern implementations of SQL at least) is to split the values into an array using some convenient split function and self join on that array to pivot the arrays into rows.

[magicalhippo]

> some convenient split function

If only the DB we're using had one of those :)