async def METHOD_NAME(cls) -> AsyncIterator[Tuple[str, str]]:
    query = "SELECT cog_name, cog_id FROM red_config.red_cogs"
    log.invisible(query)
    async with cls._pool.acquire() as conn, conn.transaction():
        async for row in conn.cursor(query):
            yield row["cog_name"], row["cog_id"]