> So does web2py allow for raw sql if there is an advanced procedure
or query that needs to be performed that is outside the scope of the
web2pr orm
Yes
db.executesql("whatever you want")
http://www.web2py.com/examples/static/epydoc/web2py.gluon.sql.SQLDB-class.html
Massimo