ESQL String Aggregate

Hello,

I am trying to create an ESQL query that groups  the results by the Test Case ID. For example, if I have the following table:

I want an ESQL query the groups the Requirements by Test Case ID and outputs:

For SQL, it appears that the query would be:

SELECT TEST_CASE_ID, STRING_AGG(REQUIREMENT_NAME,',') AS REQUIREMENTS

FROM SpiraTestEntities.R_RequirementTestCases

GROUP BY TEST_CASE_ID

However, ESQL removed the STRING_AGG function. Is there another way to do this?