Use . to search over text values nested inside JSON. For instance, the following query searches over a field with values like {"metadata": {"color": "white"}}.
Copy
Ask AI
SELECT description, rating, categoryFROM mock_itemsWHERE id @@@ paradedb.term('metadata.color', 'white');