Allow reading json arrays

[scsmithr]

Description

Currently we only support reading new line delimited json. I'd to also support complete json arrays so that we can read files in the form of:

[
  {
    <object1>
  },
  {
    <object2>
  }
]

[universalmind303]

this should probably happen upstream in either datafusion or arrow-rs.

[tychoish]

this should probably happen upstream in either datafusion or arrow-rs.

Likely, though I think I'm inclined to implement this locally, and then try and upstream it, unless there's an obvious way to do this trivally in the upstream.

Also sorry for opening the duplicate issue. I'm inclined to keep the #2218 issue open.