> CTE expression is an optimization fence in postgres, which is not the case in oracle.

generally not true since PG12