fix: elasticsearch column type mapping

[mapledan]

The datetime field in the CursorDescriptionRow returned by elasticsearch-dbapi is identified as Type.DATETIME=4.
During the creation of the _type_dict, the db_engine_spec.get_datatype method returns an incorrect type.

SUMMARY

BEFORE/AFTER SCREENSHOTS OR ANIMATED GIF

TESTING INSTRUCTIONS

1. Creating a dataset using Elasticsearch.
2. Use the following SQL: select ins_date,cast(ins_date as datetime) as cast_ins_date from my_es.
3. The column type will be correct type.

ADDITIONAL INFORMATION

• Has associated issue:
• Required feature flags:
• Changes UI
• Includes DB Migration (follow approval process in SIP-59)
  • Migration is atomic, supports rollback & is backwards-compatible
  • Confirm DB migration upgrade and downgrade tested
  • Runtime estimates and downtime expectations provided
• Introduces new feature or API
• Removes existing feature or API

[codecov]

Codecov Report

All modified and coverable lines are covered by tests ✅

Project coverage is 69.48%. Comparing base (1776405) to head (d7e6d62).
Report is 1725 commits behind head on master.

Additional details and impacted files

@@            Coverage Diff             @@
##           master   #27148      +/-   ##
==========================================
+ Coverage   67.14%   69.48%   +2.33%     
==========================================
  Files        1901     1901              
  Lines       74444    74450       +6     
  Branches     8304     8304              
==========================================
+ Hits        49989    51728    +1739     
+ Misses      22403    20670    -1733     
  Partials     2052     2052              

Flag	Coverage Δ
hive	53.80% <85.71%> (?)
mysql	78.01% <100.00%> (+<0.01%)	⬆️
postgres	78.11% <100.00%> (+<0.01%)	⬆️
presto	53.75% <85.71%> (?)
python	83.08% <100.00%> (+4.83%)	⬆️
sqlite	77.62% <100.00%> (+<0.01%)	⬆️
unit	56.43% <85.71%> (?)

Flags with carried forward coverage won't be shown. Click here to find out more.

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

[mapledan]

@villebro Is there any need for improvement?

[rusackas]

Convering this to draft since it has conflicts, and hasn't had the conversation or review pushed forward in 9 months. It may be closed in time, but perhaps we can merge it if the conflict is resolved and conversation rekindled :)