README.md

---
license: apache-2.0
datasets:
- spider
metrics:
- accuracy
model-index:
- name: lever-spider-codex
  results:
  - task:
      type: code generation             # Required. Example: automatic-speech-recognition
      # name: {task_name}             # Optional. Example: Speech Recognition
    dataset:
      type: spider          # Required. Example: common_voice. Use dataset id from https://hf.co/datasets
      name: spider (text-to-sql)          # Required. A pretty name for the dataset. Example: Common Voice (French)
      # config: {dataset_config}      # Optional. The name of the dataset configuration used in `load_dataset()`. Example: fr in `load_dataset("common_voice", "fr")`. See the `datasets` docs for more info: https://huggingface.co/docs/datasets/package_reference/loading_methods#datasets.load_dataset.name
      # split: {dataset_split}        # Optional. Example: test
      # revision: {dataset_revision}  # Optional. Example: 5503434ddd753f426f4b38109466949a1217c2bb
      # args:
      #   {arg_0}: {value_0}          # Optional. Additional arguments to `load_dataset()`. Example for wikipedia: language: en
      #   {arg_1}: {value_1}          # Optional. Example for wikipedia: date: 20220301
    metrics:
      - type: accuracy         # Required. Example: wer. Use metric id from https://hf.co/metrics
        value: 81.9       # Required. Example: 20.90
        # name: {metric_name}         # Optional. Example: Test WER
        # config: {metric_config}     # Optional. The name of the metric configuration used in `load_metric()`. Example: bleurt-large-512 in `load_metric("bleurt", "bleurt-large-512")`. See the `datasets` docs for more info: https://huggingface.co/docs/datasets/v2.1.0/en/loading#load-configurations
        # args:
        #   {arg_0}: {value_0}        # Optional. The arguments passed during `Metric.compute()`. Example for `bleu`: max_order: 4
        verified: false              # Optional. If true, indicates that evaluation was generated by Hugging Face (vs. self-reported).
---

# LEVER for Codex on Spider

