pylint singleton-comparison false positive vs. sqlalchemy filter for True/False comparision

[thadeshammer]

Pylint will attempt to mislead us into changing SQLAlchemy/SQLModel filters to make the following change:

select(User).where(Used.deleted == True)  # which is correct for a SQLAlchemy filter

Pylint wants us to change it to

select(User).where(User.deleted is True)  # which will bomb in a SQLAlchemy filter like this

This is slated to be triaged and fixed here: pylint-dev/pylint#9472

I subscribed to that thread, so now, we wait.