Third Party Integration Issues

    Two errors which can occur are ProgrammingError: can't adapt type 'numpy.int64' on a backend such as psycopg2, and ; in more recent versions of SQLAlchemy this may be ArgumentError: SQL expression for WHERE/HAVING role expected, got True.

    In the latter case, the issue is due to the numpy.int64 datatype overriding the __eq__() method and enforcing that the return type of an expression is or numpy.False, which breaks SQLAlchemy’s expression language behavior that expects to return expressions from Python equality comparisons:

    SQL expression for WHERE/HAVING role expected, got True

    See .