[FEATURE] Support RFC3339_LENIENT date format introduced in Opensearch Core.

[vamsi-amazon]

Is your feature request related to a problem?
RFC3339_LENIENT date format was introduced in Opensearch here: opensearch-project/OpenSearch#11465

Add support for the same format in sql and also include relavant tests. For now check_supported_format_names_coverage in [OpenSearchDateTypeTest.java is temporarily fixed here in https://github.com//pull/2476.

Please remove that code after adding the support.

What solution would you like?
A clear and concise description of what you want to happen.

What alternatives have you considered?
A clear and concise description of any alternative solutions or features you've considered.

Do you have any additional context?
Add any other context or screenshots about the feature request here.