This is how SQL should have been used all along. They called it The Third Manifesto, ORDBMS, or other things. Regrettably, it never really took off. Because most vendors didn’t adopt it. And …| Java, SQL and jOOQ.
Consider using JSON arrays instead of objects to transfer data in order to avoid overhead on client, server, and the data itself.| Java, SQL and jOOQ.