Jana Sattainathan argues against hard-coding values in queries:
I have heard arguments for doing this type source code
-
This is a one-time thing. We do not have the need to do it anywhere else
-
We are on a deadline
-
We do not have the ability to test if this was not done this way
-
My program is going away in a week
-
We do not have the time to correct this
-
I am just following the existing pattern
-
Unofficially (not) said – “This is my job security”
I’m with Jana in principle, but there are performance costs at the margin, making this less of a hard-and-fast rule than I’d like.