Usually, Thai sweet chili sauce is quite mild. What you buy from stores is probably kid-friendly. When you make it yourself, however, feel free to make it a little spicier if that's your thing, and in Thailand, they can be up to "medium" spicy. Adding 1-3 Thai chilies per recipe is a good start.