You'll find several areas of interest regarding XML usage in SQL Server Reporting Services.

A new SQL Server 2025 feature lets organizations run vector-based semantic searches on their own data, connecting to local or ...

This class makes it very easy, almost trivial, to convert SQL query results into XML, but a major disadvantage of OracleXMLQuery is that it is a proprietary solution.