Using LLMs for Text-to-SQL generation on the Guide to Pharmacology

guidetopharmacology
In the last academic year (September 24 – April 25) we supported two undergraduate, final-year projects (Honours Projects) that looked into uses of ‘artificial intelligence’ tools to improve access to or capabilities of the Guide to Pharmacology. Both projects focussed on the uses of Large Language Models (LLMs) (such as OpenAI’s ChatGPT) to translate natural language queries to Structured Query Language (SQL) statements. This text-to-SQL conversion has the potential to enhance the ways users...