This is one of the models produced by the paper ["LEVER: Learning to Verify Language-to-Code Generation with Execution"](https://arxiv.org/abs/2302.08468).

Authors: [Ansong Ni](https://niansong1996.github.io), Srini Iyer, Dragomir Radev, Ves Stoyanov, Wen-tau Yih, Sida I. Wang*, Xi Victoria Lin*

# Model Details


## Model Description
The advent of pre-trained code language models (CodeLMs) has led to significant progress in language-to-code generation. State-of-the-art approaches in this area combine CodeLM decoding with sample pruning and reranking using test cases or heuristics based on the execution results. However, it is challenging to obtain test cases for many real-world language-to-code applications, and heuristics cannot well capture the semantic features of the execution results, such as data type and value range, which often indicates the correctness of the program. In this work, we propose LEVER, a simple approach to improve language-to-code generation by learning to verify the generated programs with their execution results. Specifically, we train verifiers to determine whether a program sampled from the CodeLM is correct or not based on the natural language input, the program itself and its execution results. The sampled programs are reranked by combining the verification score with the CodeLM generation probability, and marginalizing over programs with the same execution results. On four datasets across the domains of table QA, math QA and basic Python programming, LEVER consistently improves over the base CodeLMs (4.6% to 10.9% with code-davinci-002) and achieves new state-of-the-art results on all of them.


- **Developed by:** Yale LILY Lab and Meta AI
- **Shared by [Optional]:** Yale LILY Lab

- **Model type:** Text Classification
- **Language(s) (NLP):** More information needed
- **License:** Apache-2.0
- **Parent Model:** T5-base
- **Resources for more information:**
 	- [Github Repo](https://github.com/niansong1996/lever)
 	- [Associated Paper](https://arxiv.org/abs/2302.08468)


# Uses
 

## Direct Use

This model is *not* intended to be directly used. LEVER is used to verify and rerank the programs generated by code LLMs (e.g., Codex). We recommend checking out our [Github Repo](https://github.com/niansong1996/lever) for more details.
 
## Downstream Use

LEVER is learned to verify and rerank the programs sampled from code LLMs for different tasks. 
More specifically, for `lever-spider-codex`, it was trained on the outputs of `code-davinci-002` on the [Spider](https://yale-lily.github.io/spider) dataset. It can be used to rerank the SQL programs generated by Codex out-of-box.
Moreover, it may also be applied to other model's outputs on the Spider dataset, as studied in the [Original Paper](https://arxiv.org/abs/2302.08468).


 
## Out-of-Scope Use
 
The model should not be used to intentionally create hostile or alienating environments for people. 
 
# Bias, Risks, and Limitations
 
 
Significant research has explored bias and fairness issues with language models (see, e.g., [Sheng et al. (2021)](https://aclanthology.org/2021.acl-long.330.pdf) and [Bender et al. (2021)](https://dl.acm.org/doi/pdf/10.1145/3442188.3445922)). Predictions generated by the model may include disturbing and harmful stereotypes across protected classes; identity characteristics; and sensitive, social, and occupational groups.



## Recommendations
 
Users (both direct and downstream) should be made aware of the risks, biases and limitations of the model. More information needed for further recommendations.

# Training Details
 
## Training Data
 
The model is trained with the outputs from `code-davinci-002` model on the [Spider](https://yale-lily.github.io/spider) dataset.
 
## Training Procedure

20 program samples are drawn from the Codex model on the training examples of the Spider dataset, those programs are later executed to obtain the execution information.
And for each example and its program sample, the natural language description and execution information are also part of the inputs that used to train the T5-based model to predict "yes" or "no" as the verification labels.

 
### Preprocessing
 
Please follow the instructions in the [Github Repo](https://github.com/niansong1996/lever) to reproduce the results.


 
### Speeds, Sizes, Times
 
More information needed 


 
# Evaluation
 
 
## Testing Data, Factors & Metrics
 
### Testing Data
 
Dev set of the [Spider](https://yale-lily.github.io/spider) dataset.
 
### Factors
More information needed
 
### Metrics
 
Execution accuracy (i.e., pass@1)
 
 
## Results 
 

### Spider Text-to-SQL Generation
|                 | Exec. Acc. |
|-----------------|------------|
| Codex           |     75.3   |
| Codex+LEVER     |     81.9   |



 
# Model Examination

More information needed

 
# Environmental Impact
 
Carbon emissions can be estimated using the [Machine Learning Impact calculator](https://mlco2.github.io/impact#compute) presented in [Lacoste et al. (2019)](https://arxiv.org/abs/1910.09700).
 
- **Hardware Type:** More information needed
- **Hours used:** More information needed
- **Cloud Provider:** More information needed
- **Compute Region:** More information needed
- **Carbon Emitted:** More information needed
 
# Technical Specifications [optional]
 
## Model Architecture and Objective
 
`lever-spider-codex` is based on T5-base.

## Compute Infrastructure
 
More information needed
 
### Hardware
 
 
More information needed
 
### Software
 
More information needed.
 
# Citation

 
**BibTeX:**
 
 
```bibtex
@inproceedings{ni2023lever,
  title={Lever: Learning to verify language-to-code generation with execution},
  author={Ni, Ansong and Iyer, Srini and Radev, Dragomir and Stoyanov, Ves and Yih, Wen-tau and Wang, Sida I and Lin, Xi Victoria},
  booktitle={Proceedings of the 40th International Conference on Machine Learning (ICML'23)},
  year={2023}
}
```
 
 
 
 
# Glossary [optional]
 
More information needed

# More Information [optional]
More information needed 

 
# Model Card Authors [optional]
 
Yale LILY Lab in collaboration with Ezi Ozoani and the Hugging Face team

# Model Card Contact
 
Ansong Ni, contact info on [personal website](https://niansong1996.github.io)
 
# How to Get Started with the Model
 
This model is *not* intended to be directly used, please follow the instructions in the [Github Repo](https://github.com/niansong1996/lever).