jsonSQL

Python library provides the briefest way to construct SQL queries in JSON form. Simple example: ('*','table',id:[1,3]) is Select * from table where id in [1,3]. Sqlalchemy patch module is provided to extend sqlalchemy with convenient jsonSQL meth