> Iterating through that would use lazy evaluation by default, returning row by row from the db as needed.

That's... not an advantage in most cases