I have some poorly developed json where the developer used data for key names
{"created":"2015-12-01", "ZYS":"BLAH"}
{"created":"2015-12-01", "ZYX":"BLAH"}
{"created":"2015-12-01", "ABC":"BLAH"}
{"created":"2015-12-01", "ADS":"BLAH"}
I'd like to somehow map the key name to a value and give it a generic name
select `created`, somemagic() as value1 from table
Not sure how this would work, or if it's possible, or how I'd even
reference that, but thought I would ask.
John
