带复杂计算的金融领域自然语言查询的SQL生成

何佳壕,刘喜平,舒晴,万常选,刘德喜,廖国琼

SQL generation from natural language queries with complex calculations on financial data

Jia-hao HE,Xi-ping LIU,Qing SHU,Chang-xuan WAN,De-xi LIU,Guo-qiong LIAO

表 5 各个组件可能的槽位值

Tab.5 Possible slot values for each component

组件 槽位 FROM ($TBL)+ SELECT $DIST( $AGG ( $DIST1 $AGG1 $COL1 $ARI $DIST2 $AGG2 $COL2 ) )+ ORDER BY (($DIST1 $AGG1 $COL1 $ARI $DIST2 $AGG2 $COL2) $ORD )* GROUP BY ($COL)* LIMIT $NUM WHERE、 HAVING ($CONJ ( $DIST1 $AGG1 $COL1 $ARI $DIST2 $AGG2 $COL2 ) $NOT $COND $VAL1|$SEL1 $VAL2|$SEL2 )* INTERSECT、 UNION、 EXPECT $SEL