Multiply & Divide functions in JsonPath

[sanketyd]

Need multiplying & dividing support in JsonPath.

Why is it required?
We have a service that uses JsonPath extensively to generate huge Json configurations based on user inputs. Sometimes the values in configuration need to be derived from multiple user inputs & that's where multiply & divide functions are required.

Usage will be like this:-
div($.numerator, $.denominator)
$.numbers.mul()
mul($.left, $.right)

Also, I am curious as to why is there no functionality for multiplying & dividing but other arithmetic is there in JsonPath.

[yairlenga]

Suggesting extending jsonpath to include 4 arithmetic operations using JavaScript syntax ‘*’, ‘/‘, ‘+’, and ‘-‘. This syntax was integrated into sql/JSON standard, and postgresql (and possibly other engines ), already implemented it: https://github.com/obartunov/sqljsondoc/blob/master/jsonpath.md

The arithmetic operators were included in the SQL/JSON recommendation, and is available in few jsonpath engines (Postgresql, Oracle, maybe more). Better to match syntax to reduce confusion.