Building an AI Text-to-SQL Translator in PowerBuilder

Building an AI Text-to-SQL Translator in PowerBuilder

Artificial Intelligence can greatly facilitate access to data, allowing non-technical users to query information naturally. PowerBuilder developers can integrate "Text-to-SQL" capabilities directly into their applications, enabling a dynamic query system powered by Large Language Models (LLMs).

This article demonstrates how to build a smart client in PowerBuilder (w_text_to_sql) that allows users to select a view structure, ask a question in natural language, and receive the results in a DataWindow, interacting in real-time with Google's Gemini 2.5 Flash Lite model via its REST API. All the complete explanations and comprehensive details can be found in the article: Building an AI Text-to-SQL Translator in PowerBuilder (Text to SQL).

"Change the instance variable to your Gemini API key: string is_api_key = "YOUR API KEY HERE""

The application utilizes the PBDemoDB2025 SQL Server database.

Luis Avilan