Stored procedures are not available for SQLite. For Postgres the syntax for SPs are so horrible that I'd rather use this.

Edit: It's quite telling that the example in the link don't show how to return a resultset from a SP in Postgres.