ConceptQL Sandbox

This webpage demonstrates some of the features of the ConceptQL language. The language itself is described in this PDF.

To explore the language, simply choose an example from the drop down menu.

Each example will be submitted to a web service that translates ConceptQL statements into:

  • A diagram, complete with the number of results returned by each part of the statement (labeled "rows") and the number of unique patients returned (labeled "n")
  • A YAML representation of the statement, to demonstrate that ConceptQL can be represented in any object notation that supports hashes and arrays
  • A SQL statement that can be run on the RDBMS of your choosing, so long as it is loaded with OMOP CDMv4 structured data and the OMOP vocabulary tables
  • The first 10 results returned by the ConceptQL statement

The web service uses a sample of synthetic Medicare claims data consisting of 100,000+ patients to generate results and counts for the diagrams. The results derived from these synthetic data should not be used for actual research purposes.

Some features of the language are experimental and are not yet part of the SQL generator. As a result, some statements will not return SQL statements, diagrams with counts, or the first 10 results.

ConceptQL Statement



YAML Representation

PostgreSQL, OMOP-CDMv4 Compatible SQL Query

NOTE: If you plan to use this query against your PostgreSQL OMOP-CDM data, please make sure you've set your search_path variable properly.

No results returned

First {{ partial_results.length }} Results

{{ key }}
{{ result[key] }}