Feature Request: --annotations & special characters format

[Chasen-Zhang]

before:

SELECT    column2, column1 from      ntegration_dnvcdtfusz; --Reference: /sql/sql-commands/ddl/table/ddl-create-table

after format:

SELECT
  column2,
  column1
from
  airbyte_integration_dnvcdtfusz;

--Reference:/sql/sql-commands/ddl/table/ddl-create-table

I expect that such annotations will not need to be changed either.

BTW:

before:

select 4 <->  3;
select 1 << 4;
select  1 !== 1;

after(Additional spaces):

select
  4 < - > 3;
select
 1 < < 4;
select  
   1 != = 1;

Perhaps there are other symbols as well

[nene]

The first issue happens because the comment is after a semicolon and the formatter uses semicolons to separate SQL statements with empty lines. This won't happen with comments that are at the end of other lines. But a comment right after semicolon situation is not really handled well by the formatter.

The second issue depends on the SQL dialect you're using (I don't know which one it is) and is generally solved by selecting a correct dialect to format.

[nene]

Also, please don't report multiple different issues within one. It's really inconvenient to deal with. And I don't know why you chose to report this as a feature request - looks more like a bug report to me.

[Chasen-Zhang]

SORRY

[Chasen-Zhang]

I would like to ask, if I want to develop my own SQL dialect, how should I start? Are there any relevant documents available?
@nene

[nene]

See the docs for dialect config option.