Comment by ijpoijpoihpiuoh

That's really surprising if true, considering the SQL should only need to be parsed once.

    SELECT foo FROM Table WHERE key = @mykey;

Then you bind the parameter to whatever you're interested in.