Kubadilisha SQL kwa JSON

Data ya ingizo
bfotool loadding
Data ya matokeo
bfotool loadding

Mfano wa SQL kwa Json

Data ya Kuingiza

CREATE TABLE peoples(
    id INTEGER PRIMARY KEY,
    name CHAR(20),
    age CHAR(2)
);

INSERT INTO peoples VALUES (1, 'name 1', '22');
INSERT INTO peoples VALUES (2, 'name 2', '33');
INSERT INTO peoples VALUES (3, 'name 3', '44');
INSERT INTO peoples VALUES (4, 'name 4', '55');

SELECT * FROM peoples

Data ya Pato

[
    {
        "id": "1",
        "name": "name 1",
        "age": "22"
    },
    {
        "id": "2",
        "name": "name 2",
        "age": "33"
    },
    {
        "id": "3",
        "name": "name 3",
        "age": "44"
    },
    {
        "id": "4",
        "name": "name 4",
        "age": "55"
    }
]