By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 3 Duplicates: 0 Warnings: 0
| CAST(metadata AS CHAR) |
|---|
| [{"key": "field_1", "value": "test_1"}, {"key": "field_2", "value": "test_2"}] |
| [{"key": "field_1", "value": "1"}, {"key": "field_2", "value": "test_2"}] |
| [{"key": "field_2", "value": "test_2"}, {"key": "field_1", "value": "test_1"}] |
| CAST(metadata AS CHAR) |
|---|
| [{"key": "field_1", "value": "test_1"}, {"key": "field_2", "value": "test_2"}] |
| [{"key": "field_2", "value": "test_2"}, {"key": "field_1", "value": "test_1"}] |