Multiple Where Clauses

[jaurment]

Although WikiSQL Test dataset has only one where clause, if we use the shallow layer model on our own training dataset and test set, can SQLlova deal with multiple where clauses. I believe the functions get_wc1, get_wo1, get_wv1 handle this such that you can have multiple condition 'lists'. Would love to get clarification on whether that's true.

What is the case for multiple select columns? Is this something that is possible already or would I need to change the code to accommodate the case of training data with multiple selected columns?

[whwang299]

Hi @jaurment

The SQLova and Shallow-Layer model can handle multiple number of where conditions but these models have assumed that there is only single select column (as is the case of WikiSQL).

Thanks!

Wonseok

[jaurment]

What it would take to extend the code to accommodate multiple select columns?

[zyc1310517843]

如何扩展代码以适应多个选择列？

hi, Have you succeeded yet? If for my own data, how can I input natural language sentences into the program and then predict the corresponding sql?