> If you have keyword DISTINCT in your SQL, this SQL would be non-optimizable by Rushmore.

Are you sure? I can't confirm that. A quick test of simple queries including DISTINCT shows full optimization. The DISTINCT clause would slow things down some, but it is often necessary.