That said, I can trick it if I have a view on a remote server and then attach it as a remote partition through the foreign data wrapper.
Are there any dangers that should be considered with such an approach?
I noticed that attaching the "_RETURN" rule to a table converts it to a view, and the operation is irreversible, i.e. once attached, I cannot drop the rule and put the relation back to a table one.
