hi HN coolness - does anyone know of a good lib in ruby/python or other allowing to translate a json blurb into a set of "insert or update..." sql queries. bonus point if it dynamically extends the schema of the db when it finds new json fields.<p>underlying issue - building a small datawarehouse to consolidate data from prod dbms & mixpanel/other tools. Ideally to put a BI tool like jaspersoft and write sql on top of it.<p>thanks!
There is Talend (<a href="https://www.talend.com/" rel="nofollow">https://www.talend.com/</a>) but it's not a library. It's a more general ETL. It requires a time to be learned.<p>I have a tool of my own which "flatten" an object to an array of pairs (for example {"a":1,"b":{"c":2}} becomes ["a":1,"b.c":2]).<p>Something like that may exists in Underscore.js.