[Feature] support dbt-core v1.6

[qrtt1]

PR checklist

• [x] Ensure you have added or ran the appropriate tests for your PR.
• [x] DCO signed

What type of PR is this?

feature added

What this PR does / why we need it:

support the dbt-core v1.6 api

Which issue(s) this PR fixes:

sc-32006

[codecov[bot]]

Codecov Report

Merging #840 (f2e23e9) into main (2f96c0b) will decrease coverage by 0.23%. Report is 9 commits behind head on main. The diff coverage is 78.26%.

@@            Coverage Diff             @@
##             main     #840      +/-   ##
==========================================
- Coverage   45.29%   45.07%   -0.23%     
==========================================
  Files          68       69       +1     
  Lines        9710     9769      +59     
==========================================
+ Hits         4398     4403       +5     
- Misses       5312     5366      +54     

Files Changed	Coverage Δ
piperider_cli/dbt/changeset.py	44.68% <42.85%> (-6.02%)	:arrow_down:
piperider_cli/dbt/list_task.py	64.49% <79.41%> (+0.10%)	:arrow_up:
piperider_cli/dbt/__init__.py	85.71% <85.71%> (ø)

... and 4 files with indirect coverage changes

:mega: We’re building smart automated test selection to slash your CI/CD build times. Learn more

[clkao]

@Esya ptal as we noticed you had a temporary fork :)