I have some situation where code generates SQL queries based on current structure of table and new version of table structure. How can I check those queries generated by the class are valid because sometime the class causes the errors building alter, drop column queries specially when it is related to primary key, auto number togather.
so I want to put something in place so I can see if the generated queries have any errors or not, before executing them. I can't do it in transactions because its alterations on table. I am using ADOdB for PHP