feat: add PaginationList for lazy page fetching in catalog list operations #8779

Job	Run time
integration-test-s3	1m 15s
integration-test	5m 39s
integration-test-adls	1m 25s
integration-test-gcs	1m 20s
cibw-dev-env-smoke-test	28s
lint-and-unit-test (3.12)	1m 6s
lint-and-unit-test (3.11)	1m 2s
lint-and-unit-test (3.13)	59s
lint-and-unit-test (3.10)	1m 14s
lint-and-unit-test (3.14)	1m 11s
integration-coverage-report	1s
	15m 40s

Provide feedback