Can you please update Microsoft docs here to highlight that there is a 1000 record limitation??
Also can you please increase the limit to 2000 - in line with the 'Data row limit for non-delegable queries'?
At least the documentation should mention the limit. There is already a paragraph dedicated to this, so please add a line in there.