Integrating arrow with PyMySQL

[laundmo]

To use arrow with PyMySQL you can monkey patch the datetime module (sql -> python) and add a new converter (python -> sql)

from arrow import Arrow
import pymysql.converters
import datetime
from types import SimpleNamespace

# monkey-patch datetime module in converters
pymysql.converters.datetime = SimpleNamespace(  # type: ignore
    date=datetime.date, time=datetime.time, datetime=Arrow
)

# add new conversion for Arrow
pymysql.converters.conversions[Arrow] = pymysql.converters.escape_datetime

# test it
if __name__ == "__main__":
    import arrow
    import pymysql

    conn = pymysql.connect(
        ...
    )
    with conn.cursor() as c:
        c.execute("SELECT NOW()")
        print(c.fetchall())
        print(c.mogrify("%s", (arrow.now(),)))

This has worked without issue for me, but it's still a hack. YMMV.
Hope this can help someone.