The company in question is Epic Systems, maker of very popular medical records software.
The company in question is Epic Systems, maker of very popular medical records software.
Looking back I can see why post-processing SQL query results using a procedural section at least gives you an escape hatch to do business reports or other iterative tasks.
I don't miss it, but I can see why CCL was designed and written at the time.
From what I understand, getting to that point required a huge amount of effort on the provider's part (many thousands of hours of contractors configuring systems deep in the bowels of hospitals or data centers). But that's not surprising: anything regarding health and IT in the US eventually grows to consume our entire economy.
The only answer is automation, and in a safety critical role like healthcare, automation has to be done with great care.
But from Epic and the higher-ups (who have to defend their expensive acquisition), it's always the same reply even to the most concrete of criticism: you just don't like change! At some point it really moved beyond just a bad excuse and became victim blaming.
(Please know that the context here - and I think in our neighbouring countries as well - is not that there was no automation, rather there were a set of mostly functional solutions in each region that were replaced by a single top-down mandated country-wide system. There was a book published recently about the process that led to the implementation of Epic's system from which I did not get the impression that this was based on merit as much politics.)
So yeah, be worried.
Medical software dev in the US is a dumping ground for the under-qualified or people looking to coast the balance of their career.