REST API Data Query Grammar
GET /{tablename}?where[ <column>][] =o:<operator>;v:<value>
WHERE BETWEEN / WHERE BETWEEN COLUMNS
GET /{tablename}?whereBetween[ <column>] =v:<value 1>,<value 2>
GET /{tablename}?whereBitwise[ <column>][] =o:<operator>;v:<value>
GET /{tablename}?whereColumn[ <column 1>:<column 2>] =o:<operator>
GET /{tablename}?whereDate[ <column>] =v:<date>
GET /{tablename}?whereDay[ <column>] =v:<day>
GET /{tablename}?whereExists[ <tablename 2>][ <column 1>:<column 2>]
GET /{tablename}?whereFullText[ <column 1>:<column 2>:<column n>] =v:<value>;m:<0|1>;e:<0|1>
GET /{tablename}?whereIn[ <column>][] =v:<value 1>,<value 2>,<value n>
GET /{tablename}?whereJsonBoolean[ <column>][] =o:<operator>;v:<value>
GET /{tablename}?whereJsonContains[ <column>][] =n:<not>;v:<value>
GET /{tablename}?whereJsonContainsKey[ <column>][] =n:<not>
GET /{tablename}?whereJsonLength[ <column>][] =o:<operator>;v:<value>
GET /{tablename}?whereMonth[ <column>] =v:<month>
GET /{tablename}?whereNotExists[ <tablename 2>][ <column 1>:<column 2>]
GET /{tablename}?whereNotIn[ <column>][] =v:<value 1>,<value 2>,<value n>
GET /{tablename}?whereNotNull[ <column>] =1
GET /{tablename}?whereNull[ <column>] =1
GET /{tablename}?whereRowValues[ <column 1>, <column 2>, <column n>] =v:<value 1>,<value 2>,<value n>
GET /{tablename}?whereSub[ <column>] =q:????
GET /{tablename}?whereTime[ <column>] =v:<time>
GET /{tablename}?whereYear[ <column>] =v:<year>