gotcha moderate 127d ago
SQLAlchemy @property attributes cannot be used in queries
When an SQLAlchemy model has a @property (like image_url derived from a JSON column), using it in queries like Artist.image_url.isnot(None) fails with 'property object has no attribute isnot'. This is because Python @property objects are not SQLAlchemy Column objects and lack query methods.
sqlalchemypythonormpropertyquery