Write SQL that generates custom columns or tables in your database. Rather than storing the data results, Chartio stores the SQL and inserts it directly into your Interactive Mode query.
Custom columns and tables simply generate nested SQL statements, and therefore cannot be referenced by name in SQL Mode.
Common use cases
- Use a CASE statement to create a column that categorizes rows
- Flatten your database by creating a custom table that joins multiple tables together
- Create simple calculated columns, such as converting cents to dollars