All SQL transformation rules apply, including the following:
If DirectConnect is configured for passthrough mode, the SQL within the double quotes must comply with the target SQL syntax.
If DirectConnect is configured for sybase mode, the SQL must be in Sybase T-SQL dialect.
