json-sql-utility

This module is useful for buidling SQL queries from JSON objects. Currently only SELECT query is supported.

Install

yarnaddjson-sql-utilityornpmijson-sql-utility

Usage

Simple example

import{select}from"json-sql-utility"constquery=select({fields: ['A','B'],aggregation: [{fn: 'count',args: 'D',alias: 'CNT'}],from: 'STUDENTS',where: [{operator: 'equal',field: 'NAME',value: 'Piyush'},{operator: '=',field: 'ROLL',value: [13],},{operator: 'OR',conditions: [{operator: 'equal',field: 'A',value: 5,},{operator: 'equal',field: 'A',value: 10,}]},{operator: 'dateBetween',field: 'BIRTH',value: {start: newDate(1975,0,1),end: newDate(1999,11,31),}},],groupBy: ['A','B','C'],orderBy: ['A'],misc: ["EXTERNAL NAME 'TestFuncs$MyMath.pow'"],});console.log(query);/*Will output:SELECT A, B, count(D) AS CNT FROM STUDENTSWHERE NAME = 'Piyush' AND ROLL = 13 AND (A = 5 OR A = 10) AND BIRTH BETWEEN '1975-01-01' AND '1999-12-31'GROUP BY A, B, CORDER BY AEXTERNAL NAME 'TestFuncs$MyMath.pow'*/