Hi, I am seriously considering implementation of Jupyter Notebook Kernel for SQL (+Java) language utilizing JOOQ.
The Kernel will be capable to: - simultaneously connect to various databases for multiple users utilizing connection pooling, - provide database metadata to client (tables, columns, foreign keys, views, stored procs,...) utilizing JOOQ implementation <https://www.jooq.org/doc/3.11/manual/code-generation/codegen-advanced/codegen-config-database/codegen-database-name/> , - execute database native SQL or standardized SQL translated to native SQL by JOOQ parser functionality <https://www.jooq.org/doc/3.11/manual/sql-building/sql-parser/sql-parser-api/> and return it's results to client Kernel could also support autocomplete and introspection for SQL code written in editor on client side of Jupyter Notebook. The API implemented by kernel <https://jupyter-client.readthedocs.io/en/stable/messaging.html#completion> for autocomplete is pretty simple: client sends code (SQL) string and cursor position, kernel response contains list of autocomplete recommendation strings etc. I am curious if it is possible to use JOOQ for parsing SQL to QueryPart(s), identify which QueryPart <https://www.jooq.org/javadoc/3.11.x/org/jooq/QueryPart.html>corresponds to defined SQL string cursor position and return corresponding autocomplete strings (e.g. with names of available tables in FROM clause, or names of columns in SELECT clause). I don't know if it is suitable to use JOOQ for this task and how. thanks for response -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/eab246d8-2947-4686-9d29-1be0e1ca6182%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
