Which is the best way to manage sql queries?

Prefer Stored procedure!!!
Here are some advantages for Stored procedures:

In terms of maintainability:

One could use parametrized queries for simple/trivial operations, like retrieving data, or inserting data in table. Stored procedures are easier to maintain than inline queries if you have complicated (processing) code. Who would like to maintain program source code mixed with complicated SQL code in the same file. Also, almost all of the parametrized queries that are complex, can be found splitted in multiple string concats. Believe it or not, I've seen a SQL query concatenated in over 60 lines length.

In terms of speed:

First, you could think about the time it takes to compile the query and, also, the time it takes to create an execution plan (Both of them are sometimes longer than the execution time of the query). The stored procedures are compiled only once, unless specified, and the execution plan is stored, so a restart of the server wouldn't loose it. Also, for queries, the execution plans aren't created right away, but after a few calls of the same query (depending on the databse engine).

In terms of connection:

If you have a slow connection to the sql server, and large queries, you would probably be better off using stored procedures, as they generate less network traffic, and usually less roundtrips between the server and the client.

Also, there are also lot's of other advantages/disadvantages of using one over another, but the bid would be for stored procedures in most of the cases.

Refer Here

1.Stored-Procedures-Optimization-Tips[^]
2.stored-procedure-optimization-tips[^]

Adding my two cents here. I also think that using stored procedures is advicable in many situations as others have already stated.

However, if your queries are more dynamic in nature then it may not make sense to pass the elements of a composed query (or even the whole statement) to a stored procedure. This would introduce a problem where the dynamic logic is separated to two different layers, the application and the database. In this kind of situation I feel that creating the queries in your application and executing them against the database is more preferred way.