04-14-2023 12:02 AM
select *, PersonalPhones:[0].value as Value from <table_name>
This can give you in the array format
