[Feature] Add restriction to dbt 1.6 metric support

[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:

• We have supported basic dbt 1.6 metric query but have some limitations.

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 #875 (a6b1e35) into main (fb1bbdc) will increase coverage by 0.01%. Report is 8 commits behind head on main. The diff coverage is 60.97%.

@@            Coverage Diff             @@
##             main     #875      +/-   ##
==========================================
+ Coverage   46.39%   46.40%   +0.01%     
==========================================
  Files          75       75              
  Lines       10306    10337      +31     
==========================================
+ Hits         4781     4797      +16     
- Misses       5525     5540      +15     

Files Changed	Coverage Δ
piperider_cli/metrics_engine/metrics.py	24.24% <40.00%> (+0.53%)	:arrow_up:
piperider_cli/dbtutil.py	67.10% <63.88%> (-0.82%)	:arrow_down:

... and 1 file with indirect coverage changes

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