|Subject:||Support for SQL statement regeneration after params are added|
I am currently using SQL::Parser/Statement for some SQL parsing in a DBD module before it's sent off to the database. The database supports SQL (but not params), so it doesn't actually need to execute via SQL::Statement. However, while the terms and parameters are neatly arranged in a where_terms tree, there are three problems with trying to add the params: 1. The SQL::Eval module allows for a params method, but it's too far into the process, as it already requires database access. 2. The SQL::Statement::Placeholder objects don't actually have the ARGNUM defined for some strange reason, so you can't tell which real value goes on which param. 3. There is no function to reverse the where_terms process back to an SQL statement. Could something like that be implemented?