Append writes to the given SQL builder the SQL command for appending JSON values into the array, optionally defined as a key.

Cast indicates that the result value should be cast to the given type.

DotPath is similar to Path, but accepts string with dot format.

HasKey return a predicate for checking that a JSON key exists and not NULL.

LenEQ return a predicate for checking that an array length of a JSON (returned by the path) is equal to the given argument.

LenGT return a predicate for checking that an array length of a JSON (returned by the path) is greater than the given argument.

LenGTE return a predicate for checking that an array length of a JSON (returned by the path) is greater than or equal to the given argument.

LenLT return a predicate for checking that an array length of a JSON (returned by the path) is less than the given argument.

LenLTE return a predicate for checking that an array length of a JSON (returned by the path) is less than or equal to the given argument.

LenNEQ return a predicate for checking that an array length of a JSON (returned by the path) is not equal to the given argument.

LenPath returns an SQL expression for getting the length of a JSON value (returned by the path).

OrderLen returns a custom predicate function (as defined in the doc), that sets the result order by the length of the given JSON value.

OrderLenDesc returns a custom predicate function (as defined in the doc), that sets the result order by the length of the given JSON value, but in descending order.

OrderValue returns a custom predicate function (as defined in the doc), that sets the result order by the given JSON value.

OrderValueDesc returns a custom predicate function (as defined in the doc), that sets the result order by the given JSON value, but in descending order.

ParsePath parses the "dotpath" for the DotPath option.

Path sets the path to the JSON value of a column.

StringContains return a predicate for checking that a JSON string value (returned by the path) contains the given substring.

StringHasPrefix return a predicate for checking that a JSON string value (returned by the path) has the given substring as prefix.

StringHasSuffix return a predicate for checking that a JSON string value (returned by the path) has the given substring as suffix.

Unquote indicates that the result value should be unquoted.

ValueContains return a predicate for checking that a JSON value (returned by the path) contains the given argument.

ValueEQ return a predicate for checking that a JSON value (returned by the path) is equal to the given argument.

ValueGT return a predicate for checking that a JSON value (returned by the path) is greater than the given argument.

ValueGTE return a predicate for checking that a JSON value (returned by the path) is greater than or equal to the given argument.

ValueIn return a predicate for checking that a JSON value (returned by the path) is IN the given arguments.

ValueIsNotNull return a predicate for checking that a JSON value (returned by the path) is not null literal (JSON "null").

ValueIsNull return a predicate for checking that a JSON value (returned by the path) is a null literal (JSON "null").

ValueLT return a predicate for checking that a JSON value (returned by the path) is less than the given argument.

ValueLTE return a predicate for checking that a JSON value (returned by the path) is less than or equal to the given argument.

ValueNEQ return a predicate for checking that a JSON value (returned by the path) is not equal to the given argument.

ValueNotIn return a predicate for checking that a JSON value (returned by the path) is NOT IN the given arguments.

ValuePath returns an SQL expression for getting the JSON value of a column with an optional path and cast options.

PathOptions holds the options for accessing a JSON value from an identifier.

Option allows for calling database JSON paths with functional options.