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

Job	Run time
integration-test-gcs	1m 15s
integration-test-s3	1m 21s
integration-test-adls	1m 28s
integration-test	10m 50s
lint-and-unit-test (3.10)	3m 5s
lint-and-unit-test (3.14)	2m 24s
lint-and-unit-test (3.13)	2m 58s
cibw-dev-env-smoke-test	35s
lint-and-unit-test (3.12)	3m 3s
lint-and-unit-test (3.11)	2m 58s
integration-coverage-report	34s
	30m 31s

Provide feedback