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
Execute a string of SQLTools.ExecSql
Parse JSON documentsTools.JsonExpand
Parse CSV, Text and similar from cells within a tableTools.Parse.Csv
Parse XML from cells within a tableTools.Parse.Xml
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