Why would you need to get all the orders? What is your use case for needing to return all orders?
I can’t think of any off the top of my head? As Greg already answered most modern rest api’s will have some kind of paged response in order to limit resource usage on their end.. think of a very popular store with perhaps millions of orders in a year..
select * from .. not the best idea from an implementation perspective.