MySQL method to extract all keys in nested JSON string

Question

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.

Answer 1

db<>fiddle here