Roast the squash and tomatoes: Preheat oven to 375°F (190°C). Cut the squash in half and remove the seeds. Coat squash in olive oil, salt, and pepper and roast cut-side down until tender, about 30 minutes. If using fresh tomatoes, roast until softened and browned (also about 30 minutes). Remove their skins and strain off excess liquid.
Prepare the vegetables: Thinly slice the leek, rinse thoroughly to remove any dirt, and dice the onion, carrots, and celery. Mince the garlic.
Saute the vegetables: Heat a little olive oil or butter in a large Dutch oven over medium heat. Add the leek, onion, carrots, and celery with a pinch of salt. Saute for several minutes until softened.
Add the aromatics: Stir in the garlic, tomato paste, Italian seasoning, and 2 teaspoons of fine sea salt. Cook for about a minute, stirring frequently.
Add the tomatoes, squash, and stock: Add the canned whole tomatoes, chicken stock, and roasted squash flesh. Add the optional roasted tomatoes, if using.
Simmer: Bring to a gentle simmer and cook for about 20 to 25 minutes, until the vegetables are completely tender and the flavors have come together.
Blend until creamy: Use an immersion blender or carefully transfer the soup to a countertop blender in batches. Blend until smooth.
Add the beans: Stir in the drained and rinsed butter beans. Simmer until heated through.
Finish the soup: Stir in the heavy cream and dry sherry. Taste and adjust the seasoning. Add water as needed to reach your preferred consistency.
Serve: Ladle into bowls and serve warm with crusty bread or a garlic butter baguette.