def METHOD_NAME():
    # proj necessary since we need to rename indexed value into a proper attribute name
    assert Team.proj(car_length="car.length").fetch(
        as_dict=True, order_by="car_length"
    ) == [
        {"name": "marketing", "car_length": None},
        {"name": "business", "car_length": "100"},
        {"name": "engineering", "car_length": "20.5"},
    ]
    assert Team.proj(car_length="car.length:decimal(4, 1)").fetch(
        as_dict=True, order_by="car_length"
    ) == [
        {"name": "marketing", "car_length": None},
        {"name": "engineering", "car_length": 20.5},
        {"name": "business", "car_length": 100.0},
    ]
    assert Team.proj(
        car_width="JSON_VALUE(`car`, '$.length' RETURNING float) - 15"
    ).fetch(as_dict=True, order_by="car_width") == [
        {"name": "marketing", "car_width": None},
        {"name": "engineering", "car_width": 5.5},
        {"name": "business", "car_width": 85.0},
    ]
    assert (
        (Team & {"name": "engineering"}).proj(car_tire_pressure="car.tire_pressure")
    ).fetch1("car_tire_pressure") == "[32, 31, 33, 34]"
    assert np.array_equal(
        Team.proj(car_inspected="car.inspected").fetch(
            "car_inspected", order_by="name"
        ),
        np.array([None, "true", None]),
    )
    assert np.array_equal(
        Team.proj(car_inspected="car.inspected:unsigned").fetch(
            "car_inspected", order_by="name"
        ),
        np.array([None, 1, None]),
    )