build sql from json

[waitcon]

hi mistic100,

great code !!!
is there a chance to add functionality in order to get valid sql where clause out of json string?

[mistic100]

ps: I took 3 hours, not 14 minutes :-)

[waitcon]

you are the GREATEST ... exactly what I am looking for!!!!
Thanks a lot!

[timgws]

On this, I have written a quick PHP class that will convert the JSON into an SQL query. It's a little rough around the edges, and it will only work with Eloquent/Query Builder from Laravel, but it works perfectly for what I want to use it for!

https://github.com/timgws/QueryBuilderParser

[ostrolucky]

If you got here like me - searching for parsing output of this library in PHP, I made fork of timgws/QueryBuilderParser for Doctrine, located at gadelat/QueryBuilderParser

[hsalem7]

Hi there, I didn't know that there is a query builder for this :D.
so I created one 😄
it works with laravel model and relation. so you don't need to redefine relation again.

also, it hides your table structure. please take a look at it.

https://github.com/hassanalisalem/querybuilder

[mistic100]

But there already was a parser for Laravel http://querybuilder.js.org/#backends

[hsalem7]

@mistic100
yes, I know, but the problem that you need to redo the relations and rethink them,
that what happened to me, I forgot what are my relations were.
so I created it, it uses the laravel relations ( the relations inside the Model itself)