ADAP-1130: Migrate dbt-bigquery into dbt-adapters

[mikealfare]

Migrate dbt-bigquery 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-bigquery monorepo/stage monorepo/migrate-dbt-bigquery

Update workflows to include dbt-bigquery.

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

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

[mikealfare]

A working run of integration tests for dbt-bigquery against this branch: https://github.com/dbt-labs/dbt-adapters/actions/runs/12762311516