1. A computer-implemented method to debug database statements embedded in program source code, during development of the program source code and prior to successfully compiling the program source code, the computer-implemented method comprising: updating a graphical user interface (GUI) of an integrated development environment (IDE) tool during development of the program source code, wherein the GUI of the IDE tool is updated based on user input specifying to modify the program source code; upon detecting modification of the program source code to include a database statement embedded as a text string in the program source code, causing evaluation of the embedded database statement, wherein the embedded database statement contains a plurality of syntax elements of different types, of which a first syntax element is auto-completed by the IDE tool without requiring user input explicitly specifying the entirety of the first syntax element, thereby avoiding any syntactic error in the first syntax element, wherein the IDE tool visually distinguishes different types of syntax elements from one another via different syntax colors for display; upon identification of a semantic error in a second of the plurality of syntax elements during evaluation of the embedded database statement, generating output visually conveying the identified semantic error and one or more auto-proposed fixes applicable, upon user selection via the IDE tool, to correct the identified semantic error, thereby improving a measure of efficiency of debugging the embedded database statement; and subsequent to correction of the identified semantic error, and responsive to receiving a request to compile the program source code, compiling the program source code in order to generate an application for execution, wherein the program source code is successfully compiled only upon identifying no compilation error in the program source code and no syntactic error and no semantic error in the embedded database statement; wherein the IDE tool is configured to identify: (i) at least one syntactic error comprising a misspelled keyword and (ii) at least one semantic error comprising an incorrect table name or an incorrect column name.
1. A computer-implemented method to debug database statements embedded in program source code, during development of the program source code and prior to successfully compiling the program source code, the computer-implemented method comprising: updating a graphical user interface (GUI) of an integrated development environment (IDE) tool during development of the program source code, wherein the GUI of the IDE tool is updated based on user input specifying to modify the program source code; upon detecting modification of the program source code to include a database statement embedded as a text string in the program source code, causing evaluation of the embedded database statement, wherein the embedded database statement contains a plurality of syntax elements of different types, of which a first syntax element is auto-completed by the IDE tool without requiring user input explicitly specifying the entirety of the first syntax element, thereby avoiding any syntactic error in the first syntax element, wherein the IDE tool visually distinguishes different types of syntax elements from one another via different syntax colors for display; upon identification of a semantic error in a second of the plurality of syntax elements during evaluation of the embedded database statement, generating output visually conveying the identified semantic error and one or more auto-proposed fixes applicable, upon user selection via the IDE tool, to correct the identified semantic error, thereby improving a measure of efficiency of debugging the embedded database statement; and subsequent to correction of the identified semantic error, and responsive to receiving a request to compile the program source code, compiling the program source code in order to generate an application for execution, wherein the program source code is successfully compiled only upon identifying no compilation error in the program source code and no syntactic error and no semantic error in the embedded database statement; wherein the IDE tool is configured to identify: (i) at least one syntactic error comprising a misspelled keyword and (ii) at least one semantic error comprising an incorrect table name or an incorrect column name. 13. The computer-implemented method of claim 1 , further comprising: prior to passing the embedded database statement to a query tool, passing the embedded database statement to a query parser operatively connected to the IDE tool, whereupon the query parser parses the embedded database statement in order to evaluate the embedded database statement in terms of both syntactic correctness and semantic correctness and generate a parser result, wherein the parser result is returned to the IDE tool.