I wish its a good idea using stored procedures as a queries. as normal queries can be attacked easily as they can used for a sql injection; also it requires more code process to write it.
And its easy to change on later on if you upgrade it or change it.
some stored procedures sample example for mysql are-
stored procedure[
^]
MySQl Stored Procedure[
^]