Functions


Functions in dbwql

Numeric functions

Function name Description
add Adds a number to a base value
sub Substracts a number from a base value
abs Returns the absolute value of a number
until Return all numbers from a base number until an end number

Aggregate functions

Function name Description
groupby Groups a set on some value(s)
count Counts the number of rows
sum Adds all values in a set
avg Computes the average of set
max Finds the max value in a set
min Finds the minimum value in a set

String functions

Function name Description
upper Converts a string to uppercase
lower Converts a string to lowercase
trim Strips empty spaces from the beginning and end of a string
concat Concats a number of strings
capitalize Capitalizes a string

Generic functions

Function name Description
todate Converts a value to datestring