def METHOD_NAME(builder, alias: str) -> SelectType:
    OP_MAPPING = {
        "db.redis": "cache",
        "db.sql.room": "other",
    }
    return Function(
        "if",
        [
            Function("in", [builder.column("span.op"), list(OP_MAPPING.keys())]),
            Function(
                "transform",
                [
                    builder.column("span.op"),
                    list(OP_MAPPING.keys()),
                    list(OP_MAPPING.values()),
                    "other",
                ],
            ),
            Function(
                "transform",
                [
                    builder.column("span.category"),
                    [
                        "cache",
                        "db",
                        "http",
                    ],
                    [
                        "cache",
                        "db",
                        "http",
                    ],
                    "other",
                ],
            ),
        ],
        alias,
    )