Rowpath

Reference

SQL Functions

Use Rowpath SQL helpers and understand Working View SQL rules.

Current Table

Use current_data as the table name for the active dataset:

SELECT * FROM current_data LIMIT 100;

Preview Limits

The SQL inspector uses a 1,000-row preview limit for SELECT queries when no suitable limit is present. Run Full Query executes the SQL exactly as written.

Expression Helpers

Calculated Columns expose scalar expression helpers in these categories:

  • Math
  • Text
  • Date
  • Conditional
  • Null Handling
  • Conversion

Common helper functions include:

  • ROUND
  • ABS
  • CEIL
  • FLOOR
  • LOWER
  • UPPER
  • TRIM
  • CONCAT
  • STRFTIME
  • DATE_PART
  • DATE_DIFF
  • CASE WHEN
  • COALESCE
  • NULLIF
  • IFNULL
  • TRY_CAST
  • CAST

SQL Templates

SQL Templates generate query patterns for duplicates, blanks, whitespace, mixed-type values, likely invalid dates, counts, top values, distinct values, summary stats, min/max checks, comparisons, and starter workflow queries.

See SQL Templates.

Working View SQL Rules

SQL can become a Working View only when it preserves the current table shape. Compatible SQL is a single SELECT from current_data that keeps the current columns and only filters, sorts, or limits rows.

SQL that groups, joins, unions, pivots, unpivots, changes columns, or returns aggregate-only results should be saved as a derived result.

Notes

  • Calculated Columns accept scalar expressions, not full SELECT statements.
  • Use the SQL inspector for complete SQL queries.
  • The SQL engine supports broader SQL behavior than the surfaced helper list, but public docs should emphasize the helpers and templates Rowpath exposes directly.