SELECT *
FROM cache
WHERE JSON_ARRAY_LENGTH(JSON_EXTRACT(data, '$[1].subtitles')) > 0;
these were previously just tuples because of https://github.com/karlicoss/cachew/issues/28, but now can be stored as dicts (which is nice since then you get the field names and its not just a tuple of data)
these were previously just tuples because of https://github.com/karlicoss/cachew/issues/28, but now can be stored as dicts (which is nice since then you get the field names and its not just a tuple of data)