Comment by petilon
8 hours ago
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?