Amazon SDE 2 | Onsite OOD Question
Anonymous User
1465

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!

Comments (5)