The invention relates to the technical field of
SQL conversion, in particular to an
SQL conversion
quality optimization method, a medium and equipment, candidate intention labels of initial
SQL statements are generated through an intention prediction model and a preset classification model, the matching degree of the candidate intention labels and an SQL
syntax tree is verified, if the matching degree reaches the standard, the candidate intention labels are directly used, and if the matching degree reaches the standard, the SQL conversion quality is optimized. If the target intention
label does not reach the standard, the structure information and the entity information are fused to recalibrate the target intention
label, and evaluation deviation caused by intention misjudgment is effectively avoided; multi-dimensional quality evaluation is carried out on the basis of the target intention
label, and specific problem information is recorded when the target intention label does not pass, so that accurate positioning of the problem is realized, and a clear direction is provided for subsequent correction; and for the initial SQL statement which does not pass the evaluation, the original demand of the user and the failure reason are fed back to the SQL generation model, and the whole-
process verification is restarted after the new SQL is generated, so that the automatic repair of the SQL statement can be completed without manual intervention, and the
automation level and accuracy of SQL conversion are greatly improved.