Add option to format upper/lower case only keywords, or only object names

[lukaseder]

The current upper/lower case formatting option will just modify the entire selected string. Sometimes that's not what I want as a user. Usually, I'd like to just upper-case all keywords, as in:

-- before
select 1 "a"

-- after
SELECT 1 "a"

But the identifiers / object names should stay the same. Specifically those that are put in double quotes (or brackets, backticks, depending on the database) should not be modified, because the result would be wrong.

So, there are two ways to tackle this:

1. Add additional formatting options to only upper/lower case all keywords and leave identifiers untouched.
2. Change the existing behaviour and modify only unquoted keywords / names, and leave quoted names untouched.

[serge-rider]

Currently DBeaver doesn't convert identifiers case at all. The only exception is identifiers auto-complete (database case is used for that).
So I don't see any problem. And I don't think that identifiers case should be modified ever.

[lukaseder]

Hmm, not sure what you mean. Consider this:

select 1 "a"

Now select it, right click > format > to upper case and I'm getting this:

SELECT 1 "A"

When I would have preferred to get this instead:

SELECT 1 "a"

[serge-rider]

Case conversion is a very simple function which converts case of all letters. This function is a standard text editor action provided by Eclipse. It doesn't know anything about SQL.
To perform SQL formatting use "Format SQL" (ctrl+alt+f) action.

[lukaseder]

OKOK, let's assume I find the standard Eclipse provided feature useless (because it's wrong to convert "a" to "A"). But I want to normalise all my keywords because that would be very nice. And I don't want DBeaver to format my SQL statement, which I have formatted so nicely, manually with indentation and all.

Do you agree that it would be an interesting feature to just upper-case / lower-case all keywords (and perhaps, unquoted names)?

If it helps, that's how Oracle's SQL Developer works, for instance.

[serge-rider]

Agreed, that makes sense.
Although it may lead to UI over-complexity. Currently we have

• SQL formatter
• Case convertor (upper/lower)

This will be the third way to format SQL. Making two additional actions for case conversion with syntax parser looks too sophisticated. Maybe it'd be better to improve SQL formatter/add extra options.
WDYT?

[serge-rider]

After all I think that this feature can be covered by some external formatter (which now can be configured in preferences).
Making too many different formatters in DBeaver will just confuse users.

[Dian8]

Looks like already converts... Futhermore keywords are converted to lovercase. How to turn this feature off?

[serge-rider]

Preferences->General->Editors->SQL Editor->SQL Formatting->Auto format

[Dian8]

great! thanks!

[valentinmihaylov]

The only exception is identifiers auto-complete (database case is used for that).

How can I change the "database case" to low-case?

[18549]

Being able to auto format keywords to lowercase is the best thing ever.