When you create a view from query, you can use MS SQL functions in the query. This SQL query has to use the syntax of the queried database and not the syntax of Virtual DataPort.
Check out the section ‘Creating JDBC/ODBC Base Views from SQL Queries’ in the ‘Virtual DataPort Administration Guide’ to know more about this.
In addition to that, Denodo provides an extensible set of functions which you can see from the Help > Functions List option.
Hope this helps.