Unclear how exactly, but the materializers for subqueries have been seen crashing with 2 distinct issues:
KeyError when seeing a delete (because we're assuming a shape will never see a delete without seeing an insert, much less the materializer)
- "duplicate key" when seeing an insert (because we're assuming for a given key we'll never see 2 distinct inserts on the same key)