[Tech Debt] Collapse the db insert into single method to support both append and overwrite. #2093
Description
Seems that there are 2 similar functions for inserting profiler data, but radically different behavior. Workspace artifacts and monitoring metrics leverage this function, which does not support an append. However, serverless SQL pools and dedicated SQL pools leverage a function called save_resultset_to_db, which does support and append. Why the difference in behavior for these sets of Synapse objects? Perhaps combine the functions into a single function and use the mode param to dictate the behavior?
Originally posted by @goodwillpunning in #2020 (comment)