Expand JSON_TABLE functionality

[Андрей Щербаков]

I tried to wok with JSON_TABLE and think it is not covered one interesting case.

I have such json: '{"a": 5, "b": 3, "c": 4}'
I want to get this result:
| key | value |
---------------
| a | 5 |
| b | 3 |
| c | 4 |
---------------

One column is key and other - its value. A can't come up with how to get this result.

So, may be, it is possible to expand functionality of JSON_TABLE to something like this:

json_table(
'{"a": 5, "b": 3, "c": 4}',
'$.*' COLUMNS (
key VARCHAR(50) KEY,
value INT PATH '$'
)
)