You wouldn’t fetch all the blog titles and store them in an array they would be insane. You would only fetch exactly 10. The rest should be left in the database where they belong. I think you should think of a different practical example for your argument.

You don’t need a generator for accomplish pagination all you need is SQL offset and limit.