I don’t like writing a lot of procedural code, and so I’d like to know a common way to extract data from relational tables and move it into hierarchical json.

Right now, I am using MS SQL Server database, but I would like to perform this migration using My SQL database also.

I am using java and java connectivity database for access. I’d prefer any of these two databases to be able to assemble all the records on...