spider
spider copied to clipboard
taoyds
scripts and baselines for Spider: Yale complex and cross-domain semantic parsing and text-to-SQL challenge
Consider the below case: ``` predicted = "SELECT professionals.first_name , professionals.last_name FROM professionals JOIN treatments ON professionals.professional_id = treatments.professional_id WHERE treatments.cost_of_treatment
Hi, I am trying to use the model on new data and struggle to reproduce the tokenization method to obtain the `query_toks` and `query_toks_no_value` fields. I tried using `process_sql.tokenize` which...
the part of sql parser is inconistent about col_unit. the notes show it's a tuple, but result is a number or string.  
Hi, I have looked at a few models contributing to Spider, and many of the GitHub issues include someone asking how to generate a SQL query only providing a question...
Part of the citation used brackets and the other half didn't, so it wasn't working in latex
Training Instance 3153: ```json { "db_id": "assets_maintenance", "query": "SELECT T1.company_name FROM Third_Party_Companies AS T1 JOIN Maintenance_Contracts AS T2 ON T1.company_id = T2.maintenance_contract_company_id JOIN Ref_Company_Types AS T3 ON T1.company_type_code = T3.company_type_code...
Note: SQL usually use single quotes for strings but the old implementation allowed both single and double quoted string as well as a single quoted string to end with a...
Hi, Even though our group spent a lot of time and effort on creating the Spider dataset, there definitely exist some annotation errors. We would appreciate your input if you...
question "What are the booking start and end dates of the apartments with type code "Duplex"?" query SELECT T1.booking_start_date , T1.booking_start_date FROM Apartment_Bookings AS T1 JOIN Apartments AS T2 ON...
I'm trying to generate the parse sql queries for any functions like DATE_FORMAT or any other functions using script in the spider repository, [preprocess/parse_one_sql.py](https://github.com/taoyds/spider/blob/master/preprocess/parse_sql_one.py) to generate this parsed sql query...
