ADAP-1129: Migrate dbt-snowflake into dbt-adapters

[mikealfare]

Migrate dbt-snowflake into this repo using the following shell script and call:

repo=$1
source_branch=$2
target_branch=$3

# create a remote for the legacy adapter repo and fetch the latest commits
git remote remove old || true
git remote add old https://github.com/dbt-labs/$repo.git
git fetch old

# merge the updated branch from the legacy repo into the dbt-adapters repo
git checkout $target_branch
git merge old/$source_branch --allow-unrelated-histories

# remove the remote that was created by this process
git remote remove old || true

source ./scripts/migrate-adapter.sh dbt-snowflake monorepo/stage monorepo/migrate-dbt-snowflake

Update workflows to include dbt-snowflake.

Make updates related with code quality checks due to slightly different config.

Merge the last commit from dbt-snowflake/main into this branch and move the new files into the package subdirectory. Altered files merged as expected.

Merge this PR as a regular merge instead of a squash merge in order to retain git blame history.

[mikealfare]

Integration tests run against this branch: https://github.com/dbt-labs/dbt-adapters/actions/runs/12956948840/job/36144339933