SQL

Unlocking Efficient Data Retrieval with Query Construction Techniques in RAG Systems

by
Unlocking Efficient Data Retrieval with Query Construction Techniques in RAG Systems

Click 👇🏻 to follow, article from “ With the expanding application of large language models (LLMs), Retrieval-Augmented Generation (RAG) has become a mature technology. The popularity of products like txt2sql and ChatBI highlights the increasing importance of query construction techniques. This article analyzes the process of query construction and illustrates, through examples, how to transform … Read more

Data Engineer: Cursor for Precise Processing

by
Data Engineer: Cursor for Precise Processing

1. Data Engineer: Cursor for Precise Processing Late at night, only the frogs and the dim light of the monitor remained in the office. “Ribbit, Xiao Ke, this SQL query is too complicated, it’s making my head spin!” The frog rubbed its eyes, its tone filled with fatigue. Xiao Ke smiled and walked over to … Read more

Agentic RAG: Extending RAG to SQL Databases

by
Agentic RAG: Extending RAG to SQL Databases

Figure: Agentic RAG (Image from the author) 1. Introduction Given the way technology evolves, we have become accustomed to thinking about certain solution constructs from the perspective of specific tools and platforms. For example, Retrieval-Augmented Generation (RAG) is ubiquitous in today’s Gen AI world. Given its emergence in the Gen AI era, we mainly view … Read more