Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Add BigQuery-specific relation naming macros (make_temp_relation, make_intermediate_relation, make_backup_relation, make_relation_with_suffix) to match functionality available in the PostgreSQL
adapter.

Describe alternatives you've considered

Currently, BigQuery adapter lacks standardized relation naming macros that other adapters (like PostgreSQL) provide. This will enable users to run multiple instances of a dbt query simultaneously without relation name collisions.

Who will this benefit?

Users who need to run multiple dbt instances simultaneously (e.g., CI/CD pipelines, parallel development environments) without temporary relation name conflicts

Are you interested in contributing this feature?

Yes, I have a working implementation ready for contribution.

Anything else?

The PostgreSQL adapter includes these macros in postgres/macros/adapters.sql (lines 148-178). BigQuery should have equivalent functionality to ensure adapter consistency and support advanced materialization patterns.