AI Functions in SQL | SingleStore – Run Generative AI on Your Data

SingleStore has introduced AI Functions, a new capability that allows users to execute generative AI and embedding models directly on their data using SQL, thereby eliminating the need for data movement and reducing latency, complexity, and cost. This feature enables business analysts and application engineers to perform tasks like sentiment analysis, translation, and text summarization using SQL, without requiring new frameworks or complex APIs. AI Functions are designed to operate in real-time due to SingleStore's Hybrid Transactional/Analytical Processing (HTAP) architecture, which allows them to run on live data instantly. These functions, delivered as managed Python User-Defined Functions within SingleStore Aura cloud service, include tools like AI_COMPLETE for text generation and AI_SENTIMENT for sentiment analysis. By leveraging a containerized approach, AI Functions aim to rapidly adapt to AI innovation, offering a comprehensive toolkit for natural language processing and vector embedding tasks. Additionally, the architecture's massively parallel processing and HTAP design enhance performance, enabling operational AI applications like real-time fraud detection and customer support automation. SingleStore plans to expand this capability with more AI and machine learning functions, including time-series forecasting and anomaly detection, to further support enterprise operational AI needs.