If the word I manually type matches an AutoComplete entry, apply the case in the AutoComplete to the typed word. This would apply to both reserved words and object names.

Example 1: I type 'sel' and wait a millisecond. 'SELECT' appears in the AutoComplete. I press [space] and SELECT is typed for me. Next, I type 'select' and press [space] without waiting. The word remains lower case.

Example 2:I type 'select * from peo' and wait a millisecond. 'People' (a table name) appears in the AutoComplete. I press [space] and 'People' is typed for me. Next, I type I type 'select * from people' and press [space] without waiting. The word 'people' remains lower case.

In both cases, the word I typed would have appeared in AutoComplete. The case should be set to match regardless of whether I waited for AutoComplete or not.

This rule could be applied when reformatting a document as well.