Query JSON with SQL - Selecting specific array values

Hi @Bre! Welcome back to the community. :slightly_smiling_face:

I'm also not sure how to do this with AlaSQL, but it's fairly straightforward with a transformer:

This is probably the more straightforward approach, given the fact that it requires some filtering and string parsing. Let me know if you have any questions!