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 table | Tools.Describe |
| Execute a string of SQL | Tools.ExecSql |
| Parse JSON documents | Tools.JsonExpand |
| Parse CSV, Text and similar from cells within a table | Tools.Parse.Csv |
| Parse XML from cells within a table | Tools.Parse.Xml |
| Use Mustache templates to format tables into text output | Tools.Mustache |
| Generate a range of values | Tools.Range |
| Split strings | Tools.Split |
| Pivot data from rows into columns | Tools.Pivot |
| Unpivot data from columns into rows | Tools.Unpivot |