I am using ADLS2 Storage for json files and am trying to read the file from serverless Synapse Analytics.
I can read the file using the normal means (SQL SCRIPT AND JSON_VALUE(doc, '$.date_rep') AS date_reported,) .
THE PROBLEM : The json file has [ ] wrapping the file contents. I cannot modify the files but cannot read using a query because the file is  wrapped.
How do I remove the square brackets from the beginning and end of the json file in the query ( json_modify , ect)