My 2019 Q3 Vorsprung is going in on Monday for this exact same fault.
Luckily the Service chap was on the ball and knew of a bulletin that addresses this issue.
They'd had a Q3 with pano roof in the previous week, so he already knew where the water was coming in before I'd explained it.
The modification is adding an extra part, not replacing anything.
The drainage holes aren't getting blocked, it's a routing design issue that's been identified by Audi.
The water gets behind the trim at the top of the car and then runs down the A pillar and comes out where the photo shows. Or, if it's been really wet, where the interior trim on the A pillar joins the roof trim it comes through that joint and soaks your leg when you brake and turn right.