Generate SQL that match your selection, with decision trees

1. User doesn't want to write SQL.
2. User uploads CSV to inversql streamlit app
3. User selects cells (that will be selected by the SQL).
4. We overfit a scikit-learn binary decision tree on the data.
5. We decompose the tree, convert to boolean logic (explainable AI part).
6. We simplify the logic with sympy.
7. Generate SQL from previous steps (joins to JOIN and boolean to WHERE).
8. User sees the SQL.
9. User is happy.

🎬 Demo in a GIF	🏛️ Architecture diagram
Link to live demo site here.

🏎️ Performance

For each individual SQL query candidate (the shortest one is displayed in the UI), we need to retrain a new decision tree.

But... The decision tree fitting is honestly fast, don't worry about this.

🌟 Give us a star!

That's pretty much it!

If you have read this far, please consider giving me a star (⭐) or a fork (🍴).

This will keep my motivation going!

Or if you have too much cash at hand:

If you REALLY like my work, nowadays I'm working on aioway, it's an automated training and inference engine that does the following:

1. Adapt to hardware it runs on (optimal hardware usage)
2. Adapt to data it trains on (figure out architecture on its own)
3. Incremental training (never overfit or underfit)

👨‍👨‍👦‍👦 Contributors

Contribution welcome!

To contribute, refer to CONTRIBUTING.md, and our CODE_OF_CONDUCT.md.

🎨 Inspiration.

Inspired by regexgen's process. Instead of regex we do SQL. Instead of selecting text we do select records. Decision tree is my inspiration tho.