It can also be used as an affectionate term, similar to "small" or "tiny".
Here are some examples:
* "El niño chiquito está jugando." (The little boy is playing.)
* "Dame un poquito de pan." (Give me a little bit of bread.)
* "Tengo un chiquito problema." (I have a little problem.)