Table 3.
Accuracy of each component of SQL query.
| Methods | Validation | Test | |||||||||
|
|
Agg a op b | Aggcol c | Table | Con d c+o e | Conval f | Aggop | Aggcol | Table | Conc+o | Conval | |
| Coarse2Fine | 0.321 | 0.313 | 0.321 | 0.260 | 0.214 | 0.524 | 0.490 | 0.528 | 0.448 | 0.413 | |
| Seq2Seq | 0.978 | 0.872 | 0.926 | 0.471 | 0.174 | 0.970 | 0.696 | 0.892 | 0.565 | 0.296 | |
| SQLNet | 0.994 | 0.939 | 0.933 | 0.722 | 0.080 | 0.989 | 0.873 | 0.941 | 0.749 | 0.140 | |
| PtrGen | 0.987 | 0.917 | 0.944 | 0.795 | 0.236 | 0.987 | 0.830 | 0.926 | 0.824 | 0.235 | |
| TREQS | 0.990 | 0.912 | 0.942 | 0.834 | 0.694 | 0.993 | 0.827 | 0.941 | 0.844 | 0.763 | |
| MedTS | 0.994 | 0.988 | 0.971 | 0.893 | 0.785 | 0.991 | 0.985 | 0.951 | 0.919 | 0.851 | |
aAgg: aggregation.
bOp: operation.
cCol: column.
dCon: condition.
ec+o: column and operation.
fVal: value.