[Feature] Support Behavior Flags

[amychen1776]

Is this your first time submitting a feature request?

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

Describe the feature

dbt Core has a functionality called behavior change flags which we should also support on dbt-adapters. This way, adapter maintainers can ship breaking changes without customer projects breaking overnight once users upgrade.

Describe alternatives you've considered

Do not support this—I don't see this as a real option, given that it will be disruptive to users in dbt Cloud who will be upgraded to new functionalities that could cause breaking changes.

Who will this benefit?

dbt users

Are you interested in contributing this feature?

I can write sql :sweat:

Anything else?

No response

[amychen1776]

Closing this since we shipped it