SQL statements that are added to a high-level programming language such as C or Python. In a preprocessing stage, the SQL code is converted into function calls, which may be optimized to provide the fastest results. See
SQL and
function call.
Static and Dynamic SQL
If the query does not change, it is "static SQL." If the query requires user input at runtime, it is "dynamic SQL."
Passthrough SQL
"Passthrough SQL" is the client program passing the SQL statements directly to the database server without any intermediate steps.