Skip to main content
. 2021 Dec 8;9(12):e32698. doi: 10.2196/32698

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.