columns

Column Extraction

Functions for extracting selected columns from SQL queries. Handles SELECT and RETURNING clauses, including CTEs.

Types

A column selected in a SELECT or RETURNING clause. Tracks the optional table alias, column name or expression, and any AS alias.

pub type SelectedColumn {
  SelectedColumn(
    table: option.Option(String),
    name: String,
    alias: option.Option(String),
  )
}

SelectedColumn(
  table: option.Option(String),
  name: String,
  alias: option.Option(String),
)

</>

pub fn extract(sql: String) -> List(SelectedColumn)

Extract selected columns from SELECT or RETURNING clauses. Handles CTEs by finding the main SELECT at parenthesis depth zero.