Search code examples
sqlpostgresqlformattingjetbrains-idedatagrip

How to use DataGrip SQL formatter to align USING/ON clause


How can I get theon or using clause to start under thejoin statement indented 2/4 spaces from the start of thejoin?

-- bad
select *
from table1
  join table 2
using (some_col)
-- bad
select *
from table1
  join table 2
       using (some_col)
-- good
select *
from table`
  join table2
    using (some_col)

Solution

  • As of now, JetBrains IDEs don't support this SQL formatting configuration. There is an open ticket to get it added: https://youtrack.jetbrains.com/issue/DBE-8061