Non nullable expected to be optional when using sub query

[haringsrob]

Hello!

Not sure what's going on here, may be something obvious.

Given the following struct:

struct Tournament {
    id: u64,
    name: String,
    description: Option<String>,
    players_count: i64,
}

I need to write it as to make it compile (as it otherwise complains id needs to be option)

        let tournaments = sqlx::query_as!(
            Tournament,
            r#"SELECT id as 'id!', name as 'name!', description, (SELECT COUNT(*) FROM player_tournament WHERE tournament_id = t.id) as 'players_count!' FROM tournaments t LIMIT ? OFFSET ?"#,
            per_page.0,
            (page.0 - 1) * per_page.0
        )
        .fetch_all(db)
        .await;

But when I do the follow it is fine:

struct Tournament {
    id: u64,
    name: String,
    description: Option<String>,
}

        let tournaments = sqlx::query_as!(
            Tournament,
            r#"SELECT id, name, description FROM tournaments LIMIT ? OFFSET ?"#,
            per_page.0,
            (page.0 - 1) * per_page.0
        )
        .fetch_all(db)
        .await;

Any pointers to where to look at?