Is it possible to split strings from a JSON with SQL query?

[bradlymathews]

I recently had an AlaSQL related question that dealt with a comma delimited string. @Kabirdas came up with a bit of syntax that solved my problem. To be honest I have no idea how or why it worked, but it may give you a string to pull and solve your problem:

Using IN( {{array}} ) from a JSON with SQL query

When I want to use an IN() with an array or a comma delimited list of values, for instance using a multi Select component, I would structure my WHERE clause like this: status_id in (SELECT value FROM STRING_SPLIT({{bgStatus.value}}, ',')) But this does not work with AlaSQL, STRING_SPLIT is not a recognized function. I have flailed around trying other things and Googled a lot, I won't bore you with what I tried as they all failed, I cannot fund a way in AlaSQL to get a result set from a delimi…

The other option would be to use a transformer on your SQL to post process the results, looping through each record and using .split() to convert your string into an array.