in reply to SQL::Statement confusing literals and identifiers
SQL::Statement doesn't seem to recognize that "set" means set.
String constants use single quote (') delimiters. Column labels use double quotes ("), and set in your example is a string constant, not a column label.
So the (non-) problem is that it doesn't like parsing illegal SQL. Rewrite your statement as the following, and you should be fine.
SELECT id, gid, card, 'set', illus, num FROM Print
• another intruder with the mooring in the heart of the Perl
In Section
Seekers of Perl Wisdom