Do they need to be created dynamically by your app? If not, you could just create them outside of web2py.
Side note -- if you want web2py to generate SQL for any queries, you can form the queries as usual and call the ._select() method instead of .select() -- that will return the SQL as a string rather than actually running the query. Anthony On Saturday, August 25, 2012 5:56:10 PM UTC-4, Yarin wrote: > > I'm assuming there's probably no support for defining stored procedures > using DAL functions. Instead I was going to try to create them in raw sql > using executesql whenever migrate was turned on. Just wondering if this > is the best technique, or someone has another idea > > > --
