DataGrip allow having AND on the same line as WHERE

Answered

Simply put, I would like DataGrip to allow both of the following formats when it currently only allows the latter one. How would I do so? (I previously made a request for this unintentionally whereas I meant to create a community post)

SELECT e1.emp_id, e2.emp_id
FROM employee AS e1, employee AS e2
WHERE e1.start_date < e2.start_date AND e1.emp_id > e2.emp_id

SELECT e1.emp_id, e2.emp_id
FROM employee AS e1, employee AS e2
WHERE
e1.start_date < e2.start_date
AND e1.emp_id > e2.emp_id
3 comments
Comment actions Permalink

please go to File | Settings | Editor | Code Style | SQL | General (or your SQL dialect) -> queries and set it as follow:

 

1

Please sign in to leave a comment.