So, do we support the ORDER BY in a recursive query or not?
Apparently we do. The "in" recurses.
If the answer is yes, I suggest one of the following modifications:
1. Change the error message to something like "ORDER BY at the top level of a recursive query is not implemented. HINT: wrap the respective statement around ()"
The error message is now correct but I'd lose the hint. It assumes a typo and that the query author meant to sort each iteration of the recursive term; when maybe they did wish for the final result of the completed recursive query to then be fed into a sort node and ordered, in which case the parentheses wouldn't help.
