Source MySQL should correctly map temporal types to JsonSchema

[edgao]

Currently, source-mysql maps dates, datetimes, and timestamps to string. These should be mapped to date, timestamp_without_timezone, and timestamp_with_timezone respectively.

We should probably do #14628 first.

See e.g. https://github.com/airbytehq/airbyte/blob/master/airbyte-integrations/connectors/source-mysql/src/main/java/io/airbyte/integrations/source/mysql/MySqlSourceOperations.java#L182 (no explicit date/time handling, so they defaults to STRING) and tests (https://github.com/airbytehq/airbyte/blob/master/airbyte-integrations/connectors/source-mysql/src/test-integration/java/io/airbyte/integrations/source/mysql/AbstractMySqlSourceDatatypeTest.java#L237-L238)

[edgao]

this issue is a superset of #3865 (which only mentions DATETIME handling) and #10399 (which only covers DATEs).

[tuliren]

Solution: copy what Postgres temporal processing logic to MySQL, and DRY the code if necessary.

[tuliren]

Hey team! Please add your planning poker estimate with ZenHub @ryankfu @edgao @subodh1810 @rodireich

[tuliren]

This issue is already covered in #14628