[CT-3546] Remove restrictive pathspec version depencency (upper bound)

[rzjfr]

Is this a new bug in dbt-core?

• I believe this is a new bug in dbt-core
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

Currently pathspec>=0.9,<0.12 which conflicts with latest version of pathspec (0.12.1). I can't find any reason specifically for <0.12. It seems to be consequence of dependebot upgrading more restrictive pathspec~=0.9 here and then later here

Expected Behavior

I can't find any reason to restrict pathspec <0.12. I couldn't find any major change that can break anything related to this package in pathspec change log.

Steps To Reproduce

1. pip install dbt-core==1.7.4 -c <(echo "pathspec==0.12.1")

Relevant log output

The conflict is caused by:
    dbt-core 1.7.4 depends on pathspec<0.12 and >=0.9
    The user requested (constraint) pathspec==0.12.1

Environment

- OS: NA
- Python: >3.8
- dbt: >1.2.6

Which database adapter are you using with dbt?

No response

Additional Context

No response

[WillAyd]

Looking forward to the fix. Airflow 2.8 pins pathspec to 0.12.1 so it is impossible to use the current 1.7.x series there without violating constraints

https://raw.githubusercontent.com/apache/airflow/constraints-2.8.1/constraints-3.11.txt