Address Case Sensitive Information Schema Retrival

[sundarshankar89]

          > LGTM, Can you add a TODO mentioning we are assuming objects are case insensitive.

having said that, should we handle this per dialect so that we don't run into database specific case handling issues?

Originally posted by @sundarshankar89 in #1575 (comment)