has anybody come upon the need for a row generation function that splits a string by a delimiter and returns the pieces as separate rows so they could be easily used with the IN clause ? there doesn't exist one in sqlite but may be an useful addition like the current

split

is.

You can probably solve it with sequence generation in SQLite. Not sure if the function is included in osquery, but the docs give an option to do it anyway :) https://www.sqlite.org/series.html

it doesn't seem to be included. i already solved my problem with the with recursive ... sql, but it screams of too complicated solution to a too common problem.