Stream: cql
Topic: Intro to CQL
Michael Douglas (Aug 10 2021 at 12:58):
Hey I'm really hoping someone can help me out here - I'm struggling!
I work healthcare EMR company and need to turn our raw clinical data residing BigQuery into CQM measure scores per doctor. I've just stumbled on CQL and it seems like that might be the best tool to get the job done in an efficient manner.
I know SQL and Python. Can anybody point me in the right direction to learn about how to use CQL with SQL and/or Python?
How should underlying data be structured to conform to the "retrieve" CQL command?
Can I download CQL like any other language and use in my IDE?
Is there any place in the internet where someone actually starts with raw claims data, uses CQL, and returns a CQM numerator/denominator?
ANY help would be greatly appreciated!
Bryn Rhodes (Aug 10 2021 at 13:14):
For an introduction to CQL from an SQL developer perspective, see here: https://github.com/cqframework/CQL-Formatting-and-Usage-Wiki/wiki/Developers-Introduction-to-CQL
Bryn Rhodes (Aug 10 2021 at 13:15):
If you use Atom, then yes, there is a plugin you can download to provide language support for CQL: https://github.com/cqframework/atom_cql_support#clinical-quality-language-cql-support-in-atom
Bryn Rhodes (Aug 10 2021 at 13:16):
And for an entry point to the Java-based stack of components for CQL evaluation, look here: https://github.com/dbcg/cql-evaluator#cql-evaluator
Last updated: Apr 12 2022 at 19:14 UTC
