01 What happened
Google Cloud has announced the preview of two new SQL functions, ai.classify and ai.extract, integrated into the AlloyDB AI query engine.
02 Key details
- The functions are available in the google_ml_integration extension (version 1.6.1 or later) on PostgreSQL 18.
- ai.classify supports single-label and multi-label modes, including category descriptions and few-shot prompting.
- ai.extract transforms unstructured text into structured JSON data using a provided JSON schema or a text list of fields.
- Smart batching optimizes performance and token costs by grouping inputs into micro-batches for Gemini Enterprise Agent Platform models.
03 Why it matters
Integrating AI directly into the database reduces operational friction, query latency, and the need to move sensitive data to external model endpoints.
04 Who it matters to
Software developers and AI developers.
Original source