Deferred Execution Side-Effects and Gotchas

Identify the common traps when mixing stateful side effects within deferred query pipelines.