diffplug / diffplug/spotless

Suggestion: use JSQLFormatter for SQL beautification

Open
#1,306 1 comment 0 reactions 0 assignees View on GitHub
enhancement
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.