> ## Documentation Index > Fetch the complete documentation index at: https://docs.narrative.io/llms.txt > Use this file to discover all available pages before exploring further. # Functions > Overview of built-in and Narrative-specific functions in NQL NQL includes standard SQL functions plus Narrative-specific functions for data collaboration. Functions are organized by category. Text manipulation: UPPER, LOWER, CONCAT, SUBSTRING, TRIM, and more Temporal operations: DATE\_TRUNC, DATE\_ADD, FORMAT\_TIMESTAMP, and more Math operations: ROUND, ABS, CEIL, FLOOR, SQRT, and more GROUP BY computations: COUNT, SUM, AVG, MIN, MAX, and more Collection operations: FILTER, TRANSFORM, SIZE, ELEMENT\_AT, and more Ranking and analytics: ROW\_NUMBER, RANK, LAG, LEAD, and more Geographic calculations: ST\_GeoHash, ST\_Distance, and more Platform-specific: DELTA, budget functions, and more LLM inference and custom models: AI\_COMPLETE, CALL\_MODEL\_FUNCTION Conditional logic: IF, COALESCE, NULLIF, CASE ## Related content Types accepted and returned by functions Comparison, logical, and arithmetic operators Real-world examples using these functions