Refactor insert/materialize node schemas.

This is pretty much the intended usage of temp tuple -- to grab for short-term use a long-term tuple with the correct schema and pre-allocated tuple storage, usually as a pre-image for inserting or updating into the corresponding table.