Content Adapters, get pages of other section

I was trying to mess around with a content adapter that gets the pages of another section. Is that in any way possible?

I was trying to generate an annual archive for the posts in my posts section.

the only way I could think of would be os.Readdir and os.ReadFile

This might be helpful:
https://github.com/jmooring/hugo-module-archive?tab=readme-ov-file#readme