TDBC

The statement object has a method "getSql" which is not document: 
<nowiki> 
<p>set statement [$db_name prepare {select PATH_ID from PATHS where PATH=:path and parent_id is null}] 
<p>::oo::Obj943372::Stmt::10 
<p>(bin) 71 % $statement getSql 
<p>select PATH_ID from PATHS where PATH=:path and parent_id is null 
<p>(bin) 72 %  
</nowiki>

The statement object currently has an (undocumented) method yielding the underlying sql statement used for the construction of the specific statement object. (using bind variables notation). 
request: add a similar method for the resultset object, showing the substituted values.  
 
Using the example from the man page: 
 
<nowiki> 
<p>package require tdbc::sqlite3 
<p>tdbc::sqlite3::connection create db phonebook.sqlite3 
<p>set statement [db prepare {
<p>    select phone_num from directory where first_name = :firstname and last_name = :lastname
<p> }] 
<p>set firstname Fred 
<p>set lastname Flintstone 
<p> 
<p>$statement getSql gives:  
<p><i>    select phone_num from directory where first_name = :firstname and last_name = :lastname </i> 
<p> 
<p>set rs [$statement execute] 
 
<p><b>Request:</b> 
<p>$rs getSql would give: 
<p> <i>select phone_num from directory where first_name = 'Fred' and last_name = 'Flintstone' </i> 
<p> 
<p> 
 
<p><b>Motivation:</b> this feature would be very helpfull in debugging.. 
</nowiki>