Best practices when interacting with an SQL databases?

In what instances is it advisable to use a regular SQL query or a stored procedure in Martini when interacting with an SQL database?

Do you have any best practices in using any one of these types?