JSON support phase1

[gin0115]

• selectJson
• whereJson
• whereInJson
• whereBetweenJson
• whereDateJson
• orderByJson
• joinJson

Support for Laravel style selectors should also be included using using JSON with initial methods.

QB::where('columnName->key1->key2', '=', 'matchingvalue'); this would then look inside a json object held in the column columnName, an see if the value held in {"key1": {"key2":'value"}} === 'matchingvalue'

[gin0115]

https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html

[gin0115]

I think prefer the laravel syntax of using

select('column->jsonkey1->key2', 'column2')

It follows the later mysql format, but can still be implemented using the older function syntax

[gin0115]

Support for SELECT and basic WHERE added already

[gin0115]

https://jianjye.com/articles/32/how-to-sort-mysql-json-data-correctly

Order by json

[gin0115]

json join added, just the grouped json join to handle