Support setting profiles-dir

[ConstantinoSchillebeeckx]

Description

Allows user to set --profiles-dir instead of needing to set the ENV DBT_PROFILES_DIR - setting this option is more flexible than the ENV because it can be done at the command line or as an INI option.

Checklist

• [x] I read the CONTRIBUTING guide and understand what's expected of me
• [x] I ran this code in development and it appears to resolve the stated issue
• [ ] I added tests, or tests are not required/relevant for this PR
• [x] I added an entry to the CHANGELOG detailing the change of this PR

[JCZuurmond]

@ConstantinoSchillebeeckx : I updated the testing matrix. It shows that the set-up fails since dbt 1.4.

[ConstantinoSchillebeeckx]

@JCZuurmond could you kick CI off again please?

[ConstantinoSchillebeeckx]

@JCZuurmond branch protection or repo setup doesn't allow me to merge this - feel free to do it.

[JCZuurmond]

@ConstantinoSchillebeeckx : Your changes are available in the 0.2.0 release. Thanks for your contribution!