By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| JSON_ARRAYAGG(CASEWHENT.A<2THENJSON_OBJECT(KEY'A'VALUET.A)ELSENULLEND) |
|---|
| [{"a":1}] |
| JSON_ARRAYAGG(CASEWHENT.A<2THENJSON_OBJECT(KEY'A'VALUET.A)ELSENULLEND) |
|---|
| [{"a":1}] |