JSON Path is a path expression language similar to XPath to select values inside a JSON value
The following json_exists() call would return all rows from the table where the JSON column contains at least one array element in the array "orders" that has a key "num_pieces" with a value greater than 10
select * from some_table where json_exists(json_column, '$.orders[*] ? (@.num_pieces > 10)');