28 Nov
2007
28 Nov
'07
1:41 p.m.
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.