Since both ML [1] and SQL can be used to select cells from a table, can I convert one to the other?
This allows creating SQL in a smart way (select cells -> build SQL, hence the name inverse SQL).
Yes.
Create a decision tree (an ML predictor) from the cells selected
Formulate it as SAT
Simplify it
Convert to SQL.
Demo on streamlit.
Love to hear your thoughts and suggestions on this!
[1]: ML = machine learning, here I’m using decision trees