Just a quick note: I added a few tables to the PeopleTools Tables list:
SQL Definitions
- PSSQLDEFN — header record; last update time, etc.
- PSSQLTEXTDEFN — stores actual text in the SQL definition
I also updated the Application Engine section with some links to related posts.