However, at least some ORDER BY queries will have a final sorting step before the client sees the first row. (If you're sorting on a column with an index, it may be able to produce the data in sorted order; if not, though, the final sort seems unavoidable.)
Which means that the capacity to buffer up data until it's all produced is present. But it might still be awkward to make it the default.
Which means that the capacity to buffer up data until it's all produced is present. But it might still be awkward to make it the default.