By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
| json_build_object |
|---|
| {"total" : 3, "results" : [{"id":3,"favorite_color":"blue"}, {"id":4,"favorite_color":"blue"}, {"id":5,"favorite_color":"blue"}]} |
SELECT 1