Which is best Query builder vs Stored Procedure

Basically I always use stored procedure for everything even it is a single query. I want to know the Pros and Cons of both methods

Bottom line: Portability ... Not all DBMS support stored Procs ... and when they do, it's in a different manner.
SProcs need to be managed and maintain some where - and then the scripts need to be executed for any updates.

Builders ... it's self contained and you just have to upload the new file for changes. It also makes it trivial to move from one db to another, or from one dbms to another ...

One -pro- of stored procedures:
They are stored in the DB, thus can be used independent of your (CI) web app - from a db command line, another framework, user, network.
For a 'single query' this all does not apply, so then of course query builder is the preferred method.