> 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