Select query to convert to array of string

SQL++
1

@vsr1 I have below select query that is resulting in array of objects. How can I retrieve/convert it into array of strings.

select distinct(iRef) from hist where type=“history”
current result: [ { “iRef”: “b0c1c53f” }, { “iRef”: “c8648b6d” },…]

Required output: [“b0c1c53f” , “c8648b6d”, …]

2

@PM789 ,

SELECT DISTINCT RAW iRef
FROM hist
WHERE type = "history";