conn:query
allows you to execute an ad hoc SQL SELECT statement on a database
conn:query{}actually executes SELECT statements when you alter the Editor script or change the sample data. It assumes that the SELECT statements do not alter the state of the database and can be safely run to power the Translator’s annotation and auto-completion capabilities.example of query and annotation results
Link to “writing SQL statements“
Can also call stored procedures