Add 'datetime64[ms]': types.DATETIME to _type_map in query.py

[jocowhite]

I'm having a project that is using 'datetime64[ms]' instead of 'datetime64[ns]' so it would be great to add that to the _type_map in query.py in the repo.

https://github.com/narendrans/sqlalchemy_dremio/blame/9cf16392ee0e9ca18f241c7d8f2854d9b099162e/sqlalchemy_dremio/query.py#L31

[kenho811]

I have a similar request.

I also added my comment here: #45 (comment)

[wobu]

if it helps, you could monkey patch the type mapping via:

from sqlalchemy import types
from sqlalchemy.engine import Engine, Inspector
from sqlalchemy.sql.sqltypes import STRINGTYPE

from sqlalchemy_dremio import flight

# SqlAlchemy < 2.0 doesn't have a DOUBLE type, but using Float here would be misleading and can be dangerous for the openmetadata users
class DOUBLE(types.Float):
    __visit_name__ = "DOUBLE"


# monkey patching the sql types of sqlalchemy_dremio package
flight._type_map.update({
    'double': DOUBLE,
    'DOUBLE': DOUBLE,
    'CHARACTER VARYING': STRINGTYPE,
    'BINARY VARYING': types.LargeBinary,
})