[Feature] Leverage macro to test uniqueness of models

[fivetran-reneeli]

Is there an existing feature request for this?

• [X] I have searched the existing issues

Describe the Feature

With the removal of dbt_expectations dependencies in PR #118 , we should create a macro that tests uniqueness of primary keys in the models, based on the given conditions

"not coalesce(is_x_deleted, false)"

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

• [X] Yes.
• [ ] Yes, but I will need assistance and will schedule time during your office hours for guidance.
• [ ] No.

Anything else?

No response

[fivetran-jamie]

we could probably use the new(?) where config for dbt-native tests