Using Context Free Grammars to Generate SQL Questions

This paper showcases the limitations of current SQL practice approaches, both in server architecture and implementation. The technical project works towards resolving these limitations by providing a fully client-sided website to help students practice SQL. By providing a client only architecture rather than the traditional server-client approach, queries are guaranteed to be sandboxed, and the necessity for reliable WiFi becomes nearly nonexistent. This is in part an extension of the SQL Injection platform first presented in 2019 [1], with more focus on practicing SQL queries than SQL injection attacks. Such practice involves basic keywords, including WHERE, HAVING, and GROUP BY as well as aggregates. This approach implements modified context free grammars for constructing questions and example answers, including variables for aggregates and GROUP BY.