phrohdoh / tsqlust

[on hold] Human-friendly T-SQL (lexing, parsing, error reporting, query execution)
http://www.phrohdoh.com
GNU General Public License v3.0
5 stars 1 forks source link

Road ahead #12

Open shashankp opened 7 years ago

shashankp commented 7 years ago

Seems like a good candidate to build SQL productivity tool like SqlPrompt & can have build integration. Did you try it or plan to do so?

Closest alternative for SQL AST I've seen is Transact SQL ScriptDom which is comprehensive & from Microsoft but not opensource though.

phrohdoh commented 7 years ago

Part of the idea is definitely to build a UI-based tool similar to SqlPrompt / dbForge / whatever VS bakes in.

The overarching goal of this project is to provide query-writers with human-friendly messages (errors, or [style, perf] warnings), instead of "invalid syntax" (which is often what dbForge throws at me, it even lacks a location!) which I personally would find very helpful.

Rust isn't quite GUI-ready so writing wrappers in other languages (#2) is probably the best way forward for that venture. Perhaps an Electron-based tool would work well to show off / test the library's functionality.

I have not put any effort into building an interface, yet, because the library itself is still so incomplete (mainly: it can only handle valid input).

If you, or anyone else, are interested in working on the project (or just chatting about it) feel free to join me on the #orcaware channel of the freenode IRC network! :-)

phrohdoh commented 7 years ago

22 is a step towards a UI.