Algorithm to Interconvert SQL and Procedural Visual Queries

In this paper, we propose an algorithm to convert SQL and procedural languages into each other. The algorithm converts features of SQL, a declarative programming language, that are not evaluated in top-to-bottom evaluation order, to be evaluated in top-to-bottom order. The algorithm also supports SQL-DML (SELECT, INSERT, UPDATE, DELETE). This helps students and inexperienced users who are learning SQL to understand SQL, and helps experienced users to understand nontrivial and difficult-to-understand SQL. It also introduces a system architecture for inter-conversion between SQL and procedural languages. This architecture allows the system to support a variety of RDBMS.