;with xmlnamespaces ('http://schemas.microsoft.com/sqlserver/2004/07/showplan' AS SP)
select
--q.p.value('.','nvarchar(255)') estimated_rows
x.file_name,
x.event_data,
x.event_data.value('(/event/@timestamp)[1]','datetime2(3)') timestamp,
s.pl.query('*') plan_xml
--p.d.query('*'),
-p.d.value('(/SP:BatchSequence/SP:Batch/SP:Statements/SP:StmtSimple/@StatementSubtreeCost)[1]','nvarchar(255)'),
--p.d.value('(@Version)[1]','float') cost
--,xe.event_data
--from (
-- select top 10 file_name, event_data