[Community feedback] Learn SQL formatting style from examples

[DavLagoHern]

This came up in a recent conversation with a MySQL user who likes the formatting flexibility of JetBrains editors, but would rather not configure dozens of code-style rules manually.

The idea

Instead of manually choosing every indentation and line-break rule, LakeDB could learn a preferred SQL formatting style from a few example queries.

For example, the user could provide examples of:

• SELECT
• INSERT
• UPDATE
• DELETE

LakeDB could then build a formatting profile from those examples and use it when formatting future SQL.

Possible direction

A first version could work as an explicit profile:

1. provide a few example queries formatted the way you like;
2. LakeDB analyzes indentation, line breaks and common formatting choices;
3. save that as a reusable formatting profile;
4. apply it when formatting SQL.

This would be separate from LakeDB's existing formatting modes rather than replacing them.

Looking for feedback

• Would a few example queries be enough to define your style?
• Should formatting profiles be global or per connection/project?
• Would you want to edit the learned rules afterward?
• Should it only learn from explicit examples, or gradually from SQL you write?

This is community feedback, not a release promise yet.

[DavLagoHern]

Quick progress update — the first version of the workflow is now taking shape.

LakeDB can analyze formatted SQL examples locally, detect things like indentation, keyword casing, line breaks, comma placement and clause formatting, and save the result as a custom style.

I’m still refining the UI and the rule detection before calling it finished, but this is the current direction.

Everything stays local — the SQL examples are not sent to QuerIA or any external service.

Feedback on the workflow is very welcome before I finalize it.