formatting the AST while preserving the source location information from the original query

In the current sqlparser, parsing

select
  a,
  b
from
  t

and then fromatting it back to a string results in

select a,b from t

Since sqlparser v0.53, we have the source location information inside the AST, which theoretically makes it possible to reconstruct the original query formatting (or at least getting very close to it).

I know this is a huge undertaking, but it would be really useful. For instance, in sqlpage, I would love being able to respect the initial user formatting of queries, in order for database errors that contain source position information to be meaningful and not confusing.

I'm opening this issue to start discussing this with the community (and especially with you @iffyio and @alamb 😉 ).

Am I the only one interested in this ? What would be the best approach to implementing this ?

未指定特定的檔案或測試。先檢查 sqlparser v0.53 中引入的 AST 原始碼位置支援，以及現有的格式化路徑；當能夠足夠精確地重建原始查詢的格式，使原始碼位置仍然具有意義時，即表示完成。