SELECT *
FROM `beer-sample`
WHERE brewery_id IS NOT MISSING AND type="beer"
LIMIT 1;

UPSERT INTO product (KEY, VALUE) VALUES (
    "odwalla-juice1", {
        "productId": "odwalla-juice1",
        "unitPrice": 5.40,
        "type": "product",
        "color":"red"
    }
) RETURNING *;

INFER `beer-sample` WITH {
    "sample_size": 10000,
    "num_sample_values": 1,
    "similarity_metric": 0.0
};