> Is the restriction of CTEs in triggers due to difficulty parsing them Yes. It's a lot more logic that has to be written, tested, debugged, and maintained for 30 years, and that is mostly unused. (You are the first person to complain that it is not present.)