[FEA][JSON] Support temporal types in from_json

[andygrove]

Is your feature request related to a problem? Please describe.
PR #9423 adds basic support for from_json, but did not add support for temporal types.

Describe the solution you'd like
Add support for temporal types. We need to look at the date/time format json data source options and see if they apply when calling from_json.

https://spark.apache.org/docs/latest/sql-data-sources-json.html#data-source-option

Describe alternatives you've considered

Additional context