Combine PR below

• airflow-core/tests/unit/models/test_timestamp.py Refactor test_timestamp.py to use SQLA2 #59420
• airflow-core/tests/unit/utils/test_cli_util.py Refactor test_cli_util.py to use SQLA2 #59421
• airflow-core/tests/unit/api_fastapi/execution_api/versions/head/test_task_instances.py Refactor test_task_instances.py to use SQLA2 #59422
• airflow-core/tests/unit/timetables/test_assets_timetable.py Refactor test_assets_timetable.py to use SQLA2 #59423
• airflow-core/tests/unit/models/test_renderedtifields.py Refactor test_renderedtifields.py to use SQLA2 #59425
• airflow-core/tests/unit/assets/test_manager.py Refactor assets test-manager.py to use SQLA2 #59426
• airflow-core/tests/unit/api_fastapi/core_api/routes/public/test_dag_run.py Refactor test_dag_run.py to use SQLA2 #59427
• airflow-core/tests/integration/otel/test_otel.py Refactor test_otel.py to use SQLA2 #59429
• airflow-core/tests/unit/ti_deps/deps/test_runnable_exec_date_dep.py Refactor test_runnable_exec_date_dep.py to use SQLA2 execute pattern #59431
• airflow-core/tests/unit/models/test_dagwarning.py Refactor deprecated SQLA test_dagwarning.py #59434

related: #59402

^ Add meaningful description above
Read the Pull Request Guidelines for more information.
In case of fundamental code changes, an Airflow Improvement Proposal (AIP) is needed.
In case of a new dependency, check compliance with the ASF 3rd Party License Policy.
In case of backwards incompatible changes please leave a note in a newsfragment file, named {pr_number}.significant.rst or {issue_number}.significant.rst, in airflow-core/newsfragments.