Limitations
ROUND, CEIL, FLOOR, TRUNC and TRUNCATE return a floating-point value where Snowflake returns a fixed-point NUMBER, and AVG does the same. The value agrees; the declared type does not, which matters where a client reads the column type or where the difference between decimal and binary floating point is significant. The result type follows the argument’s type in Snowflake, which is not known at translation time here.