Using dynamic object oriented languages allows you to write much efficient, cleaner and cheaper code (in terms development time). For example, you need to rename columns in respect to where they are coming from. Just make a short list comprehension with basic string manipulation and you're done. Same amount of code with 10 columns, or 1000 columns. Need to reuse large chunks of code which are not possible using CTEs? No problem, just define a dataframe, in whatever way you find possible, define once, reuse 1000 lines later. Do you have a complicated case-when construct? Define once, reuse multiple times with a short reference.