Supposing you couldn't get around the 1000 limit, wouldn't it be more ideal to get a record count and using a row_over() function iterate by a predefined chunk size?