Sets the allowed aggregate functions for a column.

Options: :sum, :avg, :count, :min, :max

Sets the allowed call sites for a UDF registration.

Adds an argument definition to a UDF registration.

Sets the UNNEST array field/expression for named UNNEST members.

Sets the SQL alias/table name for named VALUES members.

Sets recursive CTE base query function.

Sets declared columns for CTE/VALUES query members.

Marks a column as computed (not from database).

Alias for rows/1 in named VALUES members.

Sets the default value for the filter.

Defines a column customization.

example

Example

defcolumn :price do
  label "Product Price"
  format :currency
  aggregate_functions [:sum, :avg]
end

Defines a named CTE preset for Selecto.with_cte/2.

example

Example

defcte :active_customers do
  query &__MODULE__.active_customers_cte/1
  columns ["id", "name"]
  join [owner_key: :id, related_key: :id, fields: :infer]
end

Defines a detail-row action.

example

Example

defdetail_action :customer_profile do
  name("Customer Profile")
  description("Open the customer profile in a new tab")
  type(:external_link)
  required_fields([:customer_id])
  payload(%{url_template: "https://app.example.test/customers/{{customer_id}}"})
end

Defines a custom filter.

example

Example

deffilter "price_range" do
  name "Price Range"
  type :string
  description "Filter by price range"
end

Defines a named UDF specification.

Defines a join configuration under the top-level joins registry.

example

Example

defjoin :initiative, %{
  type: :left,
  schema: MyApp.Initiative,
  owner_key: :initiative_id,
  related_key: :id
}

Defines a JSONB schema for a JSONB column, enabling typed field access, filtering, and display of structured JSON data.

example

Example

defjsonb_schema :attributes do
  field :color, :string, label: "Color"
  field :weight, :decimal, label: "Weight (kg)", precision: 2
  field :organic, :boolean, label: "Organic"
  field :origin_country, :string, label: "Country of Origin"
  field :certifications, {:array, :string}, label: "Certifications"
  field :dimensions, :object do
    field :width, :decimal, label: "Width"
    field :height, :decimal, label: "Height"
    field :depth, :decimal, label: "Depth"
  end
end

supported-field-types

Supported Field Types

• :string - Text values
• :integer - Whole numbers
• :decimal - Decimal numbers (supports precision option)
• :boolean - True/false values
• :date - Date values (ISO 8601 format)
• :datetime - DateTime values (ISO 8601 format)
• {:array, type} - Arrays of the specified type
• :object - Nested object (use nested field calls)

field-options

Field Options

• label - Human-readable label for display
• precision - Decimal precision (for :decimal type)
• required - Whether the field is required (default: false)
• default - Default value for the field
• filterable - Whether the field can be filtered (default: true)
• sortable - Whether the field can be sorted (default: true)
• format - Display format (:currency, :percentage, etc.)

Defines a named LATERAL preset for Selecto.with_lateral/2.

example

Example

deflateral :tag_expansion do
  source {:unnest, ""selecto_root"."tags""}
  as "tag_expansion"
  join_type :inner
end

Defines a modal detail-row action.

This is a convenience wrapper around defdetail_action that defaults type to :modal.

Defines a schema configuration under the top-level schemas registry.

example

Example

defschema :initiative, %{
  source_table: "initiatives",
  columns: %{id: %{type: :integer}, name: %{type: :string}}
}

Defines an association under a schema entry in schemas.

example

Example

defschema_assoc(:bundle_parent_load, :split_parent_load, %{
  queryable: :split_parent_load,
  field: :split_parent_load,
  owner_key: :split_parent_id,
  related_key: :id
})

Defines a root source association under source.associations.

example

Example

defsource_assoc(:bundle_parent_load, %{
  queryable: :bundle_parent_load,
  field: :bundle_parent_load,
  owner_key: :bundle_parent_id,
  related_key: :id
})

Defines a named subquery preset for Selecto.with_subquery/2.

example

Example

defsubquery :high_value_orders do
  query &__MODULE__.high_value_orders_subquery/1
  type :inner
  on [%{left: "id", right: "customer_id"}]
end

Defines a named UNNEST preset for Selecto.with_unnest/2.

example

Example

defunnest :product_tags do
  array_field "tags"
  as "tag"
  ordinality "tag_position"
end

Defines a named VALUES preset for Selecto.with_values/2.

example

Example

defvalues :status_lookup do
  rows [["active", "Active"], ["inactive", "Inactive"]]
  columns ["status", "label"]
  as "status_lookup"
  join [owner_key: :status, related_key: :status]
end

Sets CTE dependency names.

Sets the filter description/help text.

Defines a field within a JSONB schema.

This macro is only valid inside a defjsonb_schema block.

examples

Examples

# Simple field with type and label
field :color, :string, label: "Color"

# Field with multiple options
field :weight, :decimal, label: "Weight", precision: 2, required: true

# Array field
field :tags, {:array, :string}, label: "Tags"

# Nested object field
field :dimensions, :object do
  field :width, :decimal
  field :height, :decimal
end

Sets whether the column is filterable.

Sets the display format for a column.

Common formats: :currency, :percentage, :number, :date, :datetime, :yes_no

Sets join options for query member auto-join behavior.

Sets explicit join id for named subquery members.

Sets the join type for named LATERAL members.

Sets named subquery kind (:join currently supported).

Sets the human-readable label for a column or filter.

Alias for source/1 in named LATERAL members.

Sets the maximum display length for string columns.

Sets the human-readable name for a filter.

Sets ON conditions for named subquery members.

Sets the valid options for a select-type filter.

Sets ordinality alias for named UNNEST members.

Sets a payload map for a detail-row action.

Sets the numeric precision for decimal columns.

Sets a query builder function for named query members.

Sets recursive CTE recursive query function.

Sets whether the filter is required.

Sets required fields for a detail-row action.

Sets the declared return type or return metadata for a UDF registration.

Sets VALUES rows for a named defvalues member.

Sets whether the column is sortable.

Sets a source expression for named LATERAL members.

Sets the SQL function name for a UDF registration.

Sets the filter type.

Common types: :string, :integer, :boolean, :date, :datetime, :decimal