In the Translator, you can read data from a database by either calling stored procedures or using conn:query{} to execute ad hoc SQL SELECT statements on a database. See Writing SQL Statements.
...
The conn:query{} method prevents the accidental use of SQL statements that might modify the database from the Translator, which automatically executes when you make script changes or sample data changes.
| Expand | ||
|---|---|---|
| ||
Using the Annotations you can view database query result tables easily:  The function returns the database query result sets and a Lua table of all result sets. A for loop can be used to iterate through the results table and access values using  |
| Expand | ||
|---|---|---|
| ||
pcall() can be used to perform a protected call, capturing any returned database errors allowing you to appropriately handle errors according to your needs. In this example, we are using  |