Paul Toms finds that most NexusDB sql is reasonably functional, but the leading colons (used for parameters in NexusDB and host variables in DB2) are particularly problematic.
Github Issue #81: Added support for C-Style comments ("//") and colon…
…-prefixed parameter/host-variable names for other SQL dialects
Dmitry Kovalevsky also reported this issue when using the Notepad++ plugin (don't know which SQL dialect):
AND some.thing BETWEEN to_timestamp(:start_date_ || ' ' || '08:00:00', 'dd.mm.yy hh24:mi:ss')
AND to_timestamp(:end_date_ || ' ' || '07:59:59', 'dd.mm.yy hh24:mi:ss')