Dave,
There is a good example in /packages/general-comments/www/index.tcl.
ad_table takes statement_name as parameter and sql_qry which could be the empty string, I suppose (or, rather, "SQL" to conform with Jun's new guidelines doc).
Also, the "*" after the default sort column in "{orderby {pretty_date*} }" in the declaration section of ad_page_contract is there to tell ad_table that the default sort order should be descending. Leave it out if you want ascending order. This isn't documented IIRC ...
