Users can now update views using an update query. Updates are performed on the base table of the view. Support was added for scalar sub-queries in the select list of select query. A scalar sub-query is a query that returns a single column with one single row. A sub-query column can be sorted using the Order By clause. This version also comes with a number of new scalar functions.
