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

Stored procedure XML This screenshot lists the source of a SQL Server 2014 stored procedure hitting the AdventureWorks2012 database, selecting data from the Customer and SalesOrderHeader tables.

I blogged previously on the ease of use of GroovySql , which is Groovy 's easy-to-use JDBC -based data access approach.