Maybe I just have an issue finding the settings to do the formatting the way I like it, since there are so many things to configure. But I have a few alignment queries.
This code gets formatted OK:
Code: Select all
SELECT b.title,
a.name
FROM books AS b
JOIN (SELECT name
FROM authors) AS a ON a.id = b.authorid;
Code: Select all
SELECT b.title,
name = (SELECT name
FROM authors a
WHERE a.id = b.authorid)
FROM books AS b;
The second thing I have not found is alignment of join conditions. I want it to be something similar to this:
Code: Select all
SELECT b.title,
authors.name
FROM books AS b
JOIN authors AS a ON a.id = b.authorid
AND a.istranslator = 1
JOIN mediatype AS t ON t.media = b.media;
Code: Select all
SELECT b.title,
authors.name
FROM books AS b
JOIN authors AS a ON a.id = b.authorid
AND a.istranslator = 1
JOIN mediatype AS t ON t.media = b.media;
It would be much appreciated if this can be done.