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


I am pulling data from a Google Sheets API call that has some rows of data with multiple names separated by a comma. I want to write a query to select all the individual names.

I want to split the string by a comma, but it appears that ALASQL does not support STRING_SPLIT. Is there another way to split my data?

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:

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.