I enjoyed this post on pull/push based query engines - its examples were wonderfully simple.

https://justinjaffray.com/query-engines-push-vs.-pull/