Jetisu project has dependency on sqlglot

[DavidPratten]

Hi Team,

Just a brief note to let you know of a new project that is depending on sqlglot.

https://github.com/DavidPratten/jetisu is a toolset for modelling with intensionally defined relations (tables). These tables are defined by rules between the column values rather than by listing the rows in the table.

Sqlglot

Sqlglot plays an indispensable part in the project to:

• parse queries, extracting the table name and the WHERE clause, which are passed to a Minizinc solver
• execute queries against the data returned from the solver.

Next Steps

Currently, the solver runs prior to the execution of the SQL query. Next step, is to enable the SQL join of two intensionally defined relations by invoking the solver as a call-back from within sqlglot.execute().

[tobymao]

cool, let me know if you have any questions. happy to chat!

[DavidPratten]

Thanks @tobymao I might reach out for some tips when I get to calling the solver as part of query execution.

[tobymao]

feel free to join me in my slack channel

https://join.slack.com/t/tobiko-data/shared_invite/zt-1ma66d79v-a4dbf4DUpLAQJ8ptQrJygg