search

laughingman7743 / PyAthena

PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.
MIT License
459 stars 105 forks source link

SQLAlchemy + Map Types #553

Open Duncan-Hunter opened 1 month ago

Duncan-Hunter commented 1 month ago

Hi,

Do you have any advice on working with Map Types and SQLAlchemy ORM? Is this possible with PyAthena at the moment?

Thanks,

Duncan

laughingman7743 commented 1 month ago

https://github.com/laughingman7743/PyAthena/blob/master/tests/pyathena/sqlalchemy/test_base.py#L277 The current implementation does not support the Map type, so it is handled as a string type. If there is any reference for implementation, it may be possible to implement it in a way that ORM supports.