Are there any (Linux based) SQL Query Formatting programs/plugins/extensions?
I use PostgreSQL and MySQL but other DB's are welcome as well.
I can use a VM to test with but would prefer a Linux (Ubuntu) based solution.
I have seen a online version but nothing as a installable.
Eclipse Based IDE's are a plus as well
select f1, f2, fname, lName from tblName where f1 = true and fname is not null order by lName asc
to something like
SELECT f1, f2, fname, lName FROM tblName WHERE f1 = true AND fname IS NOT NULL ORDER BY lName ASC
Here is a online example:
But I would rather this be in a local environment
Looking at this:
While this might be an overkill Jet Brains has a new Database IDE which has some great re-formatting options