You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
How can I convert the following code in "sql" field into the original SQL query
{"phase": 1, "table_id": "1-1000181-1", "question": "Tell me what the notes are for South Australia ", "sql": {"sel": 5, "conds": [[3, 0, "SOUTH AUSTRALIA"]], "agg": 0}}
I tried using lib.query.Query.from_dict method but get SELECT col5 FROM table WHERE col3 = SOUTH AUSTRALIA
and tried using lib.dbengine.DBEngine.execute_query method but get SELECT col5 AS result FROM table_1_1000181_1 WHERE col3 = :col3. None of the above two methods get the correct SQL query, so how can I get it? Anybody help?
The text was updated successfully, but these errors were encountered:
How can I convert the following code in "sql" field into the original SQL query
I tried using
lib.query.Query.from_dict
method but getSELECT col5 FROM table WHERE col3 = SOUTH AUSTRALIA
and tried using
lib.dbengine.DBEngine.execute_query
method but getSELECT col5 AS result FROM table_1_1000181_1 WHERE col3 = :col3
.None of the above two methods get the correct SQL query, so how can I get it? Anybody help?
The text was updated successfully, but these errors were encountered: