1. A computer-implemented method for testing Structured Query Language (SQL) queries in a software application during application development, the method comprising: executing, in a debug mode, 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, the debug mode specifying a breakpoint in the main program that is associated with the SQL query, the 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; copying the SQL query associated with the breakpoint, in response to user selection of the SQL query in a program editor upon reaching the breakpoint, from the program editor into an SQL console; and by the SQL console, resolving the at least one unresolved parameter based on the execution of the main program; by the SQL console, parsing the SQL query to extract a source part and a result part from the SQL query, and automatically determining a data type definition and data declaration based on the extracted source part and result part and identifying one or more tables accessible by the SQL query based on the source part; determining that a user has authority to access the one or more tables and, following the determination, causing 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 displaying the retrieved data to the user.
5. The method of claim 1 , wherein executing the software application in debug mode comprises computing, during execution of the main program, one or more values of one or more parameters including the at least one unresolved parameter of the SQL query, and storing the computed one or more parameter values in memory allocated to execution of the main program, and wherein resolving the at least one unresolved parameter comprises accessing, by the SQL console, the memory allocated to execution of the main program to retrieve the value of the at least one unresolved parameter therefrom.