Or here is hopefully a more elegant way to phrase my question:

To visualise a control diagram in Genie for an end-user, should I a) instruct Genie how to create an SPC chart with SQL on the fly, of b) create a background job (pre-defined SQL query in the instructions, or a notebook) that prepares the data for charting and instruct genie to use that data?