The use of temporary Procs. Of course these are written is TSQL but there purpose is to reduce complexity and at the same time handle specialised and particular sessions.
I understand the benefits of polymorphism and temporary Procs can actually create the ladders of Functions and data associated with Object Databases.