something like WITH x AS FENCE (...) when they want the fencing behavior, and otherwise assume they don't (but give it to them anyway if there's a data-modifying operation in there).
I would love to be able to test some of our CTE queries in such a scenario.
None of them do data modification. How hard would it be to patch my own build to disable the fence unilaterally for testing purposes?
