[Feature] I want my unit tests to optionally execute pre/post hooks

[graciegoheen]

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

Some folks use pre/post-hooks do define DML they want to be executed on their model (merge statements, etc.).

Currently, if folks unit test a model that has a pre/post-hook the hook is ignored (not executed) for the unit test.

This prevents some people from accurately testing the output of their model.

We should allow folks to optionally execute the pre/post-hooks on their unit test. The default should continue to be - we don't execute pre/post-hooks.

Likely blocked by this investigation #8499

Describe alternatives you've considered

Folks are unable to accurately unit test models with pre/post-hooks

[graciegoheen]

I'm going to close this out for now - but if you're interested leave a comment and we may re-open in the future!