move update into statement generator