The SQL has invalid syntax because the column list is empty (normally it should be SELECT column1, column2, col3 FROM ...).

That suggests that the column setup may not have worked, but I don't know Class::DBI (and your local class hierarchy) good enough to find the mistake.