From Benchmarks to Production: A Text-to-SQL System for Complex Financial Data
This work addresses the critical limitation of general-purpose Text-to-SQL models, which achieve less than 50% accuracy on production-grade financial databases containing opaque keys. To overcome this, we propose FLINT, a system that introduces a lookup agent to resolve concept mapping challenges and combines expert template retrieval with dynamic parsing for precise SQL generation. Furthermore, FLINT optimizes structured schema linking through foreign key chain traversal pruning. Built upon a large language model and domain-specific agent architecture, FLINT significantly outperforms existing state-of-the-art baselines on a production dataset comprising 359 queries. The system has been successfully deployed in real-world financial data retrieval services, offering an effective semantic parsing solution for complex industrial databases.