Hello,
I've been playing around with the tool, and for the most part, it does want I expect it to do. However, I've got my preferences for writing queries, and I I could not configure the tool for following them.
As a matter of fact, I like to write a query along a virtual vertical line, with the main statement keywords glued on its left hand side and the other statements glued at the right hand side. Better with an example.
A query like:
SELECT a, b, count(*)
FROM c
WHERE a = 1
GROUP BY a, b
HAVING count(*) > 1
ORDER by 1, 2
would become
SELECT a, b, count(*)
FROM c
WHERE a = 1
GROUP BY a, b
HAVING count(*) > 1
ORDER BY 1, 2
where the virtual vertical line starts at the end of the SELECT keyword. I use a similar syntax for the other main DML statements, i.e. UPDATE and DELETE. Of course, if they are subqueries of any sort, I like to format them along a similar fashion).
With kind regards,
Emmanuel
I've been playing around with the tool, and for the most part, it does want I expect it to do. However, I've got my preferences for writing queries, and I I could not configure the tool for following them.
As a matter of fact, I like to write a query along a virtual vertical line, with the main statement keywords glued on its left hand side and the other statements glued at the right hand side. Better with an example.
A query like:
would become
where the virtual vertical line starts at the end of the SELECT keyword. I use a similar syntax for the other main DML statements, i.e. UPDATE and DELETE. Of course, if they are subqueries of any sort, I like to format them along a similar fashion).
With kind regards,
Emmanuel