Feature request: query formatting

[thousandsofthem]

It would be nice to have query formatting button/hotkey
SQLyog, Sequel Pro can do that (also see http://www.dpriver.com/pp/sqlformat.htm)

P.S. also https://github.com/TaoK/PoorMansTSqlFormatter (http://poorsql.com/), http://sqlformat.darold.net/, many more. part of them are opensource

P.P.S. https://github.com/darold/pgFormatter

[JAertgeerts]

+1: Nice to have

[tmikoss]

Would very much appreciate such feature. I use Postico to debug queries generated by ORM, and a single button press to convert the huge one-liner into a structured query would be greatly appreciated.

[sul4bh]

My vote +1

[firedev]

sqlformat.org has an api that can be used if nothing else fits https://sqlformat.org/api/

For what it's worth I am using Alfred with Format SQL Workflow

[gajus]

For the record, https://sequelpro.com/ is using the API approach to format queries.

It is a bit annoying UX, though since every time you want to format the query they prompt a dialog asking to give permission to send the query to external web service. If this to become a feature in this way, there should be a toggle to remember the selection.

[jakob]

I really don't want to use a web API for formatting queries -- code is private data, and shouldn't be shared needlessly with 3rd parties. Also, performance would be unpredictable, and it would require a network connection.

But I just discovered pgFormatter , a Perl based SQL formatting tool for PostgreSQL. Maybe I can use that to format queries!

You can try pgFormatter here: http://sqlformat.darold.net

[gajus]

Yeah, pgFormatter is quite good. I am using it in my Node.js projects, via https://github.com/gajus/pg-formatter.

[reganjohnson]

Would like to see this also. Options on the formatting would be nice (I prefer to work in lowercase, personally.)

[josestbernard]

+1

[DeMol-EE]

Any update on this feature?

[jetbrand]

I'm using "Automator".
Select sql text and execute created Automator service.

[techkeyur]

Auto-format or hotkey would be awesome +1 from me

[yiichou]

+1

[ynelin]

+1