For comparison, MSSQL has been able to provide query results in XML for quite some time. I've found it useful in a couple of situations. See https://learn.microsoft.com/en-us/sql/relational-databases/x...
[1]: https://www.postgresql.org/docs/current/functions-xml.html