I have the following lines:

Example json data:

{ "products": [ { "logs": [{ "log_time": "2022-07-13 01:30:00", "log_type": "manual", "log_info": "some text" }], "product_id": 123, "time": "2022-07-12 01:30:00" }, { "logs": [], "product_id": 124, "time": "2022-07-13 01:31:00" } ] }

For example searchingproduct_id124, it should return the entire row, but the json field only contains matching objects:

It's also fine if the resulting output contains the original "shape" of json:

{ "products": [ { "logs": [], "product_id": 124, "time": "2022-07-13 01:31:00" } ] }