SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

WITH
events(events,eventdate,eventkind) AS (
            SELECT 'A',CAST('2022-05-06' AS DATE),'D'
  UNION ALL SELECT 'A',CAST('2022-05-07' AS DATE),'D'
  UNION ALL SELECT 'A',CAST('2022-05-08' AS DATE),'D'
  UNION ALL SELECT 'A',CAST('2022-05-09' AS DATE),'D'
  UNION ALL SELECT 'A',CAST('2022-05-10' AS DATE),'D'
  UNION ALL SELECT 'A',CAST('2022-05-11' AS DATE),'D'
  UNION ALL SELECT 'A',CAST('2022-05-12' AS DATE),'D'
  UNION ALL SELECT 'A',CAST('2022-05-13' AS DATE),'D'
  UNION ALL SELECT 'A',CAST('2022-05-14' AS DATE),'D'
  UNION ALL SELECT 'A',CAST('2022-05-15' AS DATE),'D'
  UNION ALL SELECT 'A',CAST('2022-05-16' AS DATE),'D'
  UNION ALL SELECT 'A',CAST('2022-05-17' AS DATE),'D'
  UNION ALL SELECT 'A',CAST('2022-05-18' AS DATE),'D'
)
,
eventmatters(events,matters) AS (
  SELECT 'A','000122FD-47B6-47B6-47B6-1FCAB474CE53' 
)
-- real query starts here, replace following comma with "WITH"
,
w_borders AS (
  SELECT
    e.events
  , e.eventdate
  , e.eventkind
  , LAG (e.eventdate,3) OVER(ORDER BY e.eventdate) AS earliest
  , LEAD(e.eventdate,3) OVER(ORDER BY e.eventdate) AS latest
  FROM events e
  JOIN eventmatters em ON em.events=e.events
  WHERE em.matters = '000122FD-47B6-47B6-47B6-1FCAB474CE53' 
    AND e.eventkind = 'D' 
)
SELECT
  e.events     AS this_events
, e.eventdate  AS this_eventdate
, e.eventkind  AS this_eventkind
, o.events     AS other_events
, o.eventdate  AS other_eventdate
, o.eventkind  AS other_eventkind
FROM w_borders e
JOIN events    o 
  ON e.events = o.events
 AND e.earliest <= o.eventdate
 AND e.latest   >= o.eventdate
WHERE e.eventdate = CAST('2022-05-12' AS DATE)
;

this_events	this_eventdate	this_eventkind	other_events	other_eventdate	other_eventkind
A	2022-05-12	D	A	2022-05-09	D
A	2022-05-12	D	A	2022-05-10	D
A	2022-05-12	D	A	2022-05-11	D
A	2022-05-12	D	A	2022-05-12	D
A	2022-05-12	D	A	2022-05-13	D
A	2022-05-12	D	A	2022-05-14	D
A	2022-05-12	D	A	2022-05-15	D