def METHOD_NAME() -> Dict[int, Dict[str, Union[int, datetime.datetime]]]:
    sql = """
        SELECT
            season_id,
            start_date,
            end_date,
            DATEDIFF(IFNULL(FROM_UNIXTIME(end_date), NOW()), FROM_UNIXTIME(start_date)) AS length_in_days,
            num_decks,
            num_league_decks,
            num_people,
            num_competitions,
            num_archetypes,
            num_matches,
            num_cards
        FROM
            _season_stats
    """
    stats = {r['season_id']: r for r in db().select(sql)}
    for season in stats.values():
        season['start_date'] = dtutil.ts2dt(season['start_date'])
        season['end_date'] = dtutil.ts2dt(season['end_date']) if season['end_date'] else None
    return stats