The Pentaho Data Service supports the following literals:
- Strings have single quotation marks around them. The escape character for a single quote is another single quote, like this ''.
- Dates have square brackets around them. The following formats are supported: [yyyy/MM/dd HH:mm:ss.SSS], [yyyy/MM/dd HH:mm:ss], and [yyyy/MM/dd].
- For an IN list in a SQL statement, the date formats can have single quotation marks around them and dashes that replace slashes, like this: SELECT * FROM BUILDS WHERE BuildDate IN ('2015-03-18', '2015-03-22'). Note that you cannot surround a date format with a bracket date in an IN list.
- Number and BigNumber should have no grouping symbols. Use a period to represent a decimal, like this: 123.45.
- Integers should contain only digits.
- Boolean values can be TRUE or FALSE.