And the objectively worst way is to put the SELECT in the middle, because it ignores the relationship between the query and the rest of the code that interacts

And the objectively worst way is to put the SELECT in the middle, because it ignores the relationship between the query and the rest of the code that interacts with it, making it more difficult to read - and reading the code is done a lot more than writing the code.