Allow to choose DateTime parsing mode during

Why it matters

This feature enables more flexible and reliable parsing of String values to DateTime types by allowing users to specify the parsing mode, such as a best effort mode, improving data ingestion and error handling when converting date/time strings.

How to use it

Users can enable or configure the behavior by setting the cast_string_to_date_time_mode setting. For example, to use the best effort parsing mode, set the value accordingly in the server or session settings before executing queries that cast strings to DateTime.