Formatting SQL would be fantastic

[martoiu]

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]

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]

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