Speaking from SQLServer perspective, you can return in the below formats
-
Long varchar column and parsing out as a table of values
-
XML/JSON value and parsing XML or JSON using standard functions to get result set of values
-
Table type parameter and return values through it