What reportage said...
Also, a lot of it depends on how exacting the results must be.
For casual usage/purposes, just about any lens will do if you stop it down enough, but serious work, architectural photographers usually use a large-format camera or for smaller formats, a tilt and shift lens.