[Feature] Support for new microbatching incremental strategy

[jessedobbelaere]

Is this your first time submitting a feature request?

• I have searched the existing issues, and I could not find an existing issue for this feature

Describe the feature

Previously, for large time-series models we needed a custom insert-by-period macro. In this post dbt announced support for the "microbatching" strategy coming to dbt-core 1.9.

This issue is a placeholder to start preparing for the dbt 1.9 release with this new incremental strategy. Work can be tracked in this epic dbt-labs/dbt-core#10624

Describe alternatives you've considered

No response

Who will this benefit?

Datasets that are too big to run on initial full load without batching (Athena query times out)

Are you interested in contributing this feature?

No response

Anything else?

Closes #190 and probably #697