Are there something like SELECT IF EXISTS...Funktion in Dremio

You seem to be already aware of the kvgen experimental function (mentionned in Elasticsearch query - extract all fields from complex data type (JSON)). Currently, I don’t think we have a different way of discovering if a field is present or not.