[RFE] SQL (extension) function documentation in UI

[saaj]

(from #62)

As a user of sqliteviz, In order to understand what functions are available for the query, I want to be able filter available in the query editor and/or dedicated panel.

SQLite has PRAGMA function_list. This list can be fed to CodeMirror autocomplete, or, say, right pannel with a filter akin to Google Sheets function list.

Question

1. Has CodeMirror a mechanism to feed available SQL functions? An extension needed? Try out monaco-editor as alternative?
2. Is it possible to show documentation snippet in the CodeMirror autocomplete?
3. How to tell which functions are from which extensions?

[twoxfh]

Saaj,

The code currently feeding the drop down is in hint.js

It looks like code mirror has the ability to distinguish the displayText vs the hint. There may be an addon that makes it easier.

I have not seen a standard way of documenting system objects in sqlite, This may need to be another static json based on the default extensions supported.