I've just this minute come across this again, with INSERT this time
rather than UPDATE.

For my current problem the following code does not give an error:

INSERT INTO ...
WITH CTE_X AS ( ... )
SELECT ... FROM CTE_X
WHERE ...

--
Tim Ward