That vendor needs to be burned at the stake.
And then we'll scatter the ashes at a cross-roads.
And then sow the ground with salt.
Although, I've seen scarier stuff generated by ORM tools, especially nHibernate.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning