Patent Document ID: 9779133
Application ID: 14552990

Base Claim:
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.

---

Claim 7:
7. The method of claim 1 , wherein the breakpoint is placed in the main program or immediately preceding the SQL query.