Community

Using SQL Server FOR XML and FOR JSON Syntax on Other RDBMS With jOOQ

(lukaseder) SQL Server supports transforming flat tabular SQL result sets into hierarchical structures by convention using the convenient FOR XML or FOR JSON syntaxes. This is really convenient and less verbose than the standard SQL/XML or SQL/JSON APIs – although the standard ones are more powerful