- Strings have single quotes around them, escaping quotes is not yet supported.
Dates have square brackets around them and the following formats are supported: \[yyyy/MM/dd HH:mm:ss.SSS\], \[yyyy/MM/dd HH:mm:ss\] and \[yyyy/MM/dd\]
- Number and BigNumber should have no grouping symbol and the decimal is . (example 123.45)
- Integers contain only digits
- Boolean values can be TRUE or FALSE
Besides the obviously plentiful limitations in the support for the SQL standard, there are a few noteworthy things to note:
- Grouping is done using a "Memory Group By" step which keeps all the groups in memory. If you expect large amounts of groups to be used, watch your memory consumption on the server. We're using the "memory group by" step to avoid doing a costly sort on the data.
- Prepared statements are not yet supported which will limit the usefulness of the driver in 3rd party tools.
The following things are next on the agenda:
- DISTINCT values
- prepared statements
- writing to a service transformation (INSERT INTO)