How does VDB support vendor-neutral SQL syntax?
VDB supports “Function Escapes” which are functions embedded in your SQL, delimited by square brackets “[” and “]”. These functions are written in vendor-neutral syntax and translated into vendor-specific syntax when executed. This makes your code far more portable from one database vendor’s database to another (such as from SQL Server to Oracle). The following example illustrates setting an order’s date to the current date. This code will execute on all the major vendor’s databases.
