[Libreoffice-bugs] [Bug 112801] Improve LO SQL parser to allow GUI Query editor usage with more SQL connection varieties

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112801

--- Comment #8 from Howard Johnson <BridgeportContractor at gmail.com> ---
Who would have thought a few years ago that a rocket could be landed, yes on
land without crashing?  But Space-X now lands them just the reverse of how they
take off.  Elion Musk and his Space-X has done the impossible.  So we can make
a much better Base?  I think so.  It starts by imagining the unthinkable.

I believe that it's quite possible to write a parser for the Query GUI editor
which will allow much more widespread SQL varieties to be used.  SQL parsing is
not that hard.  When I was a younger guy I wrote several advanced parsers that
would do the sort of thing I'm suggesting.

This enhancement suggestion is hopefully for some younger hot-shot software guy
who will take up this challenge.  Here are a couple places that describe the
SQL language structure in enough detail to write such a parser:

https://mariadb.com/kb/en/library/sql-language-structure/
https://www.ansi.org/news_publications/news_story?menuid=7&articleid=753a952d-1244-415b-bb92-0010750bb8cd

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171005/5de48a86/attachment.html>