Or you could just create a View for flagged posts and join on that as appropriate, no ORM needed. There's probably some room for limited compositional SQL, but

Or you could just create a View for flagged posts and join on that as appropriate, no ORM needed. There's probably some room for limited compositional SQL, but there are ways to get that without a full ORM, given your type system is expressive enough.