Using Postgres JSON Functions on table columns

  
id
data
id
name

1
ap32bbofopvo7pjgo07g
{"context": {"data": {"files": [{"id": 0, "name": "400MB-PDF.pdf", "extension": ".pdf", "transferId": "ap31fcoqcajjuqml6rng"}, {"id": 0, "name": "1000MB-PDF.pdf", "extension": ".pdf", "transferId": "ap31fcoqcajjuqml6rng"}]}}}
0
400MB-PDF.pdf

2
ap32bbofopvo7pjgo07g
{"context": {"data": {"files": [{"id": 0, "name": "400MB-PDF.pdf", "extension": ".pdf", "transferId": "ap31fcoqcajjuqml6rng"}, {"id": 0, "name": "1000MB-PDF.pdf", "extension": ".pdf", "transferId": "ap31fcoqcajjuqml6rng"}]}}}
0
1000MB-PDF.pdf