sql: consider adding a `try_parse_mysql_datetime` function

[chuck-alt-delete]

Feature request

The string produced with TEXT COLUMNS (a_timestamp_column) does not match the format try_parse requires to enable temporal filter pushdown.

We should consider adding a new try_parse_mysql_datetime function that handles the MySQL datetime format.

[benesch]

As @rjobanp mentioned on Slack, the TEXT COLUMNS option is performing to spec. The intent is to exactly match the MySQL textual format for the column.

Going to adjust this ask to be about adding something more akin to a try_parse_mysql_datetime function!