Title
#sql
8p8c

8p8c

02/25/2019, 10:53 PM
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.
zwass

zwass

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
8p8c

8p8c

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.