Published at LXer:
I first started getting significantly involved in SQL back in 2000. Within six months I had written pysqldb (one of the many reinvented dynamic SQL generators available) because hard-coding SQL statements I immediately concluded to be insane. I was constantly battling the management of the project because they wanted to create Views - and to get me to use them. I am now, once again, on a major SQL project, this time involving stored procedures. This article describes the SQL experiences - positive and negative - and outlines some of the advice that I've encountered from different sources.