🛢DBMS: Dynamic SQL (Definitions)

"Dynamic SQL is a method of binding between an application program, in one of a number of standard programming languages, and an SQL-implementation." (ISO/IEC 9075-1, 1999)

"In Embedded SQL for C, a SQL statement built and executed at run time." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"SQL that is interpreted during execution of the statement." (Ajay Gupta et al, "Informix Dynamic Server 11", 2007)

"A SQL statement built and executed at runtime by concatenating different parts of the statement based on provided variables." (Darril Gibson, "MCITP SQL Server 2005 Database Developer All-in-One Exam Guide", 2008)

"[...] dynamic SQL is a means of constructing SQL statements as strings in your server-side (or even client-side) applications and executing them dynamically, on the fly. When used properly, dynamic SQL can be used to generate complex queries at runtime, in some cases improve performance, and do tasks that just aren't possible (or are extremely difficult) in standard, nondynamic T-SQL." (Michael Coles, "Pro T-SQL 2008 Programmer's Guide", 2008)

"SQL statements that are constructed at runtime; for example, the application may allow users to enter their own queries. These types of SQL statements are not hard-coded into the application. See also static SQL." (John Goodson & Robert A Steward, "The Data Access Handbook", 2009)

[Dynamic embedded SQL:] "Embedded SQL in which the entire SQL statement cannot be assembled prior to running the program. The SQL statement is therefore completed and processed during the program run." (Jan L Harrington, "SQL Clearly Explained” 3rd Ed., 2010)

"A term used to describe an environment in which the SQL statement is not known in advance, but instead is generated at run time. In a dynamic SQL environment, a program can generate the SQL statements at run time that are required to respond to ad hoc queries." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management” 9th Ed., 2011)

"Dynamically constructed SQL queries that are not pre-processed, and whose access paths are determined at run time prior to execution." (DAMA International, "The DAMA Dictionary of Data Management", 2011)

"SQL statements that are prepared and executed within an application program while the program is executing. In dynamic SQL, the SQL source is contained in host language variables rather than being coded into the application program. The SQL statement can change several times during the application program's execution." (Kirsten A Larsen et al, "Extremely pureXML in DB2 10 for z/OS", 2011)

"SQL queries that are not preprocessed and whose access paths are determined at run time right before execution." (Craig S Mullins, "Database Administration", 2012)

"Allows an Embedded SQL or Client-Library application to execute SQL statements containing variables whose values are determined at runtime." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

[dynamic SQL statements:] "An SQL statement that is prepared and executed at run time. In dynamic SQL, the SQL statement is contained as a character string in a host variable and is not precompiled." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

"A feature that lets you create and execute prepared statements using more robust, secure, and efficient methods to substitute parameter values than the naive technique of concatenating the parts of the statement into a string variable." (MySQL)

"A program in which user input determines how the program interacts with the database. Put another way, the SQL statements are not part of the program when it is launched; instead they are built as the program runs." (Microfocus)

"A type of embedded SQL in which SQL statements are created and compiled at run time." (Microsoft) 

"Dynamic SQL is a programming technique that enables you to build SQL statements dynamically at runtime. You can create more general purpose, flexible applications by using dynamic SQL because the full text of a SQL statement may be unknown at compilation." (Oracle) [source]

"Dynamic SQL is an application that uses dynamic code to increase flexibility in querying a database. Dynamic code is generated at execution of a SQL application by inserting statements into variables." (Idera) [source]