Each SQL query must be built via the PatternStream interface. The query-builder interface links up each desired external database variable with the desired PatternStream variable. This picture shows the query-builder interface, on the first tab.
     Tabs 2 to 6 show standard parts of a SQL statement. The 7th tab provides the whole SQL statement which can be copied and then pasted into a SQL utility that goes directly against the database (without PatternStream publishing code) for testing.