If the row value constructor syntax is supported by SQLServer it might be worth opening an HHH issue to get the SQLServer2008Dialect fixed.