Backport the new dag test feature to users using Airflow 2.1

[tatiana]

Please describe the feature you'd like to see

SQL SDK 0.1 users should be able to run the SQL workflows using the new implementation of airflow dag test (https://github.com/apache/airflow/pull/26400), even when they are using Airflow 2.1.

Describe the solution you'd like Users using Airflow 2.5 and 2.1 should be able to run the SQL workflows the same way, using the new implementation of airflow dag test

Acceptance Criteria

• [ ] All checks and tests in the CI should pass
• [ ] Unit tests (90% code coverage or more, once available)
• [ ] Integration tests (if the feature relates to a new database or external service)
• [ ] Example DAG
• [ ] Docstrings in reStructuredText for each of methods, classes, functions and module-level attributes (including Example DAG on how it should be used)
• [ ] Exception handling in case of errors
• [ ] Logging (are we exposing useful information to the user? e.g. source and destination)
• [ ] Improve the documentation (README, Sphinx, and any other relevant)
• [ ] How to use Guide for the feature (example)

[tatiana]

@dimberman to help us spec'ing this work

[kaxil]

Can this be closed? or is it still WIP @tatiana @dimberman ?