j2s

JSON to SQL: build RESTful API servers on the fly by accepting JSON describing SQL query statements. Version 2.0.13 supports CRUD operations, joins, aggregations, where conditions with operators (gt, lt, in, between, etc.), relation manipulation, and configurable access control. It relies on Bookshelf.js (and Knex.js) for ORM and query building, and is tested with Koa.js. Unlike traditional REST frameworks, j2s shifts query complexity to the client, reducing backend code for data fetching.