search

PavelTorgashov / FastColoredTextBox

Fast Colored TextBox for Syntax Highlighting. The text editor component for .NET.
Other
1.21k stars 463 forks source link

Formatting SQL would be fantastic #248

Open martoiu opened 2 years ago

martoiu commented 2 years ago

It would be great if one could format the SQL in the TextBox human friendly.

Imagine that I have the SQL "Select id, title, name FROM Blogs" and calling some method, the TextBox would format it like:

SELECT id ,title ,name FROM Blogs

WrongBit commented 2 years ago

Two problems: 1) formatting SQL is not so trivial - it's enough to introduce nested query and you fall into complex parsing problem. 2) Kind of formatting you offer - I immediately dislike it, because I format like this:

SELECT smt
FROM that
LEFT JOIN him
ORDER BY zat

How you gonna select proper look? :) How many people - that many variants.

And finally... guys, it's ENGINE FOR EDITOR, it's not IDE! Don't expect it will do all job for you. Wanna formatting? Write IDE and do whatever you like, task of engine - just give you tool to present & edit text.

AyProductions commented 2 years ago

By the way, this editor also allows you to make your own formatting. Better do it on your own. :)