SQL::Abstract is decent for simple stuff. When things get complicated... You are basically shooting yourself in the foot. It is hard to keep track of complicated conditionals and evaluations.

I would recommend you create a View in your database which preps the data for you or write Perl code which pulls the data from the database and then reformats it to the result that you desire.