PoC to use Airflow 2.10.0b1 DatasetAlias in Cosmos

[tatiana]

Context

This ticket aims to PoC on the following:

• Have a Dataset Alias that can be added in DAG parsing time, which contains the dbt project name and the dbt node name
• Use DatasetAlias to inject inlets/outlets during task execution and then, to try to overcome issue Airflow orphaning unreferenced Dataset URIs in Cosmos 1.1 #522

We should reach out to @Lee-W giving feedback.

More context in the epic:
#1119

Acceptance criteria

• Confirm that we can use DatasetAlias
• Confirm that the issue Airflow orphaning unreferenced Dataset URIs in Cosmos 1.1 #522 is resolved
• Confirm that the Datasets / Dataset Aliases are behaving well in the Airflow UI
• Log follow-up tasks to deliver this feature to production (ideally, we'd also analyze and improve the availability of this feature, ATM it is only available for ExecutionMode.LOCAL and ExecutionMode.VIRTUALENV)