Query Node

A Query node is a special form of Input node that allows you to use SQL statements to query tables from within Construct. Icons in the Input section of the node panel are green or grey depending on their availability of use. If the Query node appears grey, select either the connection or the corresponding data table you want to use to make the Query node available. 

Running SQL Scripts in Construct Using a Query Node

The Query node setup window is different from that of other connections. Instead of displaying a list of available variables it presents a query window. The node will be tied to a database connection and it will have a default query if it was created from a table connection. The user may edit this script, using the syntax for the version of the SQL scripting language native to the database server being accessed.

In addition to SQL scripting, the Query node can make use of user defined functions and stored procedures hosted on a database server, as long as the entire “query” expression returns a “result set” i.e. something that looks like a data table.