Not if the substance is a liquid at room temperature.

Pouring hot bacon grease down the drain will do that, because the bacon grease is only a liquid when it’s hot.

Something like olive oil isn’t going to clog pipes.