You can use the Tools.* utility providers supplied by FINBOURNE in any Luminesce query.

To...Use the ... provider
Return column names and data types for a tableTools.Describe
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