I used the Lasair API Client object() call with a specific diaObjectId to download the details for that particular object. In the object() call I set lite=False. I see in the returned object the key ‘diaSourcesList’ and within each item in that array the key ‘snr’. How can I write a query/filter for objects where the snr is greater than a particular value? I tried the expression below but received an error that diaSourcesList is not a column in the objects table:
SELECT
objects.diaObjectId,
JSON_EXTRACT(objects.diaSourcesList, ‘$[0].snr’) as snr
FROM objects
WHERE
JSON_EXTRACT(objects.diaSourcesList, ‘$[0].snr’) > 25