I'd argue the example given in the article is bad not because it doesn't repeat itself, but because it only concats strings. Using more advanced language featur

I'd argue the example given in the article is bad not because it doesn't repeat itself, but because it only concats strings. Using more advanced language features, or perhaps a ORM, I think you could easily come up with a solution that doesn't involve repeating parts of SQL queries but is still readable.