BAQ - Split string into multiple rows

Is there a function in BAQ that can take a field/string with commas and make that into rows? I can do this in SQL, not sure if this can be done with BAQ.

So example would be.

BAQ’s can take most SQL commands. Even if it is in the menu, you can type it in and most of the time it works.

What have you tried do far?

So with the XML output, I created a subquery. I am able to get the xml output from screenshot below. The calculated field is same as my query example.

From the top level query, I tried to create a calculated field with the following:
image image

The issue I am running into is the table relationship from primary query to the subquery. Not sure how I go about doing a cross apply like the below.