Providing you are a LUSID user with sufficient access control permissions, you can use the Tools.* utility providers supplied with Luminesce in any Luminesce query.

To...Use the ... provider
Parse JSON documentsTools.JsonExpand
Use Mustache templates to format tables into text outputTools.Mustache
Generate a range of valuesTools.Range
Split stringsTools.Split
Pivot data from rows into columnsTools.Pivot
Unpivot data from columns into rowsTools.Unpivot