Implement an API to translate JSON to SQL query.
Input JSON : { 'Author' : 'J.K.Rowling', 'Title': 'Harry Potter' }
Output SQL : SELECT * FROM PERSON WHERE Author = 'J.K.Rowling' AND Title = 'Harry Potter';
Basically I was asked to write a parser for translating JSON to SQL. The interviewer wanted me to implement logic to handle different boolean operators plus ALL and ANY operators. I screwed up this question and the offer!
Any inputs on how to approach this problem would be really appreciated!