PostgreSQL

Type

UUID (Universally Unique Identifiers)

a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11

JSON

row_to_json

SELECT row_to_json(game)
FROM game
WHERE game_id = 1;

json_object_agg

json_agg