DJ does type validation of SQL functions, and it incorrectly supports AVG(boolean) (see https://github.com/DataJunction/dj/blob/main/datajunction-server/datajunction_server/sql/functions.py#L955-L959) which is actually not supported by most SQL engines (Spark SQL, Trino). We should remove this.
DJ does type validation of SQL functions, and it incorrectly supports
AVG(boolean)(see https://github.com/DataJunction/dj/blob/main/datajunction-server/datajunction_server/sql/functions.py#L955-L959) which is actually not supported by most SQL engines (Spark SQL, Trino). We should remove this.