By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 1 Duplicates: 0 Warnings: 0
| CAST(data AS CHAR) |
|---|
| {"100": {"1": [[2, 3], 2], "4": [[10], 0]}, "102": {"7": [[5, 6], 5]}} |
| field_a | field_b | field_c |
|---|---|---|
| 100 | 1 | 2 |
| 100 | 1 | 3 |
| 100 | 4 | 10 |
| 102 | 7 | 5 |
| 102 | 7 | 6 |