I'm checking on variant datatype and noted that whenever a JSON string is stored as a variant datatype in order to filter and value it needs to be casted: i.e
SELECT sum(jsondatavar:Value::double )
FROM table
WHERE jsondatavar:customer ::int= 1000
Here jsondatavar columns holds JSON string as a variant datatype. If we note I need to cast the result as double and filter as int.
Wanted to explore alternatives casting?