in reply to Re^3: In search of an efficient query abstractor
in thread In search of an efficient query abstractor
Understood. I'm an ex-CS student whose theory is now a distant memory :) But I don't think I need to actually parse SQL to accomplish this. Abstracting away strings and numbers is a much easier problem than parsing a language, and I'm pretty sure it's going to be faster (perhaps not in Perl, though).
Alas, the MySQL grammar is not actually the same thing as the gray box on the manual pages. The real grammar is in sql_yacc.yy which is something from a horror film.