[FEA] Support multiple compressed inputs in read_json

[vuule]

JSON reader currently concatenates data from all input sources before (optional) decompression and parsing.
This is not correct for compressed input files, as each file is compressed separately.
#12285 disables multiple inputs for compressed data.
read_json should decompress each input file before concatenating the decompressed data.

[karthikeyann]

Note that Only a single source is currently supported in read_csv.
This work could help expand the same feature to csv reader.