To allow for more expressive query results, data.world supports a variety of text formatting functions to change how results are displayed in the data.world query results view.
Here are some examples of the text formatting functions available:
SELECT BOLD(name) FROM Employees
lists the names of the employees in bold text in the data.world query results view.
SELECT ITALIC(name) FROM Employees
similarly lists the names of the employees in italic text. These can be combined like this
SELECT BOLD(ITALIC(name)) FROM Employees
which writes the names in bold and italic. To show the text in blue, the WITH_COLOR function is available
SELECT WITH_COLOR("dave", COLOR("blue")) FROM Employees
To show the query result with a blue background, use WITH_BACKGROUND_COLOR
SELECT WITH_BACKGROUND_COLOR("dave", COLOR("blue")) FROM Employees
If you wish to quickly add highlighting to a cell, the WITH_STATUS and STATUS functions provides an easy way to flag a cell as “info”, “warning”, or “error”. The cell background will be rendered in a suitable color, chosen for accessibility.
SELECT WITH_STATUS("dave", STATUS("warning")) FROM Employees
Finally, to show the query result as a clickable hyperlink, use the WITH_LINK function
SELECT WITH_LINK("dave", "http://www.google.com") FROM Employees