sqlalchemy, select using reverse-inclusive (not in) list of child column values

Pretty straightforward using negated any:

query = session.query(Post).filter(~Post.tags.any(Tag.name.in_(['dont', 'want', 'these'])))