In addition to this answer, is it possible to extract nested keys in a simple way? Example:

{ "a": value, "b": { "c": value, "d": { "e": value } } }

Desired output: ['a', 'b.c', 'b.d.e'] What I've tried:

SELECT f.`id` AS `field_name` FROM table t, JSON_TABLE( JSON_KEYS(t.`column`, '$.b'), '$[*]' COLUMNS( `id` VARCHAR(191) PATH '$' ) ) AS t

But this will only show one of the nested keys and skip the outer keys.