Suggestion: It is suggested that text2sql can add table comments and field comments in the project.

[hiccuplp]

Suggestion: It is suggested that table comments and field comments can be added in the project to improve the effect of large model on sql generation.

Background: If the semantic information of the fields in the related table is not enough, or does not have semantic information, then the large model will not be able to map the fields.
However, in some cases, the semantic information of the field name is not enough, but the annotation explains it. Adding this information can help the large model to understand and generate sql.

Table situation

result

[robinji0]

In some case, the comment is ambiguous and will impact the prompt. So we drop the comment for now, maybe will consider in future.