Use SQL loop query to unnest nested list

• Use a recursive CTE (Common Table Expression) to unnest the nested list

• Join the CTE with the original table to retrieve the unnested data

• Consider using function...read more