fix: apply recursive CTE column-list aliases to the static term

fix: apply recursive CTE column-list aliases to the static term #8530