CREATE TABLE weapon(
    damage INT,
    name text
);

INSERT INTO weapon VALUES
(12, 'dagger'),
(20, 'sword'),
(25, 'battleaxe');

SELECT json_agg(weapon.*) FROM weapon;