AjaxLine

JsonSql is  a small intresting Javscript Library that allows you to get data  from JSON with SQ like queryies with following syntax:

• Only Select statements are supported
• The requested fields may be a "*" or a list of fields. "*" is likely faster in most cases.
• When typing lists "select field1,field2,field3" or "limit 5,10 do not use spaces.
• When using the "where" clause enclose all conditions with one set of parenthesis "where (category=='The Category' || category=='Other Category')".
• The where clause is a javascript condition, not sql. It should use the scope emplied by "from". Javascript functions may be used here as well as javascript operators.
• The from clause should establish the scope you would like returned. It should start with "json" and use the dot notation: "json.channel.items" and should point to an array within the object.
• The order by option can accept a list but will only order by the first field at this time(asc,desc,ascnum,descnum).

Source: JsonSQL