Not seeing xql sources has bugged me for a long time. As I just posted in a bug/suggestion:
"In situations where there is old (often very old) sql source in the tcl itself, life can ve VERY confusing!
The api-browser should show the xql source, and preferably parse the xml for nice output."
I just hacked a bodgy quick fix others which I have uploaded as patches to teo files in acs-api-browser.
I added an -xql switch to api_proc_documentation which just outputs the relevant xql files. Note that it doesn't do anything smart with the xml (if this were a textbook, I would say "that is an exercise left up to the reader" ;)
I then added the -xql switch to the call to api_proc_documentation in proc_view. It should _probably_ be dealt with seperately (ie. | show sql | etc.)
The relevant links are:
suggestion:
https://openacs.org/bugtracker/openacs/bug?bug_number=155
patches:
https://openacs.org/bugtracker/openacs/patch?patch_number=48
https://openacs.org/bugtracker/openacs/patch?patch_number=49