After trying different things for hours now it's starting to drive me nuts. So I really hope somebody here could help me with this.

I have a test select query which has only one field that is the result of JSON_OBJECT() function, so that should be JSON (no text). But whatever I try, phpMyAdmin keeps escaping the json keys on an export of the result grid. Which is obviously not what I want when exporting to JSON.

Just a simple example, this: SELECT JSON_OBJECT("key", "value") as json, results into this: screenshot and exports to something like this:

{
    "json": "{\"key\": \"value\"}"
}

Which is obviously no valid json as key should be a key, not part of a string.

Is there somebody out there that could please tell me how to export json data as real json without acting like the output of JSON_OBJECT() is text, so without the wrong escapes?

Thanks in advance!!

Using: - MariaDb 10.4.10 - phpMyAdmin 4.9.2