Better than GPT-4 for SQL queries: NSQL

<h2>&nbsp;</h2> <p>Raise your hand if you have tried to use ChatGPT or any of the other LLMs to generate SQL queries. I have, and I currently am! but I am thrilled to share with you that a new family of open-source large foundation models (FMs) designed specifically for SQL generation tasks has been released. Its name is NSQL. It has got multiple versions starting from NSQL-350M, NSQL-2B, and NSQL-6B. NSQL-6B outperforms all existing open-source models on Standard SQL benchmarks and even commercial general models like ChatGPT, GPT3, GPT3.5, and GPT4.</p> <h1>Off the Shelf vs Fine tune?</h1> <p>Why SQL; SQL is still the most commonly used language. You may be using different flavors of SQL, from Oracle, MySQL, PostgreSQL, to MSSQL; but SQL is still universally used. Wouldn&rsquo;t it be great if we could write SQL queries by asking a large language model? It will offset so much of work and probably democratize access to insights to almost everyone in the company who needs it.</p> <p>How can we make that happen? Usually, we think about either of the two, an off-the-shelf model or fine-tuned Foundation model for a specific task. Both have pros and cons, like off-the-shelf models are trained on the public data and lack the knowledge that is specific to your organization.</p> <p><a href="https://pub.towardsai.net/nsql-first-ever-fully-opensource-sql-foundation-model-f7b501d91ca4">Read More</a></p> <h2>&nbsp;</h2>