Behaviour of __in against foreign keys doesn't behave quite like one might expect about peewee HOT 2 CLOSED

I think there are some problems with your examples -- in the first you're doing an __in on a single model instance -- modb.modela is a single model a associated with the given modb. YOu could rewrite as:

moda = modb.modela

In the second, you want modela records with that aren't related to some given modb... I believe this should work:

modas = ModelA.select().join(ModelB).where(~Q(id=modb.id))

from peewee.

OK -- closing for now, reopen if you get more info.

from peewee.