By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE users (`id` INTEGER, `name` TEXT);
✓
INSERT INTO users (`id`, `name`) VALUES
('1', 'john'),
('2', 'ada');
✓
CREATE TABLE events (`id` INTEGER, `content` TEXT, `userId` INTEGER);
✓
INSERT INTO events (`id`, `content`, `userId`) VALUES
('1', 'applied', '1'),
('2', 'interviewed', '1');
✓
SELECT json_object(
'name', u.name,
'events', json_group_array(json_object('id', e.id, 'content', e.content))
) result
FROM users u LEFT JOIN events e
ON e.userId = u.id
WHERE u.id = 1
GROUP BY u.id;
{ "code": "SQLITE_ERROR" }