SQL Formatter

[brentonmallen1]

I was looking to do some query pre-processing/cleaning but wasn't able to figure out how something like that is meant to / could be done here. I'm specifically thinking of something along the lines of sqlparse's format functionality - i.e. sqlparse.format(first, reindent=True, keyword_case='upper') to remove things like comments, whitespaces, etc.

If I've missed the intended way to do this, please let me know. I think it's valuable to do this before parsing the query into an AST (for speed?), or maybe either have that as a parsing option or as a method on the AST to provide that clean sql with the .sql call?

Any thoughts or suggestions (if this is out of scope for this tool) would be appreciated.
Thank you!

[georgesittas]

Right now keywords are generally capitalized by default, so that should be good. I'm not sure what reindent does - is it used to prettify SQL by indenting it appropriately? And then regarding comments, whitespaces: you can switch off the former by doing ast.sql(comments=False), and the latter is handled by default too. Have you seen https://github.com/tobymao/sqlglot?tab=readme-ov-file#formatting-and-transpiling?

[brentonmallen1]

thanks for the quick reply! I did see that page but I hadn't realized that there were more formatting options for the output sql like the comments=False. I'll definitely look into that more.

Thank you!