Build Dynamic Query Builder with JSON as input
1)Use Standard SQL in Google Big Query
2)Define your JSON input file . Parse the JSON to form the exact query .
When two or more tables are involved Create View and then Query on the view
3)Use filters for where conditions and also keep in mind regarging Aggregate functions while building query .
4)Use your own JSON file for input . No need to form the JSON in front end .
5)Join another UserTable finally for Data Restrictions .
Note the final Output is a Query in Standard SQL format which should run in Google Big Query .
The Java Project should follow OOPS .
A neat Code is desired .