The best type of pumpkin for homemade purée is actually … not a pumpkin! Hard winter squash make a superior purée to pumpkin (which often yields fibrous, watery results). If you insist on using pumpkin, seek out small sugar pumpkins at your farmers market or store. They work much better than the large carving pumpkins, which are best saved for your spookiest designs.