2007/11/28, Karoly Negyesi <karoly@negyesi.net>:
Maybe there is an open-source tool which can validate standard SQL which could be used. Then our DB abstraction could require a verifiable standard SQL syntax which would then be translated (where necessary) into the MySQL, Oracle, Postgres, etc. equivalents. This might only be for CRUD operations (data manipulation statements) and not for DDL, for which we already have a reasonable API and which are much less standardized.
Good. I do not know about open source but http://developer.mimer.com/validator/index.htm offers what you want.
Mimer also provide a free webservice [1] for validating SQL against ISO standards. This webservice has been implemented by two opensource projects: phpMyAdmin [2] and SQuirreL SQL [3]. Can we implement this on devel module? AFAIK it uses SOAP. [1] http://sqlvalidator.mimer.com/index.html [2] http://www.phpmyadmin.net [3] http://squirrel-sql.sourceforge.net Cheers, Henrique