Text2SQL

Goal: explore a way to eable LLM use structured data i database. Iput: Table defiitio i stadard SQL DDL laguage, ad query requiremets i huma laguage. Output: SQL query statemet.

Backgroud: This is a fie-tued LLM model based o Qwe-7B-Chat. QLORA(4-bit) was used for fie-tuig. Dataset is https://huggigface.co/datasets/b-mc2/sql-create-cotext/blob/mai/sqlcreatecotext_v4.jso.

Example: User: 数据库中的数据表定义如下CREATE TABLE Persos (PersoID it, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255)); 请严格根据上述表的定义，生成查询语句，查出所有姓李且居住城市是北京的人。 Qwe-Chat: SELECT * FROM Persos WHERE LastName = "李" AND City = "北京"

TODO:

• Geerate dataset (or fid a existig oe) based o SQL laguage referece documets. Use the dataset to trai the model to eable it to uderstad SQL at high level.
• Evaluate the performace of the model

Cloe with HTTP

 git cloe https://www.modelscope.c/allspace/Text2SQL.git

Goal: explore a way to enable LLM use structured data in database. Input: Table definition in standa