You're correct that it doesn't recognize case statements. It does recognize table aliases. I'm not sure what you mean by paramaters.