Extract tags for row from YAML XML column

gistfile1.sql

create view ProjectDescriptionSectionTags
as select
  pds.ProjectID,
  cs.ID as SectionID,
  U.V.value('./text()[1]', 'nvarchar(100)') as Tag
from ProjectDescriptionSection pds
inner join ContentSection cs on cs.ID = pds.ID
cross apply cs.XmlConf.nodes(N'//key') as T(K)
cross apply T.K.nodes('../value/sequence/item') as U(V)
where T.K.exist('.="tags"') = 1