Complete syntax definition of WHERE clause

[surruk51]

I need help. I need, either
(a) validation of what I have divined (see below), OR
(b) official docs that give the complete specification of the jsstore API

Why? I am trying to write a routine in PHP so that JSSTORE syntax can be used to update a MySQL/MariaSQL database. The most complex part is the WHERE clause. I have the following so far (AlternativeWhere and AlternativeOr are just different ways of expressing the where and or clauses to allow multiple conditions on the same column name). Names starting with * are placeholders
Please Help.

{
    "where": {
        "*fieldname":"*value",
        "*fieldname":{"*operator":"*value"},
        "*fieldname":{"*operator":"*value"},
        "*fieldname":{"in":["*value","*value"]},
        "*fieldname":{"-":["*valuefrom", "*valueto"]}
    },
    "alternativeWhere":[
        {"*fieldname":"value"},
        {"*fieldname":{"*operator":"*value"}},
        {"*fieldname":{"in":["*value","*value"]}},
        {"*fieldname":{"-":["*valuefrom", "*valueto"]}},
        {"or":[
            {"*fieldname":"*value"},
            {"*fieldname":{"*operator":"value"}},
            {"*fieldname":{"*operator":"value"}},
            {"*fieldname":{"in":["value","value"]}},
            {"*fieldname":{"-":["*valuefrom", "*valueto"]}}
            ]
        },
        {"alternativeOr": {
            "*fieldname":"*value",
            "*fieldname":{"*operator":"*value"},
            "*fieldname":{"in":["*value","value"]},
            "*fieldname":{"-":["*valuefrom", "valueto"]}
            }
        },
        {
            "join": {
                "with": "*tablename",
                "type": "inner",
                "on": "*fieldname=*fieldname",
                "as": {
                    "*resultname":"*fieldname",
                    "*resultname":"*fieldname"
                }
            }
        }
    ]
}

[ujjwalguptaofficial]

use multiple where in array. Have a look at this doc - https://jsstore.net/tutorial/adv-sql-example/