Good question! In the nested select you can filter, manipulate and cleanup the data as much as necessary before replacing the space delimiter with your choice of delimiter. ...

Solution 2 can better be accomplished as follows:

select(select name as "data()"

from fruit

...