def METHOD_NAME():
    # rename columns
    op.alter_column("comp_pipeline", "state", new_column_name="deprecated_state")
    op.alter_column("comp_tasks", "state", new_column_name="deprecated_state")
    # create the old columns again
    op.add_column("comp_pipeline", sa.Column("state", sa.String(), nullable=True))
    op.add_column("comp_tasks", sa.Column("state", sa.Integer(), nullable=True))
    # migrate the columns
    migration_map = {
        "NOT_STARTED": UNKNOWN,
        "PUBLISHED": UNKNOWN,
        "PENDING": PENDING,
        "RUNNING": RUNNING,
        "SUCCESS": SUCCESS,
        "FAILED": FAILED,
    }
    [
        op.execute(
            sa.DDL(
                f"""