QueryPRIMM: A PRIMM-Based Tool for Learning SQL

Abstract

Students often find learning Structured Query Language (SQL) challenging, particularly when understanding how queries operate on relational data. Active engagement with queries and their results can help students build stronger understanding of SQL concepts. The PRIMM (Predict-Run-Investigate-Modify-Make) framework provides a structured approach for engaging learners with code through prediction, exploration, and modification activities. This paper presents a web application designed to support learning SQL through PRIMM-based exercises. The platform guides students through predicting query outputs, executing SQL queries, investigating results, modifying queries, and creating their own queries within an interactive environment. The tool provides instructors with a structured way to incorporate PRIMM activities into SQL teaching, while allowing students to experiment with queries and observe their effects on relational data. The platform also supports the creation of custom PRIMM exercises that expand the available practice problems and allow customisation to specific course topics. We describe the system and present example questions that illustrate how it can be used to support SQL learning.