v1.9.0a3

(More work to come in the stable 1.9 release)

Features

• Add structure to support multiple db for async operator execution by @pankajastro in #1483
• Use dbtRunner in the DAG Processor when using LoadMode.DBT_LS if dbt-core is available by @tatiana in #1484
• Support overriding the profile_config per dbt node or folder using config by @tatiana in #1492

Bug Fixes

• Fix select complex intersection of three tag-based graph selectors by @tatiana in #1466

Enhancement

• Fix OpenLineage deprecation warning by @CorsettiS in #1449
• Support overriding the profile_name per node or folder using config by @tatiana in #1492
• Move DbtRunner related functions into dbt/runner.py module by @tatiana in #1480

Others

• GitHub Actions Dependabot: #1487
• Pre-commit updates: #1473, #1493

Cut from: #1492 (branch: override_profile_name_by_task)