Avoid holding whole transaction in consumer memory

[robacourt]

Part of #3413 and following on from #3414 . The consumer only buffers when the shape depends on subqueries. If the shape does not depend on subqueries, changes are written straight to storage. Storage will also need to be informed of the commit so that it can calculate chunk boundaries.