I've been looking for a unit-testing framework for Cerner CCL (now with Oracle), and it looks like one does exist here:
https://github.com/cerner/cclunit-framework/blob/main/doc/CCLUNITTESTS.md
For those not familiar, Cerner CCL is structured very similarly to SQL, and also contains report-writing features.
What I'm curious about is how to unit-test query data (result-sets returned with a CCL query). Getting into specifics about the Cerner framework is likely a stretch-goal, but if we can't find an answer there, I wonder how this would typically be done with SQL?
This particular testing framework seems to be geared around subroutines / functions, aka asserting the results of functions. So how would one test a CCL (or SQL) query?