Suggestion: use JSQLFormatter for SQL beautification
- Dominant language
- Java
- Stars
- 5.6k
- Forks
- 559
- Avg merge
- 1d 14h
- Merged PRs (30d)
- 43
Description
Greetings,
I just adopted Spotless to format my Java code via the Eclipse Formatter. Thank you for providing it!
Then I stumbled over the documentation and found out that you use DBeaver and Prettier for SQL formatting.
So I wonder, if [JSQLFormatter](http://manticore-projects.com/JSQLFormatter/index.html) would be a viable alternative.
It is a relatively small, yet powerful Java only library for formatting complex SQL statements (MS SQL Server, Oracle, MariaDB, Postgres).
Please have a look at the [Examples](http://manticore-projects.com/JSQLFormatter/samples.html).
You can also [Test it online and interactively](http://jsqlformatter.manticore-projects.com).
If you find any of that interesting, then please do let me know what was needed to make it happen. I would gladly be of assistance.
Cheers!
Contributor guide
Research direction
The issue names no repository files or tests. Start by reviewing how Spotless currently documents or integrates DBeaver and Prettier for SQL formatting, then evaluate JSQLFormatter's Java-only support for the listed SQL dialects. Done would require an agreed integration scope and maintainer decision.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- tooling
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100