Have a table which has a column of string type and the data looks like

items
['apple','pear','orange']
['weather','news']
.....

How could I get the first and second items as separated columns

expected output

first_item     second_item
apple          pear
weather        news

tried to cast column as array then slice it but failed

cast(itmes as array(varchar))

got Cannot cast varchar to array(varchar)
Any suggestions?