[Feature] Support deepdiff v9

[tanguylefloch-veesion]

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

Deepdiff v9 is out, it would be nice to be able to install it alongside this repo.

Describe alternatives you've considered

No response

Who will this benefit?

Everyone who want to use deepdiff >=9 or any dependencies that rely on deepdiff >=9.

Are you interested in contributing this feature?

Eventually

Anything else?

Deepdiff changelog: https://github.com/qlustered/deepdiff/blob/c59636cda63cd3951777208c783285e6bf634159/CHANGELOG.md?plain=1#L3