Row 4496

Row ID: 4496 | Dataset Entry | Axioma AXP Content Repository

Content Data

This page contains data entry 4496 from the Axioma AXP content repository. The structured data below represents the complete record for this entry.

I am developing a text-to-sql project with llms and sql server. where user will ask question in natural language and llms will wrtie sql query, run it on my database and then give me result in natural language. The problem is schema of database is huge and tables names,column names are not self explanatory. Most of the times two tables need to joined on more than one column and in where condition I consistanly want to have some conditions and daterange condition is extremely important as well because without date condition, the user might get data that he's not expected to have access to. is there any way to solve this problem? I have tried using views but that is computationally expensive and takes a lot of time to execute as well. is there any other way?

FieldValue
text I am developing a text-to-sql project with llms and sql server. where user will ask question in natural language and llms will wrtie sql query, run it on my database and then give me result in natural language. The problem is schema of database is huge and tables names,column names are not self explanatory. Most of the times two tables need to joined on more than one column and in where condition I consistanly want to have some conditions and daterange condition is extremely important as well be…
label r/gpt3
dataType post
communityName r/GPT3
datetime 2024-04-14
username_encoded Z0FBQUFBQm5LakwxcVBWb3NtS2k5MGZCTkdGRkZQSTF3dEpmcGF5eVpPVC0wSGZob1pvTHhKSUx5TlVYLUhRM2tDTlZsblZPOHN3R3lrR2VlYl83VXZSZzB5dDdrRmdBNFgtaXlRb05UdlpoZDRNaEk0bkg5OE09
url_encoded Z0FBQUFBQm5Lak9GRkxhQnJweHBLTGNtM2lOY2tHMk83bmdUU2J0akZ6eHcxY29GTnlFY0JyYlBVbmJWdW43bkxlOHZVTTZRSGFpVU9ZNklOY1RuLUYtN0xaSTBZOWkwNURITThZWUlDUk5EdnhDTDhucUVRRnJ1XzhxR1Q3SWVCV0JrektLWWZrR1lDc1FwRnFNTlo5NGxRdHlJV1FwS0FzYmtNTm92aTJlbFp2bDltOTNxSjFkU3FFTWdsT3NtSTI3NW9CY0cxajRE

Raw Record

{
  "text": "I am developing a text-to-sql project with llms and sql server. where user will ask question in natural language and llms will wrtie sql query, run it on my database and then give me result in natural language. The problem is schema of database is huge and tables names,column names are not self explanatory. Most of the times two tables need to joined on more than one column and in where condition I consistanly want to have some conditions and daterange condition is extremely important as well because without date condition, the user might get data that he's not expected to have access to. is there any way to solve this problem? I have tried using views but that is computationally expensive and takes a lot of time to execute as well. is there any other way?",
  "label": "r/gpt3",
  "dataType": "post",
  "communityName": "r/GPT3",
  "datetime": "2024-04-14",
  "username_encoded": "Z0FBQUFBQm5LakwxcVBWb3NtS2k5MGZCTkdGRkZQSTF3dEpmcGF5eVpPVC0wSGZob1pvTHhKSUx5TlVYLUhRM2tDTlZsblZPOHN3R3lrR2VlYl83VXZSZzB5dDdrRmdBNFgtaXlRb05UdlpoZDRNaEk0bkg5OE09",
  "url_encoded": "Z0FBQUFBQm5Lak9GRkxhQnJweHBLTGNtM2lOY2tHMk83bmdUU2J0akZ6eHcxY29GTnlFY0JyYlBVbmJWdW43bkxlOHZVTTZRSGFpVU9ZNklOY1RuLUYtN0xaSTBZOWkwNURITThZWUlDUk5EdnhDTDhucUVRRnJ1XzhxR1Q3SWVCV0JrektLWWZrR1lDc1FwRnFNTlo5NGxRdHlJV1FwS0FzYmtNTm92aTJlbFp2bDltOTNxSjFkU3FFTWdsT3NtSTI3NW9CY0cxajRE"
}

Entry Information