Confused. Canvas is making me pull my hair out

I should have been clear, that JSON is the working SQL from DEVtools. When used in canvas I used just:

SELECT kubernetes.labels.app FROM "k8s-prod-myapp-*" GROUP BY kubernetes.labels.app

Sorry.