As for the field C to be not updating, you might want to explicitly reference the field\_c
in the field\_a
that is still UNNEST, you can try to update below:
from
"@var\_b" AS field\_b,
field\_c AS field\_c
to
"@var\_b" AS field\_b,
a.field\_c AS field\_c