So I got some great advice about using the DynamicQuery adapter - really does make returning data so much easier!
This is a simple grid that I’ve populated using BAQ. Question is how to control the decimal format - can’t specify it in the customisation because the grid is blank and has no columns at runtime. (the headers aren’t shown at least until it’s run).
This is the BAQ:
And finally, when you Analyse the BAQ it does honour the format correctly: