https://github.com/apache/airflow/blob/main/airflow/cli/commands/task_command.py#L145
TR.dag_id == dag_id,
                or_(
                    and_(
                        TR.run_id == run_id,
                        or_(
                            and_(
                                TR.map_index == map_index,
                                or_(
                                    and_(TR.try_number == try_number, TR.task_id.in_(task_ids))
                                    for try_number, task_ids in task_tries.items()
                                ),
                            )
                            for map_index, task_tries in map_indexes.items()
                        ),
                    )
                    for run_id, map_indexes in run_ids.items()
                ),
            )
            for dag_id, run_ids in task_id_by_key.items()
        )
        delete_qry = TR.__table__.delete().where(conditions)
        session.execute(delete_qry)
    if job_ids:
        from airflow.jobs.job import Job
        session.execute(update(Job).where(Job.id.in_(job_ids)).values(state=JobState.RESTARTING))
    if activate_dag_runs is not None:
        warnings.warn(
            "`activate_dag_runs` parameter to clear_task_instances function is deprecated. "
            "Please use `dag_run_state`",
            RemovedInAirflow3Warning,