Syntax to set field = f(field) using a mysql function or an affectation

Purpose is to set a field using an SQL function:

Syntax:

User.update({ age: [ '?? + ?', 'age', 1 ] });
// UPDATE user SET `age` = `age` + 1

Aliases:

User.update({ age: ziti.$inc('age') });
// UPDATE user SET `age` = `age` + 1

User.update({ age: ziti.$inc });
// UPDATE user SET `age` = `age` + 1

Chain:

User.update({ age: ziti.$inc(ziti.$dec) });
// UPDATE user SET `age` = `age` - 1 + 1

Function name	Description
$inc	Increment a column
$dec	Decrement a column
$div	Divide a column
$idiv	Integer division of a column
$mult	Multiply a column
$mod	Remainder of a column
$upper	Sets a column to an uppercase column
$lower	Sets a column to a lowercase column
$ceil	Sets the smallest integer value not less than the column
$floor	Sets the largest integer value not greater than the column
$ltrim	Remove the leading space of a column
$rtrim	Remove the trailing space of a column
$trim	Remove the leading and trailing space of a column
$rand	Sets a random pointing value between 0 and 1.0 a column
$pi	Sets the pi value to a column
$hex	Turns into a hexadecimal string representation of a column
$now	Sets the current date and time

shaoner / ziti