DataType parsing no longer works correctly for old formatted timestamps

[alamb]

Describe the bug
DataFusion uses the DateType::try_from impl to parse Strings to DataTypes

For example, we have a function like this:

select arrow_cast('2021-01-01T00:00:00', 'Timestamp(Nanosecond, Some("-05:00"))'

That parses the string "'Timestamp(Nanosecond, Some("-05:00")" into the correct DataType::Timestamp

When testing with the latest (unreleased version) of arrow-rs, I found these query fails now with an error similar to

statement error DataFusion error: Execution error: Unsupported type 'Timestamp\(Nanosecond, None\)'\. Must be a supported arrow type name such as 'Int32' or 'Timestamp\(ns\)'\. Error expected double quoted string for Timezone, got 'None'

I found this while testing upgrading DataFusion to arrow (what will be 57) in this PR:

• Upgrade to arrow/parquet 57.0.0 datafusion#17888

To Reproduce
I am pretty sure this was introduced as part of this PR

• Improve Display formatting of DataType::Timestamp #8425

Expected behavior
The old types should be supported

Additional context

[alamb]

Proposed PR to fix:

• Support old syntax for DataType parsing #8541

[alamb]

label_issue.py automatically added labels {'parquet'} from #8425

[alamb]

label_issue.py automatically added labels {'arrow'} from #8425