8. A system for testing Structured Query Language (SQL) queries in a software application during application development, the system comprising: one or more computer processors; and one or more machine-readable storage media storing a plurality of instructions for execution by the one or more computer processors, the instructions comprising: a program editor for defining, via user input, a database-accessing software application including a main program written in a non-SQL programming language and, embedded in the main program, an SQL query comprising at least one unresolved parameter having a value that is unresolved in the SQL query itself and is determinable during execution of the main program; a program executor to execute the software application in a debug mode specifying a breakpoint in the main program that is associated with the SQL query; and an SQL console to receive a copy of the SQL query upon user selection of the query in the program editor during execution of the software application in the debug mode, resolve the at least one unresolved parameter based on the execution of the main program, parse the SQL query to extract a source part and a result part from the SQL query, and automatically determine a data type definition and a data declaration based on the extracted source part and result part and identify one or more tables accessible by the SQL query based on the source part; determine that a user has authority to access the one or more tables and, following the determination, cause execution of the SQL query, separately from the execution of the main program, by generating and causing execution of a dynamic subroutine with the determined data type definition and data declaration to thereby retrieve data from a database in accordance with the SQL query, and display the retrieved data to the user.
13. The system of claim 8 , wherein the SQL console is configured, upon validation of the SQL query by the user, to copy the validated SQL query from the SQL console into the software application defined in the program editor.