checking SQL statement/subexpression validity

[David Garamond <lists@xxxxxxxxxxxxxxxxxxxxx>]

I need to check whether a SQL subexpression (to be used in WHERE 
clause), e.g.:

 colname > 200

or an entire SELECT statement, e.g.:

 SELECT * FROM t1, t2 WHERE colname > 200

is syntactically valid. Is there a quick (and also safe) way to do this? 
I'm thinking of doing "SELECT ... FROM ... WHERE <SQLexpr> LIMIT 0" for 
#1, but I'm not sure if it's 100% safe; and I don't know what to do with 
#2. AFAIK, in, say, Perl's DBI, $dbh->prepare() doesn't check SQL syntax 
and $sth->execute() actually executes the statement.

--
dave

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx