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
02/25/2019, 11:12 PM
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
02/25/2019, 11:22 PM
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.