Skip to content
AIV

AIV Custom Column Buddy

Custom Column Buddy is an intelligent column expression generator that converts natural language requests into DuckDB SQL expressions for creating custom calculated columns. This tool assists users in building complex column formulas with ease by translating plain English requests into accurate DuckDB expressions, eliminating the need to manually write SQL syntax.

Key Features

Natural Language to SQL Expression Conversion: Simply input a plain English request, and Custom Column Buddy will generate the corresponding DuckDB expression for your custom column.

Example:

  • Input: “Multiply price with quantity”

  • Output: CAST(priceEach AS DOUBLE) * CAST(quantityOrdered AS DOUBLE)

Two Ways to Access Custom Column Builder:

  1. Add/Edit Custom Measure: Use this option to create or modify custom calculated measures

  2. Custom Column Builder: Direct access to build new custom columns with AI assistance

  • AI-Powered Formula Suggestions: After selecting your columns and naming your new column, click “Ask AI to suggest a formula” to let Custom Column Buddy intelligently generate the appropriate DuckDB expression based on your natural language description.

  • Type-Safe Expression Generation: Custom Column Buddy automatically handles data type conversions and applies proper CAST operations to ensure your expressions work correctly with different column types (String, Number, Date, etc.).

  • Custom Column Naming: Provide a descriptive name for your custom column (e.g., “Total”, “Profit Margin”, “Discount Amount”) to help organize and identify your calculated fields easily.

How to Use Custom Column Buddy

  1. Prepare Your Data

In the table widget, drag the required columns that you want to use in your custom calculation.

  1. Open Custom Column Builder

Choose one of the following options:

  • Option 1: Click “Add/Edit Custom Measure”

  • Option 2: Click “Custom Column Builder”

  1. Name Your Column

Enter a descriptive name for your new column (e.g., “Total”, “Revenue”, “Discount Applied”).

Step 4: Use AI to Generate Formula

Click “Ask AI to suggest a formula”

Enter your request in plain English describing what calculation you want

Custom Column Buddy will generate the DuckDB expression automatically