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.

Of course you are. But people who ruin other people’s property already don’t give two shits about others.