[FEA] [EPIC] Priority JSON Issues

[andygrove]

Is your feature request related to a problem? Please describe.
We have a huge list of JSON issues in the original epic. This new epic is for tracking the higher priority issues that we want to focus on for now (24.02 and 24.04)

cuDF Issues:

• [FEA][JSON reader] to support parsing with single quotes rapidsai/cudf#10004
• [FEA] Add JSON reader option to ignore all characters after a valid JSON record rapidsai/cudf#14226
• [FEA] Add option to read JSON field as unparsed string rapidsai/cudf#14239
• [BUG Table.readJson dropping valid JSON lines rapidsai/cudf#14282
• [FEA] Support parsing JSON data to include a Map type rapidsai/cudf#14288
• [FEA] Add ability to read JSON structs as strings, or specify struct schema rapidsai/cudf#14830

Plugin Issues:

• from_json
  • [FEA][JSON] Support temporal types in from_json #9590
  • [BUG] from_json generated inconsistent result comparing with CPU for input column with nested json strings #8558
  • [BUG] [JSON] A mix of lists and structs within the same column is not supported #9353
  • Fix JSON parsing in json to struct function #8204
  • [BUG][JSON] from_json to Map type should produce null for invalid entries #9592
  • [FEA][JSON] Support boolean type in from_json #9597
  • [FEA] Improve performance of from_json #10301
• to_json
  • [FEA] Support to_json function #8780
  • [FEA] Escape JSON strings in to_json #9514
  • [FEA] Support temporal types in to_json #9515
  • [FEA] Add support for JSON data source option ignoreNullFields=false in to_json #9516
  • [FEA] Add support for relevant JSON data source options in to_json #9518
  • [FEA][JSON] Support Decimal type in to_json #9872
• GpuJsonScan
  • [BUG] GpuJsonScan incorrect behavior when parsing dates #9905
  • [BUG] [JSON] GpuJsonScan type checks are not recursive #9775
  • [FEA] Add support for reading nested JSON in GpuJsonScan #10241
  • [FEA] Add support for single quotes when reading JSON #10270
• other
  • [BUG] from_json fails with cuDF error Invalid list size computation error #9212
  • [BUG] Improve support for reading JSON files with malformed rows #9310
  • [FEA] Specify recover_with_null when reading JSON files #9326

There are more JSON issues being tracked in the original JSON epic.