Datagrip expand column list to new line with comma at beginning

Question

In DataGrip, I want to expand the column list of a SELECT * and put every item onto a new line with a comma at the beginning. This would involve a combination of code style settings.

However, when setting the "Place comma" style to "To beginning", the items in the list no longer appear on a new line each - they appear in one line.

Is it possible in DataGrip for each expanded item to appear on a new line prefixed with a comma?

Answer 1

Assuming you have regex replacement available, you could try something as simple as:

Find:    ,\s*
Replace: ,\n

But you would need to make sure that you are only targeting the SELECT clause. If there were other CSV lists of columns, the above would replace those too. Check the demo here.

Answer 2

Looks like just a bug. Filed it in the issue tracker:

https://youtrack.jetbrains.com/issue/DBE-20230/Setting-Place-comma-style-to-To-beginning-breaks-chopping