Chinese blog post about how to use SQL with kbmMemTable and kbmMW to select data from JSON.
Xalion has a good number of quite interesting blogposts, also of interest for non chinese. Google translate is your friend. (translate.google.com)
http://www.cnblogs.com/xalion/p/7121713.html
best regards
Kim/C4D