This SQLModel issue is still open. It hasn't be merged to the code base yet.

I recommend the following code:

select(Team).where(
            Team.heros == None,  # noqa E711 Comparison to `None` should be `cond is None`.
)

select(Team).where(
            Team.heros is None,  # This does not work as intended.
)