SYSTEM OBJECT TYPE NAME: query SHORTCUT: sql DESCRIPTION A SQL Query. A SELECT, INSERT, UPDATE or other SQL statement. The query requires a valid database connection. CHILDREN database - string The name of the database. sql - string The SQL query to execute. result - container The result of the query will be a container for each row, with an object for each column. The result container is optional. If it is not present, the results will be displayed in the console. params - container Optional list of parameters for the query. MESSAGES run - Run the query and get back the data. EXAMPLE sqlite [can] : on_load [script] : run sqlite.sql db [sqlite] : database : test.db sql [query] : database [alias] : sqlite.db sql : SELECT id, key, value FROM key_values SEE ALSO mysql, sqlite