JSON is great for moving data around but not so hot when you need to convert it into data stored in a relational database -- it's a problem ... allows me to convert the string-value date in the object ...

Where did the relational ... there are database development tools that can generate correct SQL queries for you, often by dragging and dropping tables and fields from the schema diagram into ...