[Feature] Support the basic dbt 1.6 metric

[wcchang1115]

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

What this PR does / why we need it:

• Because dbt 1.6 introduced the new dbt metric, it's the update to support new metric query.

Which issue(s) this PR fixes: sc-32064

Special notes for your reviewer:

Does this PR introduce a user-facing change?:

NONE

[codecov[bot]]

Codecov Report

Merging #870 (c230321) into main (f16c52c) will increase coverage by 0.08%. The diff coverage is 72.19%.

@@            Coverage Diff             @@
##             main     #870      +/-   ##
==========================================
+ Coverage   47.83%   47.92%   +0.08%     
==========================================
  Files          71       71              
  Lines       10021    10189     +168     
==========================================
+ Hits         4794     4883      +89     
- Misses       5227     5306      +79     

Files Changed	Coverage Δ
piperider_cli/runner.py	54.26% <25.00%> (-0.47%)	:arrow_down:
piperider_cli/metrics_engine/metrics.py	23.71% <50.00%> (+1.94%)	:arrow_up:
piperider_cli/dbtutil.py	67.72% <75.44%> (-7.43%)	:arrow_down:

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