I'm trying to use Heidi with MS SQL. It really is annoying how MS SQL Server is case sensitive with regards to table and field names. I cannot change collation of the database at a whole, and table names in the software I work with are UPPERCASED, all fieldnames too. This is sooo annoying, I keep getting errors, I keep fixing the queries over and over again.
So here's a thought: text parser of a query editor knows which bit of the query text is a table or field name, or generally a database object name. It knows because it applies syntax coloring or intellisense lookups. So why not have an option (per-database setting) to change case of database object names on the fly -- either while typing or before execution. The result of such case change should be visible in editor.