Nearly all components with database connectivity support custom SQL statements executed in different phases of the transformation. There are two basic types of SQL properties, Queries and Scripts. For both types:
Any SQL accepted by the connected database system is allowed. Using SQL92 allows you switching to different database systems without changing the statements.
SBN expressions are allowed. See “Square Bracket Notation”.
