Since version 0.2.9 that I’ve just released, esqueleto supports IN and EXISTS operators (and their negated counterparts). For example:
select $
from $ \person -> do
where_ $ exists $
from $ \post -> do
where_ (post ^. BlogPostAuthorId ==. person ^. PersonId)
return person
from $ \person -> do
where_ $ exists $
from $ \post -> do
where_ (post ^. BlogPostAuthorId ==. person ^. PersonId)
return person
Enjoy! =)
PS: I’ll try to post more in the future, so keep tuned =).