ANS SQL 99 feature T051 defines row types, including row value expressions. The related F641 specifies row and table constructors.
Please add support for these ANS SQL 99 features T051 and F641.
Row types and expressions considerable simplify certain types of queries. In addition, this feature is frequently met in SQL written for other databases, so that migration to SQL Server is made unnecessarily complicated.
I acknowledge that the MS extension of permitting a FROM in an UPDATE serves as a work-around for the lack of row values in updates; but the ability to use ANS-conformant syntax rather than an MS extension would assist portability.