JSON with No root node - Format from XML output - SQL

  
cid
name
age
volunteer
address

1
1001
Jack
25
True
test address1

2
1002
Brandy
34
False
test address2

3
1003
Vincent
14
False
test address3

4
1004
Rado
35
True
test address4


  
cid
xml_data

1
1001
<Final><cid>1001</cid><name>Jack</name><age>25</age><volunteer>1</volunteer><address>test address1</address></Final>

2
1002
<Final><cid>1002</cid><name>Brandy</name><age>34</age><volunteer>0</volunteer><address>test address2</address></Final>

3
1003
<Final><cid>1003</cid><name>Vincent</name><age>14</age><volunteer>0</volunteer><address>test address3</address></Final>

4
1004
<Final><cid>1004</cid><name>Rado</name><age>35</age><volunteer>1</volunteer><address>test address4</address></Final>