ENH: Intermediate join results that preserve data frame alias, similar to SQL joins
Please take a look at this stackoverflow post (this is my post) and let me know what you think.  You can answer the question if you like, but I'm guessing the answer is that there is currently no other way to handle the column conflicts other than using the suffixes keyword.

https://stackoverflow.com/questions/64126437/pandas-merges-and-suffixes

As such, I have been enhancing my Pandas code generator to deal with column conflicts, but would be a really nice Pandas feature to be more "SQL like" in how merges are handled in that the "intermediate results" preserve the original column names and then allow you to reference by dataset alias.

Thanks.
