Abstract: Techniques are provided for querying medical claims data. In an embodiment, responding to selection of a health care fraud scheme template from among a plurality of health care fraud scheme templates by displaying a partial query statement defined by the selected health care fraud scheme template; and based on a parameter indicated by the selected health care fraud template, displaying at least one interface control element embedded within the partial query statement. An input indicating the value for the parameter of the partial query statement is received. Generating a converted query in a database querying language that a particular database system is configured to interpret based at least on the partial query statement, the parameter, and the specified value for the parameter. The particular database system is caused to execute the converted query to identify query results comprising health care data based on the converted query.