Concepts
Dynamic binding lets you integrate user inputs into the database and API queries using mustache syntax. During execution, Appsmith replaces the mustache value with the actual value.
The first time you connect a database to your application, Appsmith creates a new connection with the database server.
Datasource environments let you separate staging and production configurations of the same datasource. This gives you control and isolation for different tasks at different stages of the datasource's lifecycle.
Database Management Systems (DBMS) provide prepared statements to enable the execution of SQL statements with parameterized data bindings.
Stored procedures are SQL statements that can be defined and called as reusable pieces of code.