Datasetpublic

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.

sourceHugging Facecc-by-4.0updated 3y agoView on Hugging Face

2likes32downloads

Dataset Card

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:

python

@dataclass
class SQLQuery:
    query: str
    results: Optional[list[tuple]] = None

@dataclass
class SQLSample:
    question: str
    labels: list[SQLQuery]
    prediction: Optional[SQLQuery] = None
    pred_eval: str = ""
    comment: str = ""

Can be read in through the code from the related repository.