[Feature] microbatch_size should not be aligned to partition_by

[jschintz-nytimes]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

My upstream data changed & I want to be able to run a large backfill - 8 years worth.
This could be a common occurrence, so I want to set a project variable to change on job run whether the batch size is daily or monthly.

For bigquery, today I get a config error:

Exception on worker thread. Compilation Error in model 
  The 'microbatch' strategy requires a `partition_by` config with the same granularity as its configured `batch_size`.
      Got:
        `batch_size`: month
        `partition_by.granularity`: day

Some incremental strategies don't need this (copy_partitions for sure).
Should this error only occur for merge strategies?

Describe alternatives you've considered

Just run it foe each day - but its wasted time & compute

Who will this benefit?

Users of mcirobatch - specifically BQ adapter

Are you interested in contributing this feature?

Sure

Anything else?

No response