Video – CL Expressions vs SQL with Joseph Gartner

Joseph Gartner, PhD, director of data science, walks through a comparison of SQL vs CL Expressions. He outlines how CL Expressions are specifically geared to the types of aggregation and time manipulation that are common in the practice of data science and compares both approaches on mock emergency room utilization data.

Watch the video to see how both approaches manage dynamic medical histories and which approach is more efficient to evaluate individual medical characteristics at specific points in time.

Connect With ClosedLoop

First Name

Last Name



Company Name

Company Size


Here is your file to download.
Oops! Something went wrong while submitting the form.

Video – CL Expressions vs SQL with Joseph Gartner

See What ClosedLoop Can Do For You.

provider icon

Providers & ACOs

Predict the comprehensive chronic and preventive care needs of individual patients with unparalleled precision.

icon showing two people under umbrella


Predict and prioritize high-risk members and use Contributing Factors insights to personalize outreach and interventions.

pharma icon

Pharma & Life Science

Strengthen commercial success, gain precision insights into key cohorts, and power digital therapeutics and value-based contracts.

heart icon with pulse

Digital Health

Distinguish precision cohorts, enable intelligent feedback loops, streamline product innovation, and transform impact assessment.

Register and get updated on events and news from ClosedLoop

We add new resources regularly. Enter your email address to get them directly in your inbox.