deepset/stackoverflow-survey-2023-text-sql
BIQA Text-to-SQL Dataset The data is from the Stack Overflow Developer Survey 2023. Created with this Notebook; uses this spreadsheet defining manual adjustments. data/eval_set_multi_answers_res.json: Question and query pairs as list of SQLSamples with possibly more than one valid SQL for a question. Also results included. data/survey_results_normalized_v2.db: The main sqlite db file. The json file contains a list of SQLSample objects as defined: @dataclass class SQLQuery:… See the full description on the dataset page: https://huggingface.co/datasets/deepset/stackoverflow-survey-2023-text-sql.
235
1---2license: cc-by-4.03task_categories:4- text-generation5language:6- en7size_categories:8- n<1K9---10 11# BIQA Text-to-SQL Dataset12 13The data is from the [Stack Overflow Developer Survey 2023](https://survey.stackoverflow.co/2023/).14 15Created with this [Notebook](https://colab.research.google.com/drive/12NUeRMsld0toXMSXKFMaQVAv58XwOAT1?usp=sharing); uses [this spreadsheet](https://docs.google.com/spreadsheets/d/1Xh_TgMbyitvtw08g0byEmBpkwDGZDdBYenthOzcK6qI/edit?usp=sharing) defining manual adjustments.16 17- `data/eval_set_multi_answers_res.json`: Question and query pairs as list of `SQLSample`s with possibly more than one valid SQL for a question. Also results included.18- `data/survey_results_normalized_v2.db`: The main sqlite db file.19 20The json file contains a list of `SQLSample` objects as defined:21 22```python23@dataclass24class SQLQuery:25 query: str26 results: Optional[list[tuple]] = None27 28@dataclass29class SQLSample:30 question: str31 labels: list[SQLQuery]32 prediction: Optional[SQLQuery] = None33 pred_eval: str = ""34 comment: str = ""35```36 37Can be read in through the code from the [related repository](https://github.com/deepset-ai/biqa-llm).