Constant GAME_SELECT 

pub const GAME_SELECT: &str = "SELECT g.*,
        (extract(epoch from (clock_timestamp() - g.turn_started_at)) * 1000)::bigint AS elapsed_ms,
        wa.player_id AS w_player_id, wa.username AS w_username, wa.kind AS w_kind, wa.created_at AS w_created_at,
        wa.seen_at AS w_seen_at, wa.marked_at AS w_marked_at,
        ba.player_id AS b_player_id, ba.username AS b_username, ba.kind AS b_kind, ba.created_at AS b_created_at,
        ba.seen_at AS b_seen_at, ba.marked_at AS b_marked_at
   FROM chess.games g
   JOIN chess.accounts wa ON wa.player_id = g.white_id
   JOIN chess.accounts ba ON ba.player_id = g.black_id";