Just a note on a change that may impact users. In Teiid 8.0 there will be a change to bring Teiid in line with the SQL spec in how we parse exact numeric values and return values from the AVG aggregate - see https://issues.jboss.org/browse/TEIID-1600. In some situations this will require that vdbs be rebuilt with explicit conversions added in view layers. The Teiid Team