Currently, SQL comments are displayed before the WITH clause if there is one, but in the future, they will be displayed immediately before the SELECT clause.
In addition, a new function called a header comment clause will be added.
This will always be output first.
Reason
The WITH clause contains a mixture of other functions that belong to itself and those that belong to subqueries, etc., so it is not appropriate to display them before the WITH clause.
However, having a comment at the beginning of the SQL makes it easier to investigate from the log.
Therefore, the comments will be divided into two types.
Currently, SQL comments are displayed before the WITH clause if there is one, but in the future, they will be displayed immediately before the SELECT clause.
In addition, a new function called a header comment clause will be added. This will always be output first.
Reason
The WITH clause contains a mixture of other functions that belong to itself and those that belong to subqueries, etc., so it is not appropriate to display them before the WITH clause.
However, having a comment at the beginning of the SQL makes it easier to investigate from the log.
Therefore, the comments will be divided into two types.