News for hackers. Stuff that matters.
Re:Sqlmap: Automatic SQL injection and database takeover tool by tptacek on Thursday July 05, 2012 @03:03PM (#4204429)
"Whitelist of possible columns".

Congratulations, we are no longer relying on bound parameters to prevent SQL injection. THREAD FINISHED! :)

Re:Sqlmap: Automatic SQL injection and database takeover tool by derpmeister on Thursday July 05, 2012 @03:35PM (#4204585)
You could do without using a CTE, it's just not as convenient most of the time. Alternatively, you could pass the column names to a function (using a prepared statement, no less) and let that function figure out which columns are valid. If your tables change frequently, this would save more time in the long run.
Re:Sqlmap: Automatic SQL injection and database takeover tool by tptacek on Thursday July 05, 2012 @03:41PM (#4204612)
We are talking about manual, purpose-built functionality designed to prevent SQLI in queries that use bound parameters. Don't move the goalposts: nobody is saying it's particularly hard to avoid SQL injection, just that bound parameters aren't a panacea.
Re:Sqlmap: Automatic SQL injection and database takeover tool by Devilboy on Thursday July 05, 2012 @05:13PM (#4204997)
If your tables has SO many columns that you can't simply return them all and show the relevant ones only at the application layer, .... well then just maybe there's something wrong with your database design.