Global variables

Global variables are key-value pairs that can be stored under the "Global variables" tab in the plugin.

Key	Value
first_month	"July-25"
last_month	"December-25"

With the global variables defined above, we can write queries that reference values by the variable names, instead of the actual values.

# these are equivalent
SELECT(1, 1, ["Cola"], ["July-25":"December-25"]) >> (2, 2)

SELECT(1, 1, ["Cola"], [$first_month:$last_month]) >> (2, 2)

Note that a variable name must be prepended by a dollar $ sign.

The advantage of using global variables is that we can manage multiple references in one place.