Current page describes scalar and aggregate functions. Window functions are not implemented in sqlite_orm right now. What is the difference between scalar and aggregate functions? Scalar and aggregate ...

Learn the differences between scalar and table-valued functions in T-SQL and how to use them for better query performance ... you probably use functions to manipulate, transform, or aggregate values.