SQL functions v7
AIDB functions are available as standalone SQL functions that you can call directly in queries for one-off transformations, testing and exploration, or to build custom workflows outside of the pipeline framework.
Each page here focuses on usage context and examples. For terse parameter tables and return types, see the API reference:
- Transformation functions (
chunk_text,parse_html,parse_pdf,perform_ocr,summarize_text) are in Reference → Functions - Inference functions (
encode_text,decode_text,rerank_text) are in Reference → Models.
| Page | Functions | What it covers |
|---|---|---|
| Chunking | aidb.chunk_text() | Splitting text into segments for LLM context windows |
| Parsing | aidb.parse_html(), aidb.parse_pdf() | Extracting readable text from HTML and PDF inputs |
| OCR | aidb.perform_ocr() | Extracting text from images using an OCR-capable model |
| Summarization | aidb.summarize_text(), aidb.summarize_text_aggregate() | Generating and aggregating AI-powered text summaries, use cases, and cookbook |
| Encoding and decoding | aidb.encode_text(), aidb.decode_text(), and variants | Embedding text and images into vectors; generating completions |
| Reranking | aidb.rerank_text() | Scoring and reordering candidate passages by relevance |
Note
To use these operations as steps inside a pipeline, see Pipeline steps.