Oracle 9i supports standard SQL join syntax, case expressions, timestamp etc...
My guess is that most queries can now be made identical for both Oracle and Postgresql, and it would make sense to keep 'standard' queries in the Tcl files with any remaining database specific queries in xql files.