cast_string_* session settings

These settings are available in system.settings and are autogenerated from source.

cast_string_to_date_time_mode

Allows choosing a parser of the text representation of date and time during cast from String. Possible values:

'best_effort' — Enables extended parsing. ClickHouse can parse the basic YYYY-MM-DD HH:MM:SS format and all ISO 8601 date and time formats. For example, '2018-06-08T01:02:03.000Z'.
'best_effort_us' — Similar to best_effort (see the difference in parseDateTimeBestEffortUS
'basic' — Use basic parser. ClickHouse can parse only the basic YYYY-MM-DD HH:MM:SS or YYYY-MM-DD format. For example, 2019-08-20 10:18:56 or 2019-08-20.

Use types inference during String to Dynamic conversio

Use types inference during String to Variant conversion.