How to query a json array from CloudWatch Log Insights

[nCubed]

When using the logging framework from the power tools, I am trying to create a query in CloudWatch Log Insights to find the value of a key/value json array.

A bare minimum json example:

{
    "message": {
        "parent": {
            "child": {
                "extras": [
                    {
                        "name": "Foo",
                        "value": "Bar"
                    },
                    {
                        "name": "Fizz",
                        "value": "Buzz"
                    }
                ]
            }
        }
    }
}

In this example, how can you write a query to find all the value of the value property when message.parent.child.extras[*].name="Fizz"?

I understand we can create a query get the value by using a direct json path, i.e.,

message.parent.child.extras.1.value

However, that that requires knowing the index of the key/value array. Is it possible to create a query when the index is unknown?