Can VA be used to generate non-ANSI SQL?
The VA SQL Editor was built based on ANSI SQL and cannot be used to build non-ANSI SQL. Yes, one can be created manually. We know of no limitations in allowable syntax for SQL statements. In some cases, it may be possible for you to build your initial ‘ANSI’ query using the SQL Editor, then manually edit the query to add any ‘non-ANSI’ functionality. VA merely passes your query string to the database connection. No syntax validation is done within VA itself.
