[Feature] Standardize cancellation behavior via functional tests

[benc-db]

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

Adapter developers should have some standard of behavior to develop against when it comes to cancelling an in progress run. There is not a generic functional test for this behavior, but is there is a functional test for BigQuery. Without this test, it is unclear to adapter developers what expected cancellation behavior looks like. For example, you could let all executing queries complete but not allow any further queries, vs cancelling cursors, vs both.

Describe alternatives you've considered

No response

Who will this benefit?

All users, as adapter behavior becomes more consistent, and adapter developers, as the expected behavior is crystalized in a functional test.

Are you interested in contributing this feature?

No response

Anything else?

No response