[CT-835] file reformat as part of ergo mats grants work

[McKnight-42]

Describe the feature

align file structure to be more similar to core for housing of overridden macros instead of storing them all in adapters.sql

Who will this benefit?

adapter maintainers, contributors who want to keep like work in sectioned areas

Are you interested in contributing this feature?

yes

[Fleid]

Hey @McKnight-42 is this still a thing?

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please remove the stale label or comment on the issue, or it will be closed in 7 days.