DataGrip MySQL subquery indent and ending parenthesis placement

Answered

I would like my formatting profile to format a query like this:

SELECT fname, lname
FROM student
WHERE EXISTS(
SELECT *
FROM enroll
WHERE enroll.sid = student.sid
);

However, it formats the query like this:

SELECT fname, lname
FROM student
WHERE EXISTS(
SELECT *
FROM enroll
WHERE enroll.sid = student.sid
);

How do I change my Code Style profile such the query is formatted like the first one?

Here is the Code Style profile in question.

Please sign in to leave a comment.