README.md

Json2SQL

Convert Json List to SQL Select statement.

Json String

[    
    {"name":"Ram", "email":"[email protected]", "age":23},    
    {"name":"Shyam", "email":"[email protected]", "age":28},  
    {"name":"John", "email":"[email protected]", "age":33},    
    {"name":"Bob", "email":"[email protected]", "age":41}   
]

Converted SQL statement

Select 'Ram' as A, '[email protected]' as B, 23 as C
Union All
Select 'Shyam', '[email protected]', 28
Union All
Select 'John', '[email protected]', 33
Union All
Select 'Bob', '[email protected]', 41