MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

8.0.27

SET @json='{"options":{"2022-03-04":{"c":{"200.00":{"oi":0,"l":635,"b":636.85,"a":640.2,"v":10},"250.00":{"oi":2,"l":594.1,"b":586.85,"a":590.2,"v":5}},"p":{"200.00":{"oi":2150,"l":0.03,"b":0,"a":0.01,"v":11},"250.00":{"oi":518,"l":0.01,"b":0,"a":0.01,"v":0}}},"2022-03-11":{"c":{"200.00":{"oi":0,"l":631.65,"b":637.2,"a":639.85,"v":1},"250.00":{"oi":5,"l":596.7,"b":587.2,"a":589.85,"v":5}},"p":{"200.00":{"oi":1138,"l":0.01,"b":0,"a":0.01,"v":39},"250.00":{"oi":371,"l":0.01,"b":0,"a":0.01,"v":65}}}}}';
SELECT * FROM JSON_KEYS(SELECT JSON_VALUE(@json,"$.options") ,"$[*]")
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SELECT JSON_VALUE(@json,"$.options") ,"$[*]")' at line 1

select @json;

@json

{"options":{"2022-03-04":{"c":{"200.00":{"oi":0,"l":635,"b":636.85,"a":640.2,"v":10},"250.00":{"oi":2,"l":594.1,"b":586.85,"a":590.2,"v":5}},"p":{"200.00":{"oi":2150,"l":0.03,"b":0,"a":0.01,"v":11},"250.00":{"oi":518,"l":0.01,"b":0,"a":0.01,"v":0}}},"2022-03-11":{"c":{"200.00":{"oi":0,"l":631.65,"b":637.2,"a":639.85,"v":1},"250.00":{"oi":5,"l":596.7,"b":587.2,"a":589.85,"v":5}},"p":{"200.00":{"oi":1138,"l":0.01,"b":0,"a":0.01,"v":39},"250.00":{"oi":371,"l":0.01,"b":0,"a":0.01,"v":65}}}}}

SELECT JSON_EXTRACT(@json,"$.options");

JSON_EXTRACT(@json,"$.options")

{"2022-03-04": {"c": {"200.00": {"a": 640.2, "b": 636.85, "l": 635, "v": 10, "oi": 0}, "250.00": {"a": 590.2, "b": 586.85, "l": 594.1, "v": 5, "oi": 2}}, "p": {"200.00": {"a": 0.01, "b": 0, "l": 0.03, "v": 11, "oi": 2150}, "250.00": {"a": 0.01, "b": 0, "l": 0.01, "v": 0, "oi": 518}}}, "2022-03-11": {"c": {"200.00": {"a": 639.85, "b": 637.2, "l": 631.65, "v": 1, "oi": 0}, "250.00": {"a": 589.85, "b": 587.2, "l": 596.7, "v": 5, "oi": 5}}, "p": {"200.00": {"a": 0.01, "b": 0, "l": 0.01, "v": 39, "oi": 1138}, "250.00": {"a": 0.01, "b": 0, "l": 0.01, "v": 65, "oi": 371}}}}

SELECT JSON_EXTRACT(JSON_KEYS(JSON_EXTRACT(@json, '$.options')),"$[*]")

JSON_EXTRACT(JSON_KEYS(JSON_EXTRACT(@json, '$.options')),"$[*]")

["2022-03-04", "2022-03-11"]

WITH RECURSIVE cte1 AS (
    SELECT 0 as x
    UNION ALL
    SELECT x+1 FROM cte1 WHERE x<10)
SELECt * FROM (
SELECT JSON_EXTRACT( 
       (SELECT JSON_EXTRACT(JSON_KEYS(JSON_EXTRACT(@json, '$.options')),"$[*]")),
       CONCAT("$[",x,"]")) as d
FROM cte1
) xx
WHERE not d is null

d

"2022-03-04"

"2022-03-11"

SELECT JSON_EXTRACT(@json,"$.options.\"2022-03-04\"");

JSON_EXTRACT(@json,"$.options."2022-03-04"")

{"c": {"200.00": {"a": 640.2, "b": 636.85, "l": 635, "v": 10, "oi": 0}, "250.00": {"a": 590.2, "b": 586.85, "l": 594.1, "v": 5, "oi": 2}}, "p": {"200.00": {"a": 0.01, "b": 0, "l": 0.03, "v": 11, "oi": 2150}, "250.00": {"a": 0.01, "b": 0, "l": 0.01, "v": 0, "oi": 518}}}

WITH RECURSIVE cte1 AS (
    SELECT 0 as x
    UNION ALL
    SELECT x+1 FROM cte1 WHERE x<10)
SELECt 
   JSON_UNQUOTE(d) d, 
   JSON_EXTRACT(@json,CONCAT("$.options.",d,".c")) c,
   JSON_EXTRACT(@json,CONCAT("$.options.",d,".p")) p
FROM (
   SELECT JSON_EXTRACT( 
       (SELECT JSON_EXTRACT(JSON_KEYS(JSON_EXTRACT(@json, '$.options')),"$[*]")),
       CONCAT("$[",x,"]")) as d
   FROM cte1
   ) xx
WHERE not d is null

d
c
p

2022-03-04
{"200.00": {"a": 640.2, "b": 636.85, "l": 635, "v": 10, "oi": 0}, "250.00": {"a": 590.2, "b": 586.85, "l": 594.1, "v": 5, "oi": 2}}
{"200.00": {"a": 0.01, "b": 0, "l": 0.03, "v": 11, "oi": 2150}, "250.00": {"a": 0.01, "b": 0, "l": 0.01, "v": 0, "oi": 518}}

2022-03-11
{"200.00": {"a": 639.85, "b": 637.2, "l": 631.65, "v": 1, "oi": 0}, "250.00": {"a": 589.85, "b": 587.2, "l": 596.7, "v": 5, "oi": 5}}
{"200.00": {"a": 0.01, "b": 0, "l": 0.01, "v": 39, "oi": 1138}, "250.00": {"a": 0.01, "b": 0, "l": 0.01, "v": 65, "oi": 371}}

d	c	p
2022-03-04	{"200.00": {"a": 640.2, "b": 636.85, "l": 635, "v": 10, "oi": 0}, "250.00": {"a": 590.2, "b": 586.85, "l": 594.1, "v": 5, "oi": 2}}	{"200.00": {"a": 0.01, "b": 0, "l": 0.03, "v": 11, "oi": 2150}, "250.00": {"a": 0.01, "b": 0, "l": 0.01, "v": 0, "oi": 518}}
2022-03-11	{"200.00": {"a": 639.85, "b": 637.2, "l": 631.65, "v": 1, "oi": 0}, "250.00": {"a": 589.85, "b": 587.2, "l": 596.7, "v": 5, "oi": 5}}	{"200.00": {"a": 0.01, "b": 0, "l": 0.01, "v": 39, "oi": 1138}, "250.00": {"a": 0.01, "b": 0, "l": 0.01, "v": 65, "oi": 371}}