At 05:01 AM 10/07/2010, you wrote:

>How can I tell Firebird/Flamerobin to use lowercase for identifiers (such as table names, variables etc) AND uppercase for SQL?
>
>For an example:
>SELECT account_id, account_name FROM accounts WHERE account_id = 1;
>
>is so much easier to read than:
>
>SELECT ACCOUNT_ID, ACCOUNT_NAME FROM ACCOUNTS WHERE ACCOUNT_ID = 1;
>
>As you can see, there is "visual cues" in the first statement and when debugging very large SQL statements, it makes it easier.

In SQL, what you type is what you get: a standards-conformant SQL engine has parsers that "know" what to do with lower-case, identifiers, keywords, quotes (single or double: they mean different things) and whitespace.

I'm assuming here you know the difference between case-sensitive and case-insensitive identifiers in std SQL.

Any DSQL you use persistently will live in your application code so it's up to you (and your source editor) how you write it and how you get it back for review.

As for tools you use to run and debug ad hoc DSQL or to compose PSQL: an SQL-aware editor might come with a pretty-printing feature. If you want to shop for something like that, please ask on firebird-tools (you can subscribe at http://firebirdsql.org/index.php?op=lists). It's also a suitable place to ask the FlameRobin guys about current and planned features in their editors.

^ heLen ^