Documentation as per SQL adapters below.
Set column name
Apply UPPER()
function to column
Apply LOWER()
function to column
Apply SUM()
function to column
Apply AVG()
function to column
Apply MIN()
function to column
Apply MAX()
function to column
Apply COUNT()
function to column
SQL equivalent of NOW()
Apply YEAR()
function to column
Apply MONTH()
function to column
Apply DAY()
function to column
Apply WEEK()
function to column
Apply WEEKDAY()
function to column
Apply CONCAT()
function to column
Example:
query.select({
id_and_title: function (column) {
return column.concat('id', JSON.stringify(' '), 'title');
}
})
Now id_and_title
field will be returned with id
and title
field's values separated by a space.