I don't like SQL::Abstract, I find that it abstracts too much. It is OK, for a simple SQL query, but once it starts to get complicated, so does the data structure for SQL::Abstract. While it might be more portable than written database specific SQL, I find that idea offers very little value considering how rarely the situation crops up.