serviette-0.1.0.0: README.md
# SERVIETTE - SQL JSON API
Library for generating SQL queries from JSON.
Send the json in the expected format and receive raw sql string.
### Why ?
- Why not ?
### Expected JSON format
````
{
"format":1,
"action":"SELECT",
"selectName": "users",
"joinTables":[
{"tablename":"addresses","field":"userid","operator":"=","withTable":"users", "withField":"id"},
{"tablename":"posts","field":"userid","operator":"=","withTable":"users", "withField":"id"}
],
"whereCondition":[
{"whereTableName":"users","whereField":"id", "whereOperator":">", "whereFieldValue": 1}
]
}
````
If `format` is set to 1 you will get raw sql string back, something like this:
`````
`````