The example is not particularly impressive. The SQL equivalent is much easier to understand, which means it is easier to maintain. Number of lines is not an interesting metric; understandability and maintainability are more important.

I’m not sure how they come up with the 20-line example anyway - it’s one join.

Traditionally SQL uses a lot of lines because you put one thing per line, but so what?