Add package installation backwards compatibility

[septimit]

Description

Preserve the experience of the package installation prior to the release of dbt-core 1.8.0. This is similar to the other adapters' approach: https://github.com/dbt-labs/dbt-redshift/blob/main/setup.py https://github.com/dbt-labs/dbt-bigquery/blob/main/setup.py https://github.com/dbt-labs/dbt-redshift/blob/main/setup.py

Checklist

• [x] I have run this code in development and it appears to resolve the stated issue
• [ ] This PR includes tests, or tests are not required/relevant for this PR
• [ ] I have updated the CHANGELOG.md with information about my change