SQL Statement Template: a development approach for database-driven applications

Database-driven applications are some of the most widespread applications nowadays. It normally requires a good knowledge and experience in application development, database SQL, and may be some other fields to build a well-designed application. The inherited nature, which is common in most database-driven applications, is that SQL statements are considered to be part of the code. However, this technique, sometimes, leads to more development complexity and reduces the understandability of the code. In this paper we propose an SQL Statement Template. This template suggests a layer whereby SQL statements are externalized and defined in a uniform way. The template outcome is produced using a definition language, and clearly defined roles and responsibilities in the design and implementation phases.