The items I have in cosmos db have large unstructured data. A part of those items contains information which could look like below:

object_results": {
            "read_file": {
                "step_name": "ReadFile",
                "step_id": "read_file",
                "start_time": "2024-05-23 16:33:56",
                "end_time": null,
                "status": "success"
            },
            "provide_note": {
                "error_message": "Missing category_name for note_key daily_dashboard",
                "step_name": "ProvideNote",
                "step_id": "provide_note",
                "start_time": "2024-05-23 16:35:27",
                "end_time": null,
                "status": "failed"
            }
        }

Sometimes the number of items inside the object_results dictionary could vary dynamically. It can have more child items with different key names inside it as follows:

"object_results": {
            "display_result": {
                "step_name": "DisplayResult",
                "step_id": "display_result",
                "start_time": "2024-05-15 18:54:27",
                "end_time": null,
                "status": "failed"
            },
            "provide_note": {
                "error_message": "Missing category_name for note_key daily_dashboard",
                "step_name": "ProvideNote",
                "step_id": "provide_note",
                "start_time": "2024-05-15 18:58:14",
                "end_time": null,
                "status": "success"
            },
            "get_response": {
                "error_message": "Missing response_subject for response_key consumer_complaints",
                "step_name": "GetResponse",
                "step_id": "get_response",
                "start_time": "2024-05-15 20:13:45",
                "end_time": null,
                "status": "failed"
            }
        }

Now, what I’m trying to extract from this data is all the data where the corresponding status is ‘failed’. But the problem is I’m having to do this only by writing each of the WHERE conditions manually as follows:

select * from response_results res
where res.object_results.provide_note.status = 'failed'
or res.object_results.display_result.status = 'failed'
or res.object_results.get_response.status = 'failed'

Is there a way to make the WHERE conditions generic so that I can fetch all the data containing a failed status irrespective of which key it belongs to?