[jeltz]

CTEs can do that, but it is quite clunky for when you just want to reuse a partial per row computation